以下、tnsnames.ora ファイルの場所とサンプル中身
# TNSNAMES.ORA Network Configuration File:
# C:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
HOGEHOGE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = FOO)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = hoge1)
)
)
HOGEHOGE2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = BAR)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = hoge2)
)
)