oracle连接串配置
假设tnsname.ora中配置的连接串如下:
Lianjiechuan186 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.51.134.197)(PORT = 1500))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xxxxx)
)
)
那么连接串为:Lianjiechuan186 或者 172.51.134.197:1500/xxxxx (即 地址:端口/SERVICE_NAME)
注:linux下找到tnsname.ora的路径
命令:$ORACLE_HOME
在显示的路径下 cd network/admin 下就能找到tnsname.ora了。