WLST Command UpgradeConfig Fails - ORA-12505, TNS:Listener does not Currently Know of SID Given in Connect Descriptor (Doc ID 1905834.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Access Manager - Version 11.1.2.2.0 and later
Information in this document applies to any platform.

Symptoms

 wls:/offline> upgradeConfig("/oracle/iam_domains/oam_domain","sys", "welcome1", "DEV_OAM", "jdbc:oracle:thin:@oam.example.com:1521/orcl")
Jul 7, 2014 1:50:43 PM oracle.security.am.admin.config.util.DataConnectionUtility getConnection
WARNING: Failed to get connection
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:458)
       at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
       at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
       at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
       at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
       at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:280)
       at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:207)
       at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:157)
       at oracle.security.am.admin.config.util.DataConnectionUtility.getConnection(DataConnectionUtility.java:139)
       at oracle.security.am.upgrade.framework.psfe.util.PSFEUtils.validateDBConnectionDetails(PSFEUtils.java:232)
       at oracle.security.am.upgrade.framework.psfe.PSFEFramework.processOffline(PSFEFramework.java:193)
       at oracle.security.am.wlst.util.WLSTServerUtil.executeCommand(WLSTServerUtil.java:230)
       at oracle.security.am.wlst.WLSTWrapper.executeCommand(WLSTWrapper.java:152)
       at oracle.security.am.wlst.WLSTWrapper.execute(WLSTWrapper.java:107)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:597)
       at org.python.core.PyReflectedFunction.__call__(Unknown Source)
       at org.python.core.PyReflectedFunction.__call__(Unknown Source)
       at org.python.core.PyObject.__call__(Unknown Source)
       at org.python.core.PyObject.invoke(Unknown Source)
       at OamInternal_handler$py.patchUpgradeImpl$78(/u01/oracle/iammiddleware/Oracle_IDM1/common/script_handlers/OamInternal_handler.py:1313)
       at OamInternal_handler$py.call_function(/u01/oracle/iammiddleware/Oracle_IDM1/common/script_handlers/OamInternal_handler.py)
       at org.python.core.PyTableCode.call(Unknown Source)

....

However upgradeOpss is successful using the same connection parameter on the same machine.

Following is the OPSS version

SQL> SELECT VERSION, STATUS, UPGRADED FROM SCHEMA_VERSION_REGISTRY WHERE OWNER='DEV_OPSS';

VERSION                        STATUS      U
------------------------------ ----------- -
11.1.1.7.2                     VALID       Y

Cause

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 hundreds of Community platforms