Delphix Products

Expand all | Collapse all

oracle name

Jump to Best Answer
  • 1.  oracle name

    Posted 04-30-2014 08:19:00 PM

    Created an environment with the only one database on it (caserv) and the database name on this server is the same as on the other physical server. 

    However, when I tried to create dsource it give me the following error:
    Detected two Oracle databases with the same unique name "caserv".

    Error Code:

    Suggested Action:

    Change the unique name of one of the databases and try the operation again.

  • 2.  RE: oracle name
    Best Answer

    Posted 04-30-2014 09:41:00 PM

    Hi Sharon,

    According to Oracle's documentation, a db_unique_name must be globally unique (see for example: When we discover a database, we record the db_unique_name of the database, whether or not it is ever linked as a dSource. When linking, we check whether we already have discovered a database with the same unique name, and as you have seen, we will not link a database that has a non-unique db_unique_name.

    Duplicate db_unique_names within an Oracle infrastructure can cause unpredictable and difficult to diagnose issues with RMAN and DataGuard. Since we utilize RMAN in linking a dSource, we avoid these issues by preventing linking of a database with a duplicate db_unique_name.

    As the error suggests, changing the db_unique_name of one of the databases will allow you to link them.