External Proxy User Authentication In GoldenGate (Doc ID 2689862.1)

Last updated on JULY 20, 2020

Applies to:

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

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