My Oracle Support Banner

External Proxy User Authentication In GoldenGate (Doc ID 2689862.1)

Last updated on JULY 20, 2020

Applies to:

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

Symptoms

While doing dblogin at ggsci prompt it fails:

------------------------------User Created in DB --------------------------------------------------
create user GG_PROD_PROXY identified externally as 'CN=xxxxx.ux.db.com,O=xxxxx,DC=db,DC=com';
create user GG_DR_PROXY identified externally as 'CN=xxxxx.ux.db.com,O=xxxxx,DC=db,DC=com';
create user ggate identified by password;

alter user ggate grant connect through GG_DR_PROXY;
alter user ggate grant connect through GG_PROD_PROXY;

GGSCI (xxxxx.ux.db.com) 2> dblogin userid [ggate]@XXXXX.UX.DB.COM
Password:
ERROR: USERID and PASSWORD required.

I need to be able to login using proxy user with out prompting for a password and with out using
credential store to store passwords.

After creating proxy user we are able to connect with in ggsci using ==> ggsci> dblogin userid /@<SID>:

GGSCI (xxxxx.ux.db.com) 2> dblogin userid /@XXXXX.UX.DB.COM
Successfully logged into database.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.