Upgrade 12.1.3 to 12.2: Applying AD Delta Patch 28840822 Failed with ORA-12154: TNS:could not resolve the connect identifier specified (Doc ID 2587409.1)

Last updated on FEBRUARY 16, 2023

Applies to:

Symptoms

Upgrade 12.1.3 to 12.2: Applying AD Delta Patch 28840822 Failed with ORA-12154: TNS:could not resolve the connect identifier specified.

Customer is upgrading from 12.1.3 to 12.2. Current release level is at 12.2.0 and applying AD/TXK delta patches as per document ID Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)


ERROR
-----------------------
AutoPatch version: 12.2.0
AutoPatch started at: Mon Sep 09 2019 23:32:58

APPL_TOP is set to /d01/oracle/PROD/fs1/EBSapps/appl

Defaults Feature Enabled = YES.
Non-Interactive Mode = YES.
Num Workers = 8.
Options = "hotpatch".
Patch Top = "/d01/oracle/PROD/fs_ne/EBSapps/patch/28840822".
Patch Driver File = "u28840822.drv".


ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

An error occurred while Running adtasktim.sql.

***
Continue as if it were successful :


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. adop phase=apply patches=28840822 hotpatch=yes.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Due to this issue, users cannot go ahead with upgrade.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.