OracleRAC構成でのtnsnames.oraの記述
RAC構成でなくても忘れるのでメモ
環境
- DBサーバ Oracle 11g
- クライアント Oracle 11g Client(Windows XP)
tnsnames.ora
[net_service_name] = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = [DBServer1])(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = [DBServer2])(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = [Servicename]) (INSTANCE_NAME = [Instancename1]) (INSTANCE_NAME = [Instancename2]) ) )
参考
Oracle Database Net Servicesリファレンス
ローカル・ネーミング・パラメータ(tnsnames.ora)
http://otndnld.oracle.co.jp/document/products/oracle11g/111/doc_dvd/network.111/E05726-02/tnsnames.htm#i454852