This content has been marked as final. Show 5 replies
You need to make that schema owner have a non-expiring password in the database (DEV_BIPLATFORM or Prefix_BIPLATFORM depending on what you prefixed it with). It shouldn't get locked on it's own unless there's a default setting for the same in the database.1 person found this helpful
Please award points if helpful/correct.
Thanks for taking time and replaying.
I checked that DEV_BIPLATFORM owner has non -expiring password. When i queried for the account status it givens the account_status as "locked (timeout)" in the database. This is happening randomly i am not sure where i can find what is the root cause of the account is getting locked.
Any help on finding which log file i need to refer.
Thanks in advance
Just try unlocking using dba account and check the results
Alter user dev_biplatform account unlock;
Alter user account identified by password;
Just a follow up.
Let me know if it is working ? If yes mark as correct and close the thread.