8.0.2 PortC.jar Command Fails with 'java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver' and ORA-12505 (Doc ID 2172127.1)

Last updated on MARCH 03, 2023

Applies to:

Symptoms

After upgrading to OFSAAI 8.0.2, when running he command " java -jar PortC.jar DMP " from $FIC_HOME, the following error is thrown:

ERROR

OFSA80_HOME>java -jar PortC.jar DMP
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver"
       at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
       at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
       at java.security.AccessController.doPrivileged(Native Method)
       at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
       at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
       at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
       at ja va.lang.ClassLoader.loadClass(ClassLoader.java:358)
       at java.lang.Class.forName0(Native Method)
       at java.lang.Class.forName(Class.java:191)
       at PortC.ConfigurePorts.createPropertiesFile(ConfigurePorts.java:1470)
       at PortC.ConfigurePorts.main(ConfigurePorts.java:7718)
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:419)
       at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
       at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
       at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
       at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
       at java.sql.DriverManager.getConnection(DriverManager.java:571)
       at java.sql.DriverManager.getConnection(DriverManager.java:215)
       at PortC.ConfigurePorts.createPropertiesFile(ConfigurePorts.java:1475)
       at PortC.ConfigurePorts.main(ConfigurePorts.java:7718)
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:386)
       at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1054)
       at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)
      ... 8 more

As a result of the failed command, you cannot use the PortC.jar utility.

Cause

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