My Oracle Support Banner

E-Business Suite DBA 12.2 Patch (R12.AD.C) Fails With ORA-12514 listener does not currently know of service requested in connect descriptor (Doc ID 2021164.1)

Last updated on JANUARY 15, 2024

Applies to:

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

Symptoms

ISSUE SUMMARY
================

applying <Patch 10117518> fails with:

Calling /appsR122/applprod/fs1/EBSapps/comn/util/jdk/jre/bin/java ...
Exception in thread "main" java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:482)
  at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:678)
  at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:238)
  at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)

 

AutoPatch error:
A codeline or codelevel introducing patch cannot be applied in pre-install mode

AutoPatch error:
The following ORACLE error:

ORA-01017: invalid username/password; logon denied

occurred while executing the SQL statement:

CONNECT APPS/*****

AutoPatch error:
Unable to connect to APPS account

------------------------------------------------------------------------------------------------------------

adworker001.log  errors

Dropping packages no longer used in Release 11.5 and 12.0

drop package bb_dist
*
ERROR at line 1:
ORA-04043: object BB_DIST does not exist

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.