ORA-12560: TNS: TNS:protocol adapter error 协议适配器错误

登录oracle出现ORA-12560错误如下：

 

>set oracle_sid=book

C:/Documents and Settings/myhost>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 5月 27 14:47:48 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12560: TNS: 协议适配器错误

 

 

C:/Documents and Settings/myhost>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 27-5月 -2010 14:5
0:20

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS: 无监听程序
 TNS-12560: TNS: 协议适配器错误
  TNS-00511: 无监听程序
   32-bit Windows Error: 2: No such file or directory
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=152
2)))
TNS-12541: TNS: 无监听程序
 TNS-12560: TNS: 协议适配器错误
  TNS-00511: 无监听程序
   32-bit Windows Error: 61: Unknown error

 

 

原因：监听器及oracle服务没有启动

 

>lsnrctl start

>net start oracleservicebook  启动服务