• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Ebuisness Suite » Troubleshooting ADOP failures in R12.2

Troubleshooting ADOP failures in R12.2

December 16, 2021 by techgoeasy Leave a Comment

Here are a few troubleshooting tips for ADOP failures in R12.2

Table of Contents

  • How to set service ebs_patch in R12.2
  • How to create TNS_ADMIN files in-case deleted
  • FUNCTION: main::validatePatchLocation
  • How To Allow ADOP To Continue As If It Were Successful After Hitting An Error While Applying Patch
  • ERRORMSG: ERROR: Parameter ‘patches’ was passed incorrectly. For usage, enter adop -? or adop -help.
  • Adop apply fails with ” Do you wish to apply this patch now [No] 

How to set service ebs_patch in R12.2

While running adop phase=prepare, we receive below error

[ERROR] Error Message : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach)

Need to check for service in the listener ebs_patch

$ lsnrctl status TSTDB1

LSNRCTL for Solaris: Version 12.2.0.2.0 – Production on 02-JAN-2021 12:56:30
Copyright (c) 1991, 2017, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=tech.com)(PORT=1521)))
STATUS of the LISTENER
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= =tech.com )(PORT=151)))
Services Summary…
Service ” TSTDB1 ” has 2 instance(s).
Instance ” TSTDB1 “, status UNKNOWN, has 1 handler(s) for this service…
Instance ” TSTDB1 “, status READY, has 1 handler(s) for this service…
Service ” TSTDB1 _ebs_patch” has 1 instance(s).
Instance ” TSTDB1 “, status READY, has 1 handler(s) for this service…
Service “ebs_patch” has 1 instance(s).
Instance ” TSTDB1 “, status READY, has 1 handler(s) for this service…
The command was completed successfully

The local_listener is not set properly in the init.ora parameter file.

TSTDB1 _LOCAL=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=tech.com)(PORT=1521))
)

SOLUTION
To implement the solution test the following steps in a development instance and then migrate accordingly:

  1. Ensure a valid backup exists before testing the solution.
  2. Check if the local_listener is set incorrectly by using:

At the RDBMS HOME:


sqlplus / as sysdba
SQL>show parameter local_listener
NAME TYPE VALUE
—— – —– ——–
local_listener string

In this scenario, The value is not set in this Environment. Set the value as per the below command

sqlplus / as sysdba
alter system set local_listener = TSTDB1 _LOCAL ;

  1. Restart the Database tier and the listener.
  2. Execute the “adop phase=prepare” again and confirm the error no longer occurs.

How to create TNS_ADMIN files in-case deleted

You get the below error while executing adop

[ERROR] Invalid connect string - cannot connect to database
Invalid Connect string - cannot connect to database
ERROR:
ORA-12521: TNS:listener does not currently know of instance requested in
connect descriptor
Invalid connect string - cannot connect to database
Invalid Connect string - cannot connect to database

Solution

tnsnames. ora is deleted on Patch filesystem

a. Please execute the following actions on both nodes.

  1. Source Patch File system env file
  2. Backup all files under $TNS_ADMIN
  3. Run adgentns.pl on Patch file system
    perl $AD_TOP/bin/adgentns.pl contextfile=$CONTEXT_FILE appspass=<pass>
  4. check the Confirm that DB connection is established from Patch file system


FUNCTION: main::validatePatchLocation


You get the below error while running adop phase=prepare

FUNCTION: main::validatePatchLocation [ Level 1 ]
ERRORMSG: Directory …/fs_ne/EBSapps/patch/346966464 does not exists.

Root Cause

One cannot remove patch files until AFTER running another online patching cycle or fs_clone.

run an online patching cycle to apply patch 3469664

$ adop phase=prepare
$ adop phase=apply patches= 346966464
$ adop phase=finalize
$ adop phase=cutover
$ adop phase=cleanup

One might think it is now safe to remove files from $PATCH_TOP, but not yet until after the next patching cycle.

run another online patching cycle

$ adop phase=prepare
$ adop phase=apply patches=22222222
$ adop phase=finalize
$ adop phase=cutover
$ adop phase=cleanup

Now it is safe to remove the $PATCH_TOP files for patch 3469664.

Solution

In this particular case, please restore the patch or run fs_clone

How To Allow ADOP To Continue As If It Were Successful After Hitting An Error While Applying Patch

ADOP patch session fail form / report compilation.Following error is reported

An error occurred while generating Oracle Forms files. 
Continue as if it were successful :
AutoPatch could not find a response to the above prompt in the defaults file.

Solution:-

abandon=no restart=yes flags=autoskip

example: adop phase=apply patches= 3469664 abandon=no restart=yes flags=autoskip

In addition to the autoskip option creates a new logfile called asautoskip.log

ERRORMSG: ERROR: Parameter ‘patches’ was passed incorrectly. For usage, enter adop -? or adop -help.

adop failed with below error

TIME : Wed Mar 20 11:41:35 2021
FUNCTION: ADOP::GlobalVars::_ValidateApplyArgs [ Level 1 ]
ERRORMSG: ERROR: Parameter 'patches' was passed incorrectly. For usage, enter adop -? or adop -help.

Cause

Patches parameters have been passed incorrectly. If the driver name is different from that directory name, then we need to specify the driver name after the directory

patches= 3469664_F: u3469664 .drv

Adop apply fails with ” Do you wish to apply this patch now [No] 

Node: FAILED
Apply status: FAILED
[UNEXPECTED] Apply phase has failed.
[ERROR] adop phase=apply failed on Node: ""
[ERROR] adop phase=apply failed or is incomplete on Admin node:
[ERROR] Unable to continue processing on other available nodes: ,
[UNEXPECTED] Error running "adop phase=apply" on node(s): .

The following error is reported in the log file


This base patch contains files that may require translation
depending on the languages you currently have installed.
Oracle Corporation recommends that you obtain any translated versions of this
patch for each of your non-US languages after applying this base patch.
Or you may request and apply a Translation Synchronization Patch
to obtain the translation.
Do you wish to apply this patch now [No] ? No

Cause

The adalldefaults.txt was providing the default answer “No” during the patch application.

As per the following output:

$APPL_TOP/admin/${TWO_TASK}/adalldefaults.txt

Start of Defaults Record

%%START_OF_TOKEN%%
MISSING_TRANSLATED_VERSION
%%END_OF_TOKEN%%

%%START_OF_VALUE%%
No
%%END_OF_VALUE%%

End of Defaults Record

Solution

Please change the: $APPL_TOP/admin/${TWO_TASK}/adalldefaults.txt:

## Start of Defaults Record
 %%START_OF_TOKEN%%
  MISSING_TRANSLATED_VERSION
 %%END_OF_TOKEN%%

 %%START_OF_VALUE%%
Yes
 %%END_OF_VALUE%%
## End of Defaults Record

I hope you like this post and it helps in your day to day administration work

Related Articles

ADOP command
adopmon and adopreports utility R12.2.5
adopscanlog log analyzer utility in R12.2
Adop(Ad online patching utility) explained R12.2
what happens in the adop phase prepare

Filed Under: Oracle, Oracle Ebuisness Suite

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to use sed replace string in file
  • Password Version in oracle
  • How to login as user without changing the password in Oracle database(alter user identified by values)
  • How to check encrypted tablespace in the Database
  • How To Export -Import TDE Master Encryption Key

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us