adop fails with "invalid username/password; logon denied" for custom schema XX*
Below error encountered in the txk delta level 10 patching . Please go through this post to fix this issue.
Error:
===========================================================
Done running adaaddlb.pls for YMS
sqlplus -s XXCUST/***** @/ut9001/nadhans/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/ut900/nadhans/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adaddls.pls ***** XXCUST *****'
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.
Solution:
1. Validate and change the XXCUST password by using FNDCPASS.
FNDCPASS apps/apps 0 Y system/manager ORACLE XXCUST XXCUSTT
Above Solution will fix the issue .
If still its failing you can perform the below.
2. Validate and Correct the password in xxdprod.tx. (cd $APPL_TOP/admin).
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.
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.
No comments:
Post a Comment