Hi,
I've created credential store and create a alias with a domain as below. I'm able to login using DBLOGIN USERIDALIAS ggs_itbwp1 DOMAIn qatgg but not able to use USERIDALIAS in extract parameter file.
When I start the extract I get below error. Source DB is 11.2.0.1 version and GG version is 12.1.2.1.1.
Appreciate any help in this regards.
2015-07-17 09:29:03 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT_TB1 starting.
2015-07-17 09:29:03 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, EXT_TB1.prm: EXTRACT EXT_TB1 starting.
2015-07-17 09:29:03 INFO OGG-03059 Oracle GoldenGate Capture for Oracle, EXT_TB1.prm: Operating system character set identified as ISO-8859-1.
2015-07-17 09:29:03 INFO OGG-02695 Oracle GoldenGate Capture for Oracle, EXT_TB1.prm: ANSI SQL parameter syntax is used for parameter parsing.
2015-07-17 09:29:03 INFO OGG-02095 Oracle GoldenGate Capture for Oracle, EXT_TB1.prm: Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.AL16UTF16.
2015-07-17 09:29:03 ERROR OGG-00303 Oracle GoldenGate Capture for Oracle, EXT_TB1.prm: Unable to open credential store. Error code 28759.
2015-07-17 09:29:03 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, EXT_TB1.prm: PROCESS ABENDING.
Credential Store Details :
GGSCI (ditenbw101 as ggs_owner@itbwp1) 3> info credentialstore
Reading from /db01/goldengate/12.1.2.1.1/dircrd/:
No information found in default domain OracleGoldenGate.
Other domains:
qatgg
To view other domains, use INFO CREDENTIALSTORE DOMAIN <domain>
GGSCI (ditenbw101 as ggs_owner@itbwp1) 5> info credentialstore domain qatgg
Reading from /db01/goldengate/12.1.2.1.1/dircrd/:
Domain: qatgg
Alias: ggs_itbwp1
Userid: ggs_owner@itbwp1
Regards,
Dhanda