oiaDataMigration Tool Throws An Error When Migrating Closed Certifications From OIA To OIM R2 PS3 (Doc ID 2120337.1)

Last updated on APRIL 29, 2016

Applies to:

Oracle Identity Analytics - Version 11.1.1.5.5 and later
Information in this document applies to any platform.

Symptoms

When running the oiaDataMigration.zip utility from the both the server and local machine, it stops with an error (see below) when connecting to OIM.

The OIM DB user and password is correct.
This is preventing the migration.

Following documentation: http://docs.oracle.com/cd/E40329_01/doc.1112/e49917/mig_oia.htm#IAMMG4011

Failing at step 4 from the Migration Roadmap
http://docs.oracle.com/cd/E40329_01/doc.1112/e49917/mig_oia.htm#IAMMG4006

The OIM PS3 DB is 12c, Able to connect to that DB from the local machine and also from UNIX server but not from the oiaDataMigration utility.

-----

The following error is seen in the oiadatamigration.log when verifying the migration. --- SERVER_NAME:$PORT/oimdb substituted over machine name/port/db name

[oiaDataMigration]$ java -jar oiaDataMigration.jar -stats

Generating summary of certification tables

$ cat oiadatamigration.log
INFO [OIADataMigrator] ########################
INFO [OIADataMigrator] starting migration tool: -stats option selected
INFO [OIADataMigrator] oia data source : jdbc:oracle:thin:@SERVER_NAME:$PORT/oimdb
INFO [OIADataMigrator] retrieving oim database information

ERROR [OIADataMigrator] Unable to make connnection to OIM - Cannot create PoolableConnectionFactory (IO Error: The Network Adapter could not establish the connection)
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (IO Error: The Network Adapter could not establish the connection)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at oracle.iam.oiamigration.OIADataMigrator.validateDataSource(OIADataMigrator.java:549)
at oracle.iam.oiamigration.OIADataMigrator.init(OIADataMigrator.java:118)
at oracle.iam.oiamigration.OIADataMigrator.generateStatsOutput(OIADataMigrator.java:188)
at oracle.iam.oiamigration.OIADataMigrator.main(OIADataMigrator.java:630)
Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:538)
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 org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at oracle.iam.oiamigration.OIADataMigrator.validateDataSource(OIADataMigrator.java:549)
at oracle.iam.oiamigration.OIADataMigrator.init(OIADataMigrator.java:118)
at oracle.iam.oiamigration.OIADataMigrator.generateStatsOutput(OIADataMigrator.java:186)
... 1 more
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:375)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:422)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:686)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:246)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1056)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)
... 13 more
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
at java.net.PlainSocketImpl.co

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