WEB开发网
开发学院数据库Oracle Windows下Oracle数据库进程的启动和关闭 阅读

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

 2008-06-12 12:42:51 来源:WEB开发网   
核心提示:windows下Oracle的启动一般是伴随windows自动启动,自动关闭的,Windows下Oracle数据库进程的启动和关闭,但是如果同过任务管理器杀掉了Oracle进程,如果通过命令行方式打开Oracle就会报错误信息

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>

Tags:Windows Oracle 数据库

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接