Tuesday, October 18, 2016

adtasktim.sql ORA-01017: invalid username/password; logon denied

adtasktim.sql ORA-01017: invalid username/password; logon denied 

Got error while while doing adop phase=abort. 

EBS 12.2 applications and utilities unable to access database

problem resolved after setting sec_case_sensitive_logon parameter

ACTION PLAN:
During apply phase -- and subsequently abort , adtasktim.sql script is failing because password for applsys user is not recognized anymore.
So, reset the password for applsys to exactly what was at the time when the patching process was initiated (adop session id #). (you can use FNDCPASS)

also verify value for db parameter: sec_case_sensitive_logon :

show parameter sec_case_sensitive_logon;

--> and set it temporarily to FALSE, in case the value returned for the query above is TRUE (you can use: alter system set sec_case_sensitive_logon = FALSE)

This way adop will be able to recognize the password.
Test first the sqlplus connection for the applsys -- to confirm .

Then, re-initiate adop phase=abort.

3-11464439901 - Oracle Applications DBA 12.2.4
1001: "ORA-01017: invalid username/password; logon denied" While applying patch 19007053

SOLUTION: My problem is now resolved by changing parameter sec_case_sensitive_logon to false in the init.ora en spfile.ora. 
  

No comments: