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

SQLPlus: 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

按WIN+R打开运行窗口

输入 net start mssqlserver ，按enter 来启动

输入 net stop mssqlserver ，按enter 来停止

1 linux下启动oracle\x0d\su - oracle\x0d\sqlplus /nolog\x0d\conn /as sysdba\x0d\startup\x0d\exit\x0d\lsnrctl start\x0d\exit\x0d\2 linux下关闭oracle\x0d\su - oracle\x0d\sqlplus /nolog\x0d\conn /as sysdba\x0d\shutdown immediate\x0d\exit\x0d\lsnrctl stop\x0d\exit\x0d\3、启动监听器\x0d\oracle@suse92:~> lsnrctl start\x0d\4、停止监听器\x0d\oracle@suse92:~> lsnrctl stop\x0d\5、查看监听器状态\x0d\oracle@suse92:~> lsnrctl\x0d\LSNRCTL> status\x0d\LSNRCTL> exit\x0d\6# setup 可以设置防火墙等信息\x0d\7安装监听器\x0d\运行 netca 命令\x0d\lsnrctl start\x0d\lsnrctl stop\x0d\reload listener 重新加载\x0d\service listener\x0d\help 帮助\x0d\quit 退出\x0d\vi etc/hosts\x0d\添加 1921680100 chsylinux\x0d\数据库关闭死掉还可以STARTUP FORCE\x0d\，再糟糕的情况用SHUTDOWN ABORT。

Oracle数据库可以运行在2种模式：归档模式(archivelog)和非归档模式(noarchivelog)归档模式可以提高Oracle数据库的可恢复性，生产数据库都应该运行在此模式下，归档模式应该和相应的备份策略相结合，只有归档模式没有相应的备份策略只会带来麻烦。

下面为大家简单介绍如何启用和关闭数据库的归档模式。

1shutdown normal或shutdown immediate关闭数据库

[oracle@jumper oracle]$ sqlplus "/ as sysdba"

SQLPlus: Release 92040 - Production on Sat Oct 15 15:48:36 2005

Copyright (c) 1982, 2002, Oracle Corporation All rights reserved

Connected to:

Oracle9i Enterprise Edition Release 92040 - Production

With the Partitioning option

JServer Release 92040 - Production

SQL> shutdown immediate;

Database closed

Database dismounted

ORACLE instance shut down

2启动数据库到mount状态

SQL> startup mount;

ORACLE instance started

Total System Global Area 101782828 bytes

Fixed Size 451884 bytes

Variable Size 37748736 bytes

Database Buffers 62914560 bytes

Redo Buffers 667648 bytes

Database mounted

3启用或停止归档模式

如果要启用归档模式，此处使用

alter database archivelog 命令。

SQL> alter database archivelog;

Database altered

SQL> alter database open;

Database altered

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /opt/oracle/oradata/conner/archive

Oldest online log sequence 148

Next log sequence to archive 151

Current log sequence 151

以上就是关于Windows下Oracle数据库进程的启动和关闭全部的内容，包括:Windows下Oracle数据库进程的启动和关闭、怎样快速启动和停止SQL数据库按什么组合键吗我一般都是点服务，然后找到SQL，右击，再启动，这、如何在linux下启动和关闭ORCALE数据库等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！