熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

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

2013-11-13 15:44:09  來源: 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
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.