服务热线:13616026886

技术文档 欢迎使用技术文档,我们为你提供从新手到专业开发者的所有资源,你也可以通过它日益精进

位置:首页 > 技术文档 > 数据库技术 > Oracle技术 > Oracle开发 > 查看文档

windows下oracle数据库进程的启动和关闭

【赛迪网-it技术报道】windows下oracle的启动一般是伴随windows自动启动,自动关闭的。但是如果同过任务管理器杀掉了oracle进程,如果通过命令行方式打开oracle就会报错误信息。

解决办法如下:

microsoft windows xp [version 5.1.2600]

(c) copyright 1985-2001 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 32-bit windows: version 9.2.0.1.0 - production on 15-mar-2007 13:19:

17

copyright (c) 1991, 2002, oracle corporation. all rights reserved.

connecting to (description=(address=(protocol=ipc)(key=extproc0)))

the command completed successfully

c:/>lsnrctl start

lsnrctl for 32-bit windows: version 9.2.0.1.0 - production on 15-mar-2007 13:19:

20

copyright (c) 1991, 2002, oracle corporation. all rights reserved.

starting tnslsnr: please wait...

tnslsnr for 32-bit windows: version 9.2.0.1.0 - production

system parameter file is c:/userdefine/oracle/ora92/network/admin/listener.ora

log messages written to c:/userdefine/oracle/ora92/network/log/listener.log

listening on: (description=(address=(protocol=ipc)(pipename=//./pipe/extproc0ipc

)))

listening on: (description=(address=(protocol=tcp)(host=scn3089.asiapacific.hpqc

orp.net)(port=1521)))

connecting to (description=(address=(protocol=ipc)(key=extproc0)))

status of the listener

------------------------

alias listener

version tnslsnr for 32-bit windows: version 9.2.0.1.0 - produc

tion

start date 15-mar-2007 13:19:22

uptime 0 days 0 hr. 0 min. 2 sec

trace level off

security off

snmp off

listener parameter file c:/userdefine/oracle/ora92/network/admin/listener.ora

listener log file c:/userdefine/oracle/ora92/network/log/listener.log

listening endpoints summary...

(description=(address=(protocol=ipc)(pipename=//./pipe/extproc0ipc)))

(description=(address=(protocol=tcp)(host=scn3089.asiapacific.hpqcorp.net)(por

t=1521)))

services summary...

service "plsextproc" has 1 instance(s).

instance "plsextproc", status unknown, has 1 handler(s) for this service...

service "wbq" has 1 instance(s).

instance "wbq", status unknown, has 1 handler(s) for this service...

the command completed successfully

c:/>sqlplus /nolog

sql*plus: release 9.2.0.1.0 - production on thu mar 15 13:19:28 2007

copyright (c) 1982, 2002, oracle corporation. all rights reserved.

sql> connect sys/change_on_install as sysdba

connected.

sql>

扫描关注微信公众号