oracle 9 tnsnames.ora 放在oracle/product/9.2.0/network/admin目录
oracle 10 放在oracle/10g/network/admin目录
范例1:
acct_db =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.48)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tth2db)
)
)
范例2:
TTYTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = CNDEVSVR)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ttytest)
)
)
数据库的连接地址HOST在/etc/hosts文件里.