My Oracle Support Banner

The OWB to ODI Migration Utility Fails With ORA-12514 (Doc ID 2785686.1)

Last updated on JUNE 18, 2021

Applies to:

Oracle Warehouse Builder - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.0.4 version, OWB to ODI Migration on Windows

Executing the migration.bat to migrate from OWB to ODI fails.

ERROR
-----------------------
D:\<OWB_HOME>\owb\bin\win>migration.bat <ODI_MASTER_REPOSITORY_PASSWORD> <ODI_USER_PASSWORD> <WORKSPACE_OWNER_PASSWORD> migration.config
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512m; support was removed in 8.0
Migration failed. Details: [ERROR][Migration][OWB]Unable to connect to OWB workspace! Details: API0419: Could not connect to the database.

API0420: Error message: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor




Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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