Sunday 14 July 2013

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


Meta link id:R12: Concurrent Manager Are In Inactive/No Manager State  With "Error ORA-01017: invalid username/password; logon denied" [ID 1495818.1]

Concurrent manager log file contain below error message
========================================

The Internal Concurrent Manager has encountered an error.

Review concurrent manager log file for more detailed information. : 03-JUL-2013 00:20:15 -

Shutting down Internal Concurrent Manager : 03-JUL-2013 00:20:15

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

Review your error messages for the cause of the error. (=)

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

List of errors encountered:
.............................................................................
_ 1 _
Routine AFPCAL received failure code while parsing or running your
concurrent program CPMGR

Review your concurrent request log file for more detailed information.
Make sure you are passing arguments in the correct format.
.............................................................................
The ebstest_0703@ebstest internal concurrent manager has terminated with status 1 - giving up.

Cause

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
2. Restart Concurrent Manager


SQL> show parameter sec

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_securefile string PERMITTED
optimizer_secure_view_merging boolean FALSE
sec_case_sensitive_logon boolean TRUE
sec_max_failed_login_attempts integer 10
sec_protocol_error_further_action string CONTINUE
sec_protocol_error_trace_action string TRACE
sec_return_server_release_banner boolean FALSE
sql92_security boolean FALSE
SQL> alter system set sec_case_sensitive_logon=FALSE;

System altered.

SQL>


After doing above step concurrent manager came up !!!

2 comments: