REP-0501 and ORA-12516 Error while applying Arabic TST patch

(Doc ID 2323677.1)

Last updated on NOVEMBER 01, 2017

Applies to:

Oracle Applications DBA - Version 12.2.6 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Online Patching - OP

When attempting to Apply Arabic TST patch the following error occurs:

ADOP Log

phase=apply patches=27049202_AR:u27049202.drv restart=yes workers=8
[END 2017/11/01 09:35:11] Arguments passed to adop
[STATEMENT] Verifying parameters
[STATEMENT] Sourcing Run edition environment EBSapps/appl/APPS<SID_prod>.env
[UNEXPECTED]Error occurred executing "adpatch abandon=no restart=yes workers=27 console=no interactive=no defaultsfile= fs2/EBSapps/appl/admin/PROD_patch/adalldefaults.txt patchtop= fs_ne/EBSapps/patch/27049202_AR driver=u27049202.drv

logfile=u27049202.log"

  [UNEXPECTED]Refer to the log files for more information.
  [STATEMENT] SQL Statment : " update ad_adop_session_patches
  set status='F'
  where adop_session_id=4 and status='R' and node_name='prod'
"
  [UNEXPECTED]Apply phase has failed.
  [PROCEDURE] [START 2017/11/01 09:53:00] Updating adop session status
  [STATEMENT] SQL statement : " update ad_adop_sessions
  set status='F'
  where adop_session_id = 4 and appltop_id = 196 and node_name='prod'

Found Many Oracle Reports objects did not generate successfully in worker log and patch log. 

Example Oracle Reports objects did not generate successfully as below.

Generating report "CEFCERR.rdf" with command:

/u01/PROD/fs2/EBSapps/10.1.2/bin/rwconverter source=/u01/PROD/fs2/EBSapps/appl/ce/12.0.0/reports/AR/CEFCERR.rdf dest=/u01/PROD/fs2/EBSapps/appl/admin/PROD_patch/out/tmp015.rdf stype=rdffile dtype=rdffile overwrite=yes batch=yes compile_all=yes
Enter Userid:
Enter Password:
Enter Password:
REP-0501: Unable to connect to the specified database.
ORA-12516: TNS:listener could not find available handler with matching protocol stack

REP-0501: Unable to connect to the specified database.
ORA-12516: TNS:listener could not find available handler with matching protocol stack

REP-0501: Unable to connect to the specified database.
ORA-12516: TNS:listener could not find available handler with matching protocol stack

REP-0309: Unable to connect to the specified database after three attempts. Access denied.

Report Builder: Release 10.1.2.3.0 - Production on Wed Nov 1 09:52:13 2017

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

Enter Username: Enter Username:
ERROR [code=1] generating report "CEFCERR.rdf" from input file
/u01/PROD/fs2/EBSapps/appl/ce/12.0.0/reports/AR/CEFCERR.rdf

Generated 0 files successfully.
Generated 0 files with non-fatal warnings.
Generated 1 files with fatal errors.

adrepgen is exiting with status 1

End of adrepgen session
Date/time is Wed Nov 01 2017 09:52:13
**********************************************************

Generating report "CEFCERR.rdf" with command:

/u01/PROD/fs2/EBSapps/10.1.2/bin/rwconverter source=/u01/PROD/fs2/EBSapps/appl/ce/12.0.0/reports/AR/CEFCERR.rdf dest=/u01/PROD/fs2/EBSapps/appl/admin/PROD_patch/out/tmp015.rdf stype=rdffile dtype=rdffile overwrite=yes batch=yes compile_all=yes
Enter Userid:
Enter Password:
Enter Password:
REP-0501: Unable to connect to the specified database.
ORA-12516: TNS:listener could not find available handler with matching protocol stack

REP-0501: Unable to connect to the specified database.
ORA-12516: TNS:listener could not find available handler with matching protocol stack

REP-0501: Unable to connect to the specified database.
ORA-12516: TNS:listener could not find available handler with matching protocol stack

REP-0309: Unable to connect to the specified database after three attempts. Access denied.

Report Builder: Release 10.1.2.3.0 - Production on Wed Nov 1 09:52:13 2017

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

Enter Username: Enter Username:
ERROR [code=1] generating report "CEFCERR.rdf" from input file
/u01/PROD/fs2/EBSapps/appl/ce/12.0.0/reports/AR/CEFCERR.rdf

Generated 0 files successfully.
Generated 0 files with non-fatal warnings.
Generated 1 files with fatal errors.

adrepgen is exiting with status 1

End of adrepgen session
Date/time is Wed Nov 01 2017 09:52:13
**********************************************************

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Download Arabic TST patch given from Oracle
2. Source Run file system
3. Apply Arabic TST patch using ADOP cycle

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Not able to release the instance to user

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms