登录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 启动服务