adoacorectl.sh causes APPLSYSPUB user to be LOCKED
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
------------------------------ --------------------------------