10G client连接数据库
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)
)
)