Question

Windows下Oracle数据库进程的启动和关闭

Answer 1

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