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 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 '''
... ERROR: an error occured while creating production database link
... ======== EXCEPTION_BEGIN =========
... java.sql.SQLException: ORA-12154: TNS:could not resolve the connect identifier specified



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

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