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

关于Windows下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 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

关于Windows下Oracle数据库进程的启动和关闭的探讨就到这里 ,您是否还有其他想了解的内容?欢迎在评论区留言告诉我们,同时别忘了点击关注哦!

(3)

猜你喜欢

发表回复

本站作者才能评论

评论列表(3条)

  • 腾语号的头像
    腾语号 2026年04月25日

    我是腾语号的签约作者“腾语号”

  • 腾语号
    腾语号 2026年04月25日

    本文概览:关于Windows下Oracle数据库进程的启动和关闭的讨论正在各大平台持续发酵,我们精心筛选了最新资讯,希望能为您带来实质性的帮助。windows下Oracle的启动一般是...

  • 腾语号
    用户042505 2026年04月25日

    文章不错《Windows下Oracle数据库进程的启动和关闭》内容很有帮助

联系我们:

邮件:腾语号@gmail.com

工作时间:周一至周五,9:30-17:30,节假日休息

关注微信