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 DECEMBER 03, 2019

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!


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.