帮我看看 TNS：protocol adapter error

giant

SQL>;connect /as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error

SQL>;



我的ＯＲＡＣＬＥ９Ｉ＋ＷＩＮ２０００　启动时报以上错误是什么意思

giant

ＯＲＡ－１２５６０：ＴＮＳ：protocol adapter error

txfy

你是不是有防火墙呀？端口被限制了？

giant

没有啊

txfy

2000？xp?你看看你的服务里的listener.ora是不是没起呀？

ruknow

跟我一样的问题:
C:\>;lsnrctl

LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 29-APR-2004 17:17
38

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL>; statu
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=yuan)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produ
tion
Start Date                29-APR-2004 17:11:51
Uptime                    0 days 0 hr. 5 min. 52 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   G:\oracle\ora92\network\admin\listener.ora
Listener Log File         G:\oracle\ora92\network\log\listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=yuan)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Services Summary...
Service "KING" has 1 instance(s).
  Instance "KING", status UNKNOWN, has 1 handler(s) for this service...
Service "OEMREP" has 1 instance(s).
  Instance "OEMREP", status UNKNOWN, has 1 handler(s) for this service...
Service "LSExtProc" has 1 instance(s).
  Instance "LSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>; quit

C:\>;sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Apr 29 17:18:47 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL>; conn sys/oracle as sysdba;
ERROR:
ORA-12560: TNS:protocol adapter error


SQL>;

ruknow

只启动了LISTENER就会出现上面的错误,
手动启动数据库服务以后就可以连接了,
难道WINDOWS下不能用SQLPLUS命令行来启动数据库服务?