「Oracle」サーバーへの接続設定ファイルtnsnames.oraのサンプル

2014年8月20日2021年9月8日

構文

接続文字列 =
(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)
)
)