在dos窗口中,执行如下
lsnrctl status
如果返回如下,表示listener没有启动
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zhzh)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error执行如下语语句启动listener
lsnrctl start执行如下语语句关闭listener
lsnrctl stop
lsnrctl status
如果返回如下,表示listener没有启动
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zhzh)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error执行如下语语句启动listener
lsnrctl start执行如下语语句关闭listener
lsnrctl stop
遗憾的是,我的这个的确没启动,但是,我按照您说的步骤后,启动它,在窗口中,有如下的提示:Lsnrctl for 32-bit windows:version 9.0.1.1.1 - production on 16-12月-2003 08:34:35copyright (c) 1991,2001,oracle corporation.All rights reserved.启动tnslsnr:请稍后…Failed to start service,error 3.
Tns-12536:TNS:操作可能阻塞
Tns-12560:Tns:协议适配器错误
Tns-00506:操作可能阻塞
32-bit windows error:997:unknown error看来我还是重装好了,但是太麻烦了,谢谢您的指点
直接用notepad.exe打开它, 加入:
<YourServiceName> =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = OracleComputerIP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = <YourServiceName>)
)
)然后用SQL*Plus登陆测试:
用户:<YourName>
密码:<YourPassword>
ID: <YourServiceName>