My Oracle Support Banner

Upgrade Assistant Causes "ORA-12505, TNS:listener does not currently know of SID given in connect descriptor" (Doc ID 1624492.1)

Last updated on APRIL 08, 2018

Applies to:

Identity Manager - Version 11.1.1.5.0 and later
Information in this document applies to any platform.

Goal

When using Upgrade assistant to upgrade from OIM 9 to OIM 11G we get the following error :

 [INCIDENT_ERROR] [] [upgrade.OIM] [tid: 10] [ecid: 0000KGfCykB0jo^pxS^AyW1IzB_I000001,0] UPGCMP-2903: Unable To Connect to target Database
[2014-02-13T20:24:33.282+08:00] [OIM] [INCIDENT_ERROR] [] [upgrade.OIM] [tid: 10] [ecid: 0000KGfCykB0jo^pxS^AyW1IzB_I000001,0] [[
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
 
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:443)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:670)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:230)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at oracle.ias.upgrade.config.oim.OIMPluginUtil.testMDSDBConnection(OIMPluginUtil.java:134)
at oracle.ias.upgrade.config.oim.OIMFeatureUpgradePlugin.doPrecheck(OIMFeatureUpgradePlugin.java:150)
at oracle.ias.upgrade.config.oim.OIMFeatureUpgradeItem.doUpgrade(OIMFeatureUpgradeItem.java:79)
at oracle.ias.upgrade.config.oim.OIMConfigUpgrade.doUpgrade(OIMConfigUpgrade.java:179)
at oracle.ias.upgrade.UpgradeSupport.doUpgrade(UpgradeSupport.java:1823)
at oracle.ias.upgrade.UpgradeFramework.doUpgradePhase(UpgradeFramework.java:716)
at oracle.ias.upgrade.MidTier.execute(MidTier.java:246)
at oracle.ias.upgrade.UpgradeDriver.mtUpgradeCLI(UpgradeDriver.java:291)
at oracle.ias.upgrade.UpgradeDriver.main(UpgradeDriver.java:189)
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
 
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:410)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1176)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:318)
... 15 more

]]

 

Solution

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
Goal
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.