GoldenGate SQL Server Extract Fails with a message "Failed to open the SQL Server process, x,yyy, with Windows system error 5."

(Doc ID 1914178.1)

Last updated on JULY 12, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.1 and later
Information in this document applies to any platform.

Symptoms

Starting the extract for SQL Server get the following failures :

ADD EXTRACT MSEXT, TRANLOG, BEGIN NOW
add rmttrail /opt/oracle/product/ggs/dirdat/ms, extract msext

the MSEXT.PRM file is :
H:\ggs>type dirprm\msext.prm
extract msext
sourcedb ggs
TRANLOGOPTIONS MANAGESECONDARYTRUNCATIONPOINT
rmthost paulie.kdc.capitalone.com, MGRPORT 7809
RMTTRAIL /opt/oracle/product/ggs/dirdat/ms, format release 11.2
table hrschema.emp;
table hrschema.emp2;

============================== Then in the GSSERR.log it abends
2014-07-25 16:36:52 INFO OGG-00993 Oracle GoldenGate Capture for SQL Server, MSEXT.prm: EXTRACT MSEXT started.
2014-07-25 16:36:57 INFO OGG-01226 Oracle GoldenGate Capture for SQL Server, MSEXT.prm: Socket buffer size set to 27985 (flush size 27985).
2014-07-25 16:36:57 INFO OGG-01052 Oracle GoldenGate Capture for SQL Server, MSEXT.prm: No recovery is required for target file /opt/oracle/product/ggs/dirdat/ms000000, at RBA 0 (file not opened).
2014-07-25 16:36:57 INFO OGG-01478 Oracle GoldenGate Capture for SQL Server, MSEXT.prm: Output file /opt/oracle/product/ggs/dirdat/ms is using format RELEASE 11.2.
2014-07-25 16:36:57 INFO OGG-00182 Oracle GoldenGate Capture for SQL Server, MSEXT.prm: VAM API running in single-threaded mode.
2014-07-25 16:36:57 INFO OGG-01515 Oracle GoldenGate Capture for SQL Server, MSEXT.prm: Positioning to begin time Jul 25, 2014 4:25:47 PM.
2014-07-25 16:36:57 INFO OGG-00178 Oracle GoldenGate Capture for SQL Server, MSEXT.prm: VAM Client Report .
2014-07-25 16:36:57 ERROR OGG-05209 Oracle GoldenGate Capture for SQL Server, MSEXT.prm: Failed to open the SQL Server process, 6,012, with Windows system error 5.
2014-07-25 16:36:57 ERROR OGG-01668 Oracle GoldenGate Capture for SQL Server, MSEXT.prm: PROCESS ABENDING.
2014-07-25 16:37:01 INFO OGG-00987 Oracle GoldenGate Comm

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms