My Oracle Support Banner

After 19C Upgrade Register OID Fails With -ORA-12505, TNS:listener Does Not Currently Know Of SID (Doc ID 2695075.1)

Last updated on JULY 18, 2023

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, OID SSO Technologies

After 19C DB upgrade unable to register OID

When attempting to register OID
the following error occurs.

ERROR
-----------------------
*** ERROR : Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
dbor-ebs-dev1:1521:ebsdev


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. DB was upgraded to 19C
2. Attempt to re-register OID
3. Error occurs

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot register OID with EBS and 19C DB

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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