oracle启动数据库Linux,linux下oracle 数据库的启动和关闭

QQ:1156316388   Tel:010-51527259

一、启动

三个命令：

1、sqlplux /nolog

2、connect /as sysdba

3、startup

二、关闭

1、shutdown immediate;

[oracle@zhao ~]$ sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Sun Nov 1 15:08:40 2009

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

SQL> connect /as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 236000356 bytes

Fixed Size 451684 bytes

Variable Size 201326592 bytes

Database Buffers 33554432 bytes

Redo Buffers 667648 bytes

Database mounted.

Database opened.

SQL>

惊叹号在 SQL> ！ 回车可以退出 sql命令行

查看oracle数据库运行启动的进程

SQL> !

[oracle@zhao ~]$ ps -ef | grep oracle

root 4268 4235 0 15:08 pts/0 00:00:00 su - oracle

oracle 4269 4268 0 15:08 pts/0 00:00:00 -bash

oracle 4299 4269 0 15:08 pts/0 00:00:00 sqlplus

oracle    4302     1  0 15:09 ?        00:00:00 ora_pmon_lx92

oracle    4304     1  0 15:09 ?        00:00:00 ora_dbw0_lx92

oracle    4306     1  0 15:09 ?        00:00:00 ora_lgwr_lx92

oracle    4308     1  0 1