Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OGGCORE_12.1.2.1.1 Unable to open credential store. Error code 28759

user11991191Jul 17 2015 — edited Jul 26 2015

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 23 2015
Added on Jul 17 2015
3 comments
2,323 views