Skip to main content
Delphix

Oracle dSource in 'UNKNOWN' state due to db_unique_name mismatch

Issue

If the db_unique_name is changed on the source database then this will cause the status of the dSource to go into "UNKNOWN" state:

Resolution

  1. Check the db_unique name that Delphix is using select the dSource, open and flip the card and check the parameter "Database Unique Name"

2. Then on the database on the source check the setting with the following SQL statement

SQL> select db_unique_name from v$database;
DB_UNIQUE_NAME
------------------------------
db12creg_standby

Resolution

If the database unique names do not match then either change the parameter on the database back to the original one so it matches the Delphix parameter or if the parameter needs to be changed on the Delphix side then the dSource will need to be detached/attached by following the procedure, please make sure you have done all the prerequisites as outlined in Detaching and Attaching a dSource.

  1. Select the dSource.

    delphix> database "dexample"
  2. Run the detachSourcecommand, specifying the currently active source. This step can be skipped if the dSource has already been detached through the GUI.

    delphix database "dexample"> detachSource
    delphix database "dexample" detachSource *> set source=dexample
    delphix database "dexample" detachSource *> commit 
  3. Run the attachSourcecommand.

    delphix database "dexample"> attachSource
  4. Set the config to point to an unlinked source.
    The following is an example to attach to an Oracle data source:

    delphix database "dexample" attachSource *> set source.name=dexamplePrimary
    delphix database "dexample" attachSource *> set source.config=example2
    delphix database "dexample" attachSource *> set environmentUser="environment/myuser"
    delphix database "dexample" attachSource *> set dbUser=orauser
    delphix database "dexample" attachSource *> set dbCredentials.password=orauserpwd


    The following is an example to attach to a SQL Server data source:

    delphix database "dexample" attachSource *> set source.config=SQLSERVER/dexample
    delphix database "dexample" attachSource *> set source.sharedBackupLocation=\\SERVER1\Backups
    delphix database "dexample" attachSource *> set pptRepository=SQL2008R2
    delphix database "dexample" attachSource *> set dbUser=dbuser
    delphix database "dexample" attachSource *> set dbCredentials.password=dbuserpwd
  5. Commit the operation.

    delphix database "dexample" attachSource *> commit 
  • Was this article helpful?