Technology Stack - EBS (MOSC)

MOSC Banner

adoacorectl.sh causes APPLSYSPUB user to be LOCKED

edited Mar 19, 2014 9:55AM in Technology Stack - EBS (MOSC) 3 commentsAnswered ✓

Working with a customer on an 12.1.3 instance.

The issue is that the login screen is not coming up when all services are started. After some research, we identified that the APPLSYSPUB user is getting LOCKED every time the script 'adoacorectl.sh start' is run.


Here is what we did:


1. Unlock APPLSYSPUB user and set the failed_login_attempts to unlimited:


SQL> alter profile DEFAULT limit failed_login_attempts unlimited;
SQL> alter user APPLSYSPUB account unlock;


2. Verify the status of the APPLSYSPUB user:

SQL>  select username,account_status from dba_users where username like 'APP%';

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center