Oracle10g RAC (OCFS) 開啟關閉及日常檢查（總結）

熟悉Oracle10g RAC (OCFS) 開啟關閉及檢查Oracle 資料庫步驟。
=====================================================

開關機步驟：

1． 停止Oracle10g 環境

$ lsnrctl stop (停止監聽)
$ emctl stop dbconsole (停止dbconsole)
$ shutdown immediate (停止例項)
$ srvctl stop nodeapps -n gnd-rac01 (停節點服務)
# /etc/init.d/init.crs stop (root 停cluster 軟體)

2． 啟動Oracle10g 環境
$ srvctl start nodeapps -n gnd-rac01 （啟動一些服務）
$ startup （啟動例項）
$ emctl start dbconsole (啟動dbconsole)
$ lsnrctl start (啟動監聽)

平時的檢查：

1. 平時檢視instance 狀態（所有節點） ：
gnd-rac01$srvctl status database -d tpc [注意：tpc 是db name]
Instance tpc1 is running on node gnd-rac01
Instance tpc2 is running on node gnd-rac02

2. 檢查 crs（所有節點） :

gnd-rac01>$cd /u01/product/crs/bin
gnd-rac01$ crs_stat -t
Name Type Target State Host
┅┅┅┅┅┅┅┅┅┅┅┅┅┅┅┅┅┅┅┅┅┅┅┅┅┅
ora....01.lsnr application ONLINE ONLINE gnd-rac01
ora....c01.gsd application ONLINE ONLINE gnd-rac01
ora....c01.ons application ONLINE ONLINE gnd-rac01
ora....c01.vip application ONLINE ONLINE gnd-rac01
ora....02.lsnr application OFFLINE OFFLINE
ora....c02.gsd application ONLINE ONLINE gnd-rac02
ora....c02.ons application ONLINE ONLINE gnd-rac02
ora....c02.vip application ONLINE ONLINE gnd-rac02
ora.tpc.db application ONLINE ONLINE gnd-rac01
ora....c1.inst application ONLINE ONLINE gnd-rac01
ora....c2.inst application ONLINE ONLINE gnd-rac02

3. 檢查VIP, GSD,ONS, Listener 等（所有節點）。
gnd-rac01$srvctl status nodeapps -n gnd-rac01
VIP is running on node: gnd-rac01
GSD is running on node: gnd-rac01
Listener is running on node: gnd-rac01
ONS daemon is running on node: gnd-rac01

gnd-rac01$srvctl status nodeapps -n gnd-rac02
VIP is running on node: gnd-rac02
GSD is running on node: gnd-rac02
Listener is not running on node: gnd-rac02
ONS daemon is running on node: gnd-rac02

4．檢查Oracle Cluster 狀態： CSS, CRS, EVM .
gnd-rac01$crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy

gnd-rac02$crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy

5．Ocfs 方面的問題可以到/etc/init.d/o2cb 這裡看看。一般不用管理。