Introduction: This blog is intended for DBA’s who may pass off with the below error message on applying a patch as hot patch in the instance. While applying adop hot patch ([UNEXPECTED] Error checking application tier services status.) was failed with the below error
Error:
Checking for existing adop sessions.
[UNEXPECTED] Error checking application tier services status.
[STATEMENT] Please run adopscanlog utility, using the command
“adopscanlog -latest=yes”
to get the list of the log files along with snippet of the error message corresponding to each log file.
adop exiting with status = 2 (Fail)
Cause: APPLSYSPUB user account must be expired
Solution: We need to update the applsyspub password and retry the adop hot patch. Below are the steps.
Step: 1. We need to update below profile as null and update the password.
In our case it was showing expired. So we had to change the password by using below command
1) alter profile password verify function null in (PDB INSTANCE)
2) use fndcpass and update same password for applsyspub
FNDCPASS APPS/$APPS_PWD 0 Y SYSTEM/$SYSTEM_PWD ORACLE APPLSYSPUB PUB
Step: 2. We need to rerun the adop hot patch again.
Happy Debugging!!