windows下Oracle的启动一般是伴随windows自动启动
自动关闭的
但是如果同过任务管理器杀掉了Oracle进程
如果通过命令行方式打开Oracle就会报错误信息
解决办法如下
Microsoft Windows XP [Version ]
(C) Copyright Microsoft Corp
C:/Documents and Settings/wangbao>cd/
C:/>net stop OracleServiceWBQ
The OracleServiceWBQ service is stopping
The OracleServiceWBQ service could not be stopped
C:/>net start OracleServiceWBQ
The OracleServiceWBQ service is starting
The OracleServiceWBQ service was started successfully
C:/>lsnrctl stop
LSNRCTL for bit Windows: Version Production on MAR ::
Copyright (c) Oracle Corporation All rights reserved
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
The command completed successfully
C:/>lsnrctl start
LSNRCTL for bit Windows: Version Production on MAR ::
Copyright (c) Oracle Corporation All rights reserved
Starting tnslsnr: please wait
TNSLSNR for bit Windows: Version Production
System parameter file is C:/UserDefine/oracle/ora/network/admin/listenerora
Log messages written to C:/UserDefine/oracle/ora/network/log/listenerlog
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=///pipe/EXTPROCipc
)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=scnasiapacifichpqc
)(PORT=)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for bit Windows: Version Produc
tion
Start Date MAR ::
Uptime days hr min sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File C:/UserDefine/oracle/ora/network/admin/listenerora
Listener Log File C:/UserDefine/oracle/ora/network/log/listenerlog
Listening Endpoints Summary
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=///pipe/EXTPROCipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=scnasi)(POR
T=)))
Services Summary
Service PLSExtProc has instance(s)
Instance PLSExtProc status UNKNOWN has handler(s) for this service
Service wbq has instance(s)
Instance wbq status UNKNOWN has handler(s) for this service
The command completed successfully
C:/>sqlplus /nolog
SQL*Plus: Release Production on Thu Mar ::
Copyright (c) Oracle Corporation All rights reserved
SQL> connect sys/change_on_install as sysdba
Connected
SQL>
