Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Friday, July 20, 2012

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.

conn system/passwd
select username,status from dba_users where username='APPS'

APPS  locked

SQL> Alter username apps account unlock;

change failed_login_attempts:

SQL> alter profile default limit failed_login_attempts 10;

Profile altered.

SQL> exit

No comments: