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 SEPTEMBER 02, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.2 to 8.0.2 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)

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

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