tnsnames.ora文件中的名字一定要定格写，不然连接时会如下报错。
已使用的参数文件:
F:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora
TNS-03505: 无法解析名称
C:\Users\Administrator>
错误：
YCRDBA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.2.0.10)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ycr.ouc.cn)
)
)
正确：
YCRDBA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.2.0.10)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ycr.ouc.cn)
)
)
已使用的参数文件:
F:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora
TNS-03505: 无法解析名称
C:\Users\Administrator>
错误：
YCRDBA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.2.0.10)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ycr.ouc.cn)
)
)
正确：
YCRDBA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.2.0.10)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ycr.ouc.cn)
)
)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29135257/viewspace-2122122/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Oracle字符集超集与子集关系10G
下一篇：
Oracle 12C配置EM
请登录后发表评论
登录
全部评论
