'Create_migration_script.sh' Script Throwing Exception in 6.4.x (Doc ID 2172219.1)

Last updated on AUGUST 15, 2016

Applies to:

Oracle Transportation Management - Version 6.4.1 to 6.4.2 [Release 6.4]
Information in this document applies to any platform.

Symptoms

When attempting to run a Customizations Migration script after upgrading from 6.3.x to 6.4.x, the following error occurs.

ERROR
-----------------------
./create_migration_script.sh /opt/oracle/otmapp/otm637/

com.oracle.migrate.DatabaseRun openConnection
SEVERE: null
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 java.lang.ClassLoader.loadClass(ClassLoader.java:358)
  at java.lang.Class.forName0(Native Method)
  at java.lang.Class.forName(Class.java:191)
  at com.oracle.migrate.DatabaseRun.openConnection(DatabaseRun.java:34)
  at com.oracle.migrate.DatabaseRun.execute(DatabaseRun.java:48)
  at com.oracle.migrate.CreateMigrateScript.getListOfCustomStylesheet(CreateMigrateScript.java:707)
  at com.oracle.migrate.CreateMigrateScript.write63Script(CreateMigrateScript.java:426)
  at com.oracle.migrate.CreateMigrateScript.createScript(CreateMigrateScript.java:89)
  at com.oracle.migrate.CreateMigrateScript.main(CreateMigrateScript.java:56)

java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:
  at java.sql.DriverManager.getConnection(DriverManager.java:596)
  at java.sql.DriverManager.getConnection(DriverManager.java:187)
  at com.oracle.migrate.DatabaseRun.openConnection(DatabaseRun.java:43)
  at com.oracle.migrate.DatabaseRun.execute(DatabaseRun.java:48)
  at com.oracle.migrate.CreateMigrateScript.getListOfCustomStylesheet(CreateMigrateScript.java:707)
  at com.oracle.migrate.CreateMigrateScript.write63Script(CreateMigrateScript.java:426)
  at com.oracle.migrate.CreateMigrateScript.createScript(CreateMigrateScript.java:89)
  at com.oracle.migrate.CreateMigrateScript.main(CreateMigrateScript.java:56)
Jun 14, 2016 2:26:04 PM com.oracle.migrate.CreateMigrateScript getListOfCustomStylesheet
SEVERE: null
java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:
  at java.sql.DriverManager.getConnection(DriverManager.java:596)
  at java.sql.DriverManager.getConnection(DriverManager.java:187)
  at com.oracle.migrate.DatabaseRun.openConnection(DatabaseRun.java:43)
  at com.oracle.migrate.DatabaseRun.execute(DatabaseRun.java:48)
  at com.oracle.migrate.CreateMigrateScript.getListOfCustomStylesheet(CreateMigrateScript.java:707)
  at com.oracle.migrate.CreateMigrateScript.write63Script(CreateMigrateScript.java:426)
  at com.oracle.migrate.CreateMigrateScript.createScript(CreateMigrateScript.java:89)
  at com.oracle.migrate.CreateMigrateScript.main(CreateMigrateScript.java:56)

Exception in thread "main" java.lang.NullPointerException
  at com.oracle.migrate.CreateMigrateScript.write63Script(CreateMigrateScript.java:428)
  at com.oracle.migrate.CreateMigrateScript.createScript(CreateMigrateScript.java:89)
  at com.oracle.migrate.CreateMigrateScript.main(CreateMigrateScript.java:56)


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