「Oracle」サーバーへの接続設定ファイルtnsnames.oraのサンプル
構文
接続文字列 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = {ホスト名/IPアドレス})(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = サービス名) ) )
使用例1 IPアドレス
CFT = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.21)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = CFTB) ) )
使用例2 ホスト名
CFTDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = CHANGFA)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = CFTB) ) )