oracle如何配tnsname,ORACLE---TNSNAMES.ORA文件配置

文件位置  $ORACLE_HOME/network/admin/tnsnames.ora

===单实例配置===

SINGLE_PROD =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.88)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = testdb)

)

)

===RAC SCAN方式配置===

TESTDB_DOMAIN =

(DESCRIPTION =

(ADDRESS = (PROTOCOL=TCP)(HOST=testdb.us.oracle.com )(PORT=1521))

(CONNECT_DATA=

(SERVER = DEDICATED)

(SERVICE_NAME = testdb)

)

)

===RAC VIP方式配置===

TESTDB_PROD =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.100)PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.101)(PORT = 1521))

(LOAD_BALANCE = yes)

(FAILOVER = yes)

)

(CONNECT_DATA=

(SERVER = DEDICATED)

(SERVICE_NAME = testdb)

)

)

RAC中SCAN NAME：testdb.us.oracle.com

nslookup testdb.us.oracle.com (可以轮询解析不同的SCAN VIP)

Focus On Technology，Thanks To My Family And Friends !

---Elegent_Shu---