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:

Manage Inactive session in Oracle 23AI Database.

# CONNECT WITH PDB DATABASE(ORACLE 23AI) [oracle@prd-23ai ~]$ sqlplus / as sysdba  SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engin...