ORA-28000: the account is locked

APP-FND-0156 Cause: AFPCOA failed due to ORA-28000: the account is locked


APP-FND-01564: ORACLE error 28000 in AFPCOA

Cause: AFPCOA failed due to ORA-28000: the account is locked

Solution:
Apps account is locked please unlock the apps account and if needed increase the profile option FAILED_LOGIN_ATTEMPTS in the database if/to appropriate.


Enter user-name: system
Enter password:*****

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing option                          s


SQL> select username from dba_users where username='APPS';

USERNAME
------------------------------
APPS


SQL> alter user apps account unlock;

User altered.

SQL> !

No comments:

How to set the schema session limit in Oracle 23 AI Database.

  In Oracle, to set a session limit per schema (user)—i.e., control how many concurrent sessions a specific user can have. You use profiles ...