VALIDATE NETWORK CONFIGURATION
VALIDATE NETWORK CONFIGURATIONコマンドは、構成のメンバー間のネットワーク接続性チェックを実行します。
各接続性チェックの接続識別子は、関連付けられたデータベースのDGConnectIdentifierプロパティに基づいて生成されます。
書式
VALIDATE NETWORK CONFIGURATION FOR { ALL | <db_unique_name> };
コマンド・パラメータ
使用上のノート
-
このコマンドは静的接続識別子のチェックも実行します。
コマンドの例
例1: 特定のデータベース用のネットワーク構成の検証
DGMGRL> VALIDATE NETWORK CONFIGURATION FOR North_Sales;
Connecting to instance "north_sales1" on database "North_Sales" ...
Checking connectivity from instance "north_sales1" on database "North_Sales to instance "south_sales1" on database "South_Sales"...
Succeeded.
Connecting to instance "north_sales6" on database "North_Sales" ...
Checking connectivity from instance "north_sales6" on database "North_Sales to instance "south_sales1" on database "South_Sales"...
Succeeded.
Connecting to instance "south_sales1" on database "South_Sales" ...
Checking connectivity from instance "south_sales1" on database "South_Sales to instance "north_sales1" on database "North_Sales"...
Succeeded.
Checking connectivity from instance "south_sales1" on database "South_Sales to instance "north_sales6" on database "North_Sales"...
Succeeded.
Oracle Clusterware on database "North_Sales" is available for database restart.例2: 全メンバー用のネットワーク構成の検証
DGMGRL> VALIDATE NETWORK CONFIGURATION FOR ALL;
Connecting to instance "north_sales1" on database "North_Sales" ...
Checking connectivity from instance "north_sales1" on database "North_Sales to instance "south_sales1" on database "South_Sales"...
Succeeded.
Connecting to instance "north_sales6" on database "North_Sales" ...
Checking connectivity from instance "north_sales6" on database "North_Sales to instance "south_sales1" on database "South_Sales"...
Succeeded.
Connecting to instance "south_sales1" on database "South_Sales" ...
Checking connectivity from instance "south_sales1" on database "South_Sales to instance "north_sales1" on database "North_Sales"...
Succeeded.
Checking connectivity from instance "south_sales1" on database "South_Sales to instance "north_sales6" on database "North_Sales"...
Succeeded.
Oracle Clusterware on database "North_Sales" is available for database restart.
Oracle Clusterware is not configured on database "South_Sales".
Connecting to database "South_Sales" using static connect identifier "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=<nodename>)((PORT=.*))))(CONNECT_DATA=(SERVICE_NAME=South_Sales_DGMGRL.example.com)(INSTANCE_NAME=south_sales1)(SERVER=DEDICATED)(STATIC_SERVICE=TRUE)))" ...
Succeeded.
The static connect identifier allows for a connection to database "South_Sales".