When Attempting to Execute the Test Button for Production Database Connection - Receiving Error: "An error occured while creating production database link"

(Doc ID 1534054.1)

Last updated on AUGUST 17, 2017

Applies to:

Oracle Agile Engineering Data Management - Version and later
Information in this document applies to any platform.


When executing Test Button for takeover production data database configuration receiving one success message and one error message :


Upgrade tool log file <up_root>/log/full.log showing:

... creating database link: CREATE DATABASE LINK world_upg_plm50 connect to plm51prod identified by "***" using 'plm50.world''
... ERROR: an error occured while creating production database link
... ======== EXCEPTION_BEGIN =========
... java.sql.SQLException: ORA-12154: TNS:could not resolve the connect identifier specified



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