Failure Linking Manually Added Source Database (KBA8265)

Issue

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:

 

Error

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.

Error Code

exception.oracle.dsource.sync.no_hosts

Suggested Action

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.

Diagnosing Information

 

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies

Major Release	All Sub Releases
6.0	6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0, 6.0.6.0, 6.0.6.1, 6.0.7.0, 6.0.8.0, 6.0.8.1, 6.0.9.0, 6.0.10.0, 6.0.10.1
5.3	5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0, 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0
5.2	5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1

Resolution

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

alternatively:

SQL> select INSTANCE_NAME, INSTANCE_NUMBER from v$instance;

SQL> select DB_UNIQUE_NAME,NAME  from v$database;

3. Record obtained values. 
4. Login to the Delphix Management application.
5. Delete the Linked Database in UI or CLI
6. Delete manually added Source Database under the appropriate Oracle Home
7. 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.

 

 

 

---