Windows下Oracle數據庫進程的啟動和關閉

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>

From:http://tw.wingwit.com/Article/program/Oracle/201311/17222.html