Import_into_target.sh Fails with 'ORA-12154: TNS:could Not Resolve the Connect Identifier' Error for 6.1.x to 8.0.2 Migration (Doc ID 2289416.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.2 and later
Oracle Financial Services Profitability Management - Version 8.0.2 and later
Oracle Financial Services Asset Liability Management - Version 8.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) 8.0.2

Symptoms

When running a 6.1 to 8.0.2 migration for Oracle Financial Services Asset Liability Management (ALM) or Profitability Management (PFT) 8.0.2, when running the migration script import_into_target.sh, you get the following error output to the console:

[2017.05.23 - 23:56:47 PM EEST] Getting details for infodom: OFSALMINFO
OFSAA Home: /u01/app/ofsaa/
Migration Home: /u01/app/ofsaa/software/mig/21271956_Generic
Exception in thread "main" java.lang.NoClassDefFoundError: org/w3c/dom/ElementTraversal
  at java.lang.ClassLoader.defineClass1(Native Method)


ssLoader.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)
  ... 25 more
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
[2017.05.23 - 23:56:48 PM EEST] Error: Could not determine version of AAI/Application.


The errors cause the import to fail.

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