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 add a datafile to a bigfile tablespace in Oracle 23ai Database.

  Syntax for Bigfile Tablespace: SQL > ALTER TABLESPACE tablespace_name ADD DATAFILE SIZE 10G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED; Ho...