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 JUNE 21, 2018

Applies to:

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

Symptoms

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

 

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