Goldengate 18c, Microservices Architecture
adminclient was running fine. dblogin was successful. Some time later, all commands throw error
ERROR: Authorization failure for user 'admingg'.
where admingg is the username I use to login to the web interface. Trying to login in the web browser, the error is
Invalid Username or Password!
The database account is open, not expired, and I can use sqlplus to login, and see replicat sessions and AS0X sessions in v$session.program.
I find that adminclient is just like a web client talking to adminsrvr, which tries to open cwallet.sso at /u01/app/oggsm/g18oracs8/var/lib/credential/secureStore. Surprisingly, this file is now 0 in size. Its timestamp (or very likely the time it became empty) is about the time the file system was full. After cleaning up the file system to release space, I tried to use orapki to recreate the file but didn't figure out how to add credential to it.
$ /u01/app/ogg/bin/orapki wallet create -wallet . -pwd "mypassword123" <-- PKCS#12 wallet ewallet.p12 is created
$ /u01/app/ogg/bin/orapki wallet create -wallet . -auto_login -pwd "mypassword123" <-- auto-login wallet cwallet.sso is created based on the PKCS#12 wallet
I still get authorization failure. Check the wallets:
$ /u01/app/ogg/bin/orapki wallet display -wallet ewallet.p12
Oracle PKI Tool : Version 12.2.0.1.0
Copyright (c) 2004, 2016, Oracle and/or its affiliates. All rights reserved.
Enter wallet password:
null
$ /u01/app/ogg/bin/orapki wallet display -wallet cwallet.sso
Oracle PKI Tool : Version 12.2.0.1.0
Copyright (c) 2004, 2016, Oracle and/or its affiliates. All rights reserved.
Enter wallet password:
null
Apparently, the wallet files are missing the actual credential. I'm sure one of the commands at
https://docs.oracle.com/database/121/DBSEG/asoappf.htm
is what I want. If not, how can I re-create the auto-login or sso wallet?
Also, is there a way to completely bypass the wallet? Security is not a concern for me. (For example, when I set up distribution, I chose target protocol ogg, instead of the default wss.)
Where can I find the procedure to reset the password? I searched documentation, MOS, Google and found no document.
This problem happened before: cwallet.sso being 0 in size coincides with file system being full. I don't understand the connection between them. Thanks for any help.