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

一启动

三个命令

sqlplux /nolog

connect /as sysdba

startup

二关闭

shutdown immediate;

[oracle@zhao ~]$ sqlplus /nolog

SQL*Plus: Release Production on Sun Nov ::

Copyright (c) Oracle Corporation All rights reserved

SQL> connect /as sysdba

Connected to an idle instance

SQL> startup

ORACLE instance started

Total System Global Area bytes

Fixed Size bytes

Variable Size bytes

Database Buffers bytes

Redo Buffers bytes

Database mounted

Database opened

SQL>

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

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

SQL> !

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

root : pts/ :: su oracle

oracle : pts/ :: bash

oracle : pts/ :: sqlplus

oracle : ? :: ora_pmon_lx

oracle : ? :: ora_dbw_lx

oracle : ? :: ora_lgwr_lx

oracle : ? :: ora_ckpt_lx

oracle : ? :: ora_smon_lx

oracle : ? :: ora_reco_lx

oracle : ? :: ora_cjq_lx

oracle : ? :: ora_qmn_lx

oracle : ? :: ora_s_lx

oracle : ? :: ora_d_lx

oracle : ? :: oraclelx (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle : pts/ :: /bin/bash

oracle : pts/ :: ps ef

oracle : pts/ :: grep oracle

[oracle@zhao ~]$ exit

exit

SQL> shutdown immediate;

Database closed Database dismounted ORACLE instance shut down

SQL>

SQL> exit

Disconnected from Oraclei Enterprise Edition Release Production

With the Partitioning OLAP and Oracle Data Mining options

JServer Release Production

[oracle@zhao ~]$

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

root : pts/ :: su oracle

oracle : pts/ :: bash

oracle : pts/ :: ps ef

oracle : pts/ :: grep oracle

[oracle@zhao ~]$