My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.