adop fails with "invalid username/password; logon denied" for custom schema

Below error encountered in the txk delta level 10 patching . Please go through this post to fix this issue.

Scenario :

Applying patch 25828573.
    Log: /a01/appsclone/CLONE/fs_ne/EBSapps/log/adop/34/20180926_150103/apply/ahqtest/25828573/log/u25828573.log

***
Continue as if it were successful :
***

AutoPatch could not find a response to the above prompt
in the defaults file.

The patch has FAILED,
Please check the adpatch logs for more details.

You should check the file
/a01/appsclone/CLONE/fs_ne/EBSapps/log/adop/34/20180926_150103/apply/ahqtest/25828573/log/u25828573.log

for errors.

    [UNEXPECTED]Error occurred executing "adpatch  abandon=yes restart=no workers=16   options=hotpatch     console=no interactive=no  defaultsfile=/a01/appsclone/CLONE/fs2/EBSapps/appl/admin/CLONE/adalldefaults.txt patchtop=/a01/appsclone/CLONE/fs_ne/EBSapps/patch/25828573 driver=u25828573.drv logfile=u25828573.log"
    [UNEXPECTED]Refer to the log files for more information.
    [UNEXPECTED]Apply phase has failed.


[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.



We can get the detailed information from the adop log

/a01/appsclone/CLONE/fs_ne/EBSapps/log/adop/34/20180926_150103/apply/*****/25828573/log/u25828573.log


Error :


sqlplus -s XX***/***** @/a01/appsclone/CLONE/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/a01/appsclone/CLONE/fs2/EBSapps/appl/
ad/12.0.0/patch/115/sql/adaddls.pls ***** XX*** *****'
ERROR:
ORA-01017: invalid username/password; logon denied



An error occurred while running a SQL*Plus script.

***
Continue as if it were successful :
***

AutoPatch could not find a response to the above prompt
in the defaults file.

The patch has FAILED,
Please check the adpatch logs for more details.

You should check the file
/a01/appsclone/CLONE/fs_ne/EBSapps/log/adop/34/20180926_150103/apply/****/25828573/log/u25828573.log

for errors.

adop could not connect to custom schema to execute the script, thus patch is resulting into error. Perform the below to fix this issue. 

Solution :

Script location : $AD_TOP/patch/115/sql

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @adaddls.pls
Enter value for 1: *********** (System Password)
Connected.
Enter value for 2: XXCUST (Custom username)
old   1: grant create procedure to &&2
new   1: grant create procedure to XXCUST

Grant succeeded.

old   1: ALTER SESSION SET CURRENT_SCHEMA = &2
new   1: ALTER SESSION SET CURRENT_SCHEMA = XXCUST

Session altered.

old   2:   execute immediate 'drop synonym &2..APPS_DDL';
new   2:   execute immediate 'drop synonym XXAHQ.APPS_DDL';

PL/SQL procedure successfully completed.


Package created.


Commit complete.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
bash-3.2$ sqlplus system

SQL*Plus: Release 10.1.0.5.0 - Production on Wed Sep 26 15:32:07 2018

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @adaddlb.pls
Enter value for 1: ********* (System password)
Connected.
Enter value for 2: XXCUST
old   8:        where grantee='&2'
new   8:        where grantee='XXCUST'
Enter value for 2: XXCUST
old  14:     execute immediate 'grant execute on sys.dbms_sql to &&2';
new  14:     execute immediate 'grant execute on sys.dbms_sql to XXCUST';

PL/SQL procedure successfully completed.

old   1: ALTER SESSION SET CURRENT_SCHEMA = &2
new   1: ALTER SESSION SET CURRENT_SCHEMA = XXCUST

Session altered.


Package body created.


Commit complete.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Manually connect to the schema and confirm whether its working.

Retry the adop once again. you can use the below :

adop phase=apply patches=patch_number abandon=no restart=yes

If its failing you can perform the below.

As you can see the error above it was failing at the step below. So i ran the step below manually.


sqlplus -s XXCUST/XXCUST @/a01/appsclone/CLONE/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/a01/appsclone/CLONE/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adaddls.pls opensys_33 XXCUST XXCUST'


I was able to run adop without any issue with autoskip flag option.

adop phase=apply patches=25828573 abandon=no restart=yes flags=autoskip 

we can use the below to skip the failed adop session or if you manually performed the failed step. 

abandon=no restart=yes flags=autoskip 

This command will restart the patch once again from starting onwards and will skip all the failures if any comes. But make sure to review the log file at the end of the patch application that you have skipped the failures that you want to.

Thanks!
Sikky