熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

linux下oracle數據庫的啟動和關閉

2013-11-13 15:45:40  來源: 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 ~]$


From:http://tw.wingwit.com/Article/program/Oracle/201311/17259.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.