C:\Documents and Settings\Administrator>tnsping 192.168.1.84TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 27-7月 -2
006 09:28:08Copyright (c) 1997 Oracle Corporation. All rights reserved.已使用的参数文件:
d:\oracle\ora92\network\admin\sqlnet.ora已使用 HOSTNAME 适配器来解析别名
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=192.168.1.
84))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.84)(PORT=1521)))
TNS-12541: TNS:无监听器
006 09:28:08Copyright (c) 1997 Oracle Corporation. All rights reserved.已使用的参数文件:
d:\oracle\ora92\network\admin\sqlnet.ora已使用 HOSTNAME 适配器来解析别名
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=192.168.1.
84))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.84)(PORT=1521)))
TNS-12541: TNS:无监听器
但如果TNSPING 服务名 就正常。
SQL SERVER IP:192.168.1.84 DATABASE:MASTER..\tg4msql\admin\initmaster.ora 内容:HS_FDS_CONNECT_INFO="SERVER=192.168.1.84;DATABASE=master"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVERlistener.ora中新加入:
(SID_DESC =
(SID_NAME = master)
(ORACLE_HOME = d:\oracle\ora92)
(PROGRAM = tg4msql)
然后重启监听器.tnsnames.ora中新加入:
ADSHOW =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT = 1521))
)
(CONNECT_DATA =
(SID = master))
(HS = ok)下面是tnsping master:TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 27-7月 -2
006 13:57:02Copyright (c) 1997 Oracle Corporation. All rights reserved.已使用的参数文件:
d:\oracle\ora92\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.1.8)(PORT = 1521))) (CONNECT_DATA = (SID = master)) (HS = ok))
OK(20毫秒)显示通过.但是在Oracle Net Manager中测试服务Master时出错,显示:
初始化首次测试请使用用户名: scott, 口令: tiger
正在尝试使用以下用户 ID 连接:scott
测试没有成功。
ORA-03113: end-of-file on communication channel在输入的字段中可能有错误,
或者服务器连接未就绪。