环境说明: 实验环境是 一个节点的 rac + 单机dg (主备全部用asm存储)
tnsnames.ora 文件 (oracle用户)
node 1 :
node1-> pwd
/u01/app/oracle/product/11.2.0/db_1/network/admin
node1-> cat tnsnames.ora
DEVDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.25.100)(PORT =1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = devdb) ) )devdb1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.25.10)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = devdb) (INSTANCE_NAME = devdb1) ) )phydb = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.25.15)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = phydb) ))
dg :
phydb-> pwd
/u01/app/oracle/product/11.2.0/db_1/network/adminphydb-> cat tnsnames.oraDEVDB =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.25.100)(PORT =1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = devdb) ) )devdb1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.25.10)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = devdb) (INSTANCE_NAME = devdb1) ) )phydb = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.25.15)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = phydb) ) )
listener.ora 文件 (grid用户)
node 1 :
node1-> pwd
/u01/app/11.2.0/grid/network/adminnode1-> cat listener.oraLSN2 =
(ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=10.100.25.10)(PORT=1521)) (ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))SID_LIST_LSN2= (SID_LIST= (SID_DESC= (GLOBAL_DBNAME=devdb) (SID_NAME=devdb1) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1) ) ) )
dg:
phydb-> pwd
/u01/app/11.2.0/grid/network/adminphydb-> cat listener.ora
LSN2 =
(ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=10.100.25.15)(PORT=1521)) (ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))SID_LIST_LSN2= (SID_LIST= (SID_DESC= (GLOBAL_DBNAME=phydb) (SID_NAME=phydb) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1) ) ) )