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 laterInformation 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 |