VALIDATE DGConnectIdentifier

The VALIDATE DGConnectIdentifier command enables users to check to see whether a connect identifier is valid for the DGConnectidentifier property.

The connect identifier for each connectivity check is generated based on the DGConnectIdentifier property of the associated database.

Format

VALIDATE DGConnectIdentifier <connect_identifier> ;

Command Parameters

connect_identifier

An Oracle connect identifier to be validated.

Usage Notes

The DGMGRL command VALIDATE DGConnectIdentfier enables users to verfiy whether a connection identifier is valid for the DGConnectidentifier property or not. command.

if a configuration exists and is enabled, the command checks if it is able to make a connection using it on all configuration members.

This command can also be used prior to adding a member to the configuration. If no configuration exists, the command validates the connect identifier at the database and instance DGMGRL is connected to.

This command performs the following for each instance of all members:

• Print a translated network of the connection string at the instance

• Print environment variables related to network configuration at the instance
• Make a new connection using the translated network address at the instance
• If a connection test succeeds, the instance name and db_unique_name of the connected database will be printed

Command Examples

Example 1: When a configuration exists:

DGMGRL> validate dgconnectidentifier north_sales;
At instance sales1 of member 'South_Sales'
  north_sales translates to:
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=north.example.com)(PORT=2852)))(CONNECT_DATA=(SERVICE_NAME=north_sales.example.com)(SERVER=DEDICATED)))

  Environment Variables:
             TNS_ADMIN: /oracle/south_sales/network
           ORACLE_HOME: /oracle/south_sales/home
           ORACLE_BASE: /oracle/south_sales/base

  Initialization Parameters:
        LOCAL_LISTENER: south_listener

  Connected to instance 'sales1' at member 'North_Sales'

At instance 'sales1' of member 'North_Sales'
  north_sales translates to:
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=north.example.com)(PORT=2852)))(CONNECT_DATA=(SERVICE_NAME=north_sales.example.com)(SERVER=DEDICATED)))

  Environment Variables:
             TNS_ADMIN: /oracle/north_sales/network
           ORACLE_HOME: /oracle/north_sales/home
           ORACLE_BASE: /oracle/north_sales/base

  Initialization Parameters:
        LOCAL_LISTENER: north_listener

  Connected to instance 'sales1' at member 'North_Sales'

Example 2: When no configuration exists:

DGMGRL> validate dgconnectidentifier north_sales;
At instance 'sales1' of member 'North_Sales'
  north_sales translates to:
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=north.example.com)(PORT=2852)))(CONNECT_DATA=(SERVICE_NAME=north_sales.example.com)(SERVER=DEDICATED)))

  Environment Variables:
             TNS_ADMIN: /oracle/south_sales/network
           ORACLE_HOME: /oracle/south_sales/home
           ORACLE_BASE: /oracle/south_sales/base
             GRID_HOME:

  Initialization Parameters:
        LOCAL_LISTENER: south_listener

  Connected to instance 'sales1' at member 'North_Sales'

Example 3: With an unrecognized connect identifier:

DGMGRL> VALIDATE DGConnectIdentifier 'north_sales';
At instance 'NorthSales' of member 'North_Sales'
  north_sales translates to:
    (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sales1.example.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = North_Sales.example.com)))

  Environment Variables:
             TNS_ADMIN: 
           ORACLE_HOME: /sales/oracle/product/23.0.0/db_1
           ORACLE_BASE: /sales/oracle

  Initialization Parameters:
        LOCAL_LISTENER: LISTENER_NORTHSALES

  Connected to instance 'NorthSales' at member 'North_Sales'

At instance 'SouthSales' of member 'South_Sales'
  north_sales translates to:
    (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sales1.example.com)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = North_Sales.example.com)))

  Environment Variables:
             TNS_ADMIN: 
           ORACLE_HOME: /sales/oracle/product/23.0.0/db_1
           ORACLE_BASE: /sales/oracle

  Initialization Parameters:
        LOCAL_LISTENER: LISTENER_SOUTHSALES

  DGM-17565: Failed to connect using 'north_sales'.

DGM-17488: Warning: DGConnectIdentifer 'north_sales' does not have the same translation on all members.

Example 4: When a connection test fails:

DGMGRL> VALIDATE DGConnectIdentifier 'north_sales';
At instance 'NorthSales' of member 'North_Sales'
  north_sales translates to:
    (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sales1.example.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = NorthSales.example.com)))

  Environment Variables:
             TNS_ADMIN: 
           ORACLE_HOME: /sales/oracle/product/23.0.0/db_1
           ORACLE_BASE: /sales/oracle
             GRID_HOME: 

  Initialization Parameters:
        LOCAL_LISTENER: LISTENER_NORTHSALES

  DGM-17565: Failed to connect using 'north_sales'.