Skip to main content

Failure Linking Manually Added Source Database (KBA8265)




KBA# 8265



Linking a manually added Oracle Source Database may fail if the Database Name, Database Unique Name, or Instance Name provided in Delphix does not match the Source Database parameters. The following is an example of this type of failure type:


Delphix Engine cannot connect to any host to load data from source "DBExample46": Selected instances "[instanceNumber: 1 instanceName: DBExample46: hostName: rh80ora1234]" are not in database "DBExample2" configuration.

Refresh host to discover database instances, or add database configuration manually. If the database was added manually, make sure that the database name and database unique name provided in Delphix match Oracle exactly.


Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases




To resolve this issue:

  1. Determine the exact parameters from the Source Database by connecting to the Source Database using $ORACLE_HOME/bin/sqplus / as sysdba.
  2. Use the following "show parameter" or "select" statements and record the values.  When entering these values into Delphix, the values must be entered exactly as what is configured in the database.

SQL> show parameter DB_UNIQUE_NAME

SQL> show parameter DB_NAME

SQL> show parameter INSTANCE_NAME


SQL> select INSTANCE_NAME, INSTANCE_NUMBER from v$instance;

SQL> select DB_UNIQUE_NAME,NAME  from v$database;

  1. Record obtained values. 
  2. Login to the Delphix Management application.
  3. Delete the Linked Database in UI or CLI
  4. Delete manually added Source Database under the appropriate Oracle Home
  5. Re-add the Source Database using previously recorded values using following steps:


Login to the Delphix Management application.

  1. Click Manage.
  2. Select Environments.
  3. Select the Environment. 
  4. Click the Databases tab.
  5. Choose the installation home where the database is installed. 
  6. Click the Plus icon.
  7. Fill in the dialog box with the requested parameters.





Related Articles