Windows下Oracle数据库进程的启动和关闭以下文字资料是由(历史新知网www.lishixinzhi.com)小编为大家搜集整理后发布的内容,让我们赶快一起来看一下吧!
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 mand pleted 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 /neork/admin/listener ora
Log messages written to C:/UserDefine/oracle/ora /neork/log/listener log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=// /pipe/EXTPROC ipc
)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=scn asiapacific hpqc
)(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 /neork/admin/listener ora
Listener Log File C:/UserDefine/oracle/ora /neork/log/listener log
Listening Endpoints Summary
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=// /pipe/EXTPROC ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=scn asi)(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 mand pleted 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> lishixinzhi/Article/program/Oracle/201311/17222
分页:123