Routine AFPCSQ encountered an ORACLE error. ORA-01017: invalid username/password; logon denied

ISSUE:

_ 1 _
Routine AFPCMT encountered an ORACLE error. ORA-01012: not logged on.

Review your error messages for the cause of the error. (=<POINTER>)
_ 2 _
Routine AFPCSQ encountered an ORACLE error. ORA-01017: invalid
username/password; logon denied
.
Review your error messages for the cause of the error. (=<POINTER>)

The issue is caused by enabling 11g password case sensitivity. 


SOLUTION:

To implement the solution, please execute the following steps:

1. Disable the case sensitive 11g feature 

 show parameter SEC_CASE_SENSITIVE_LOGON

NAME                           TYPE        VALUE
------------------------------------------------------------------

sec_case_sensitive_logon       boolean   TRUE

   alter system set sec_case_sensitive_logon=false;
   
2. Stop applications and database

3. Start Database and Applications.

(OR)

Need to apply Patch 12964564:R12.FND.B and follow the readme instruction.

ensure that your sqlnet_ifile.ora has the below line

SQLNET.ALLOWED_LOGON_VERSION_SERVER = 10 (if SEC_CASE_SENSITIVE_LOGON is set to TRUE)

Restart Database and listener.

Try to change password and Start applications. Now the Concurrent managers will run as expected.

Refer: 1581584.1