Skip to Main Content

Security Software

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OAAM database user is locked

KhanhJul 26 2017 — edited Jul 27 2017

Hello,

I am working on the IP Location Data load and used a wrong password in the weblogic/em --> weblogic domain/oam_domain/Security/credentials/oaam Map/oaam_db_key

Although I had fixed the entry for oaam_db_key, and the DBA had unlocked QA_OAAM database user, this database account kept being locked.

How can I update the QA_OAAM database user so that the application is using the correct password and not lock the account again?

Thanks

Khanh

Comments

handat

Restart OAAM instance. Best would be to shut down all OAAM instances, then update the password using EM before starting the OAAM instances again.

Khanh

I updated the QA_OAAM schema password in this path: weblogic domain/oam_domain/Security/credentials/oaam Map/oaam_db_key and restarted everything.  However, the QA_OAAM db account is still locked.

Where else do I need to update the password?

Thanks

Khanh

Khanh

I also unlocked the database account after restarting the oaam managed servers.

Khanh

Khanh

My issue has been resolved.

We updated the pwd in the database (to make sure we have the right pwd).

We updated the pwd in weblogic admin console/Service/Data Sources (for all 3 OAAM related data sources).

Shutdown all OAAM admin and managed servers

Logged into the database to unlock the oaam database account

Restarted the oaam admin server (monitor the oaam db account connection using sql developer) in weblogic

Restarted the oaam managed server in weblogic (monitor the oaam db account connection using sql developer).

Once all managed servers are up and running and the oaam db account is not locked, then the issue has been resolved.

Khanh

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 24 2017
Added on Jul 26 2017
4 comments
326 views