TNSNAME 文件路径 ....NETWORK\ADMIN\tnsnames.ora
主要关注点是服务名、服务端IP地址、端口,具体如下ORCL144 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.9.144)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
主要关注点是服务名、服务端IP地址、端口,具体如下ORCL144 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.9.144)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
打开D:\app\pfzhang3\product\11.2.0\client_1\network\admin\tnsnames.oraORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)