【赛迪网-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>
闽公网安备 35060202000074号