【正文】 ONLINE ONLINE hisdb1 Started ONLINE ONLINE hisdb2 Started OFFLINE OFFLINE hisdb1 OFFLINE OFFLINE hisdb2 ONLINE ONLINE hisdb1 ONLINE ONLINE hisdb2 ONLINE ONLINE hisdb1 ONLINE ONLINE hisdb2 ONLINE ONLINE hisdb1 ONLINE ONLINE hisdb2Cluster Resources 1 ONLINE ONLINE hisdb2 1 ONLINE ONLINE hisdb2 1 ONLINE ONLINE hisdb2 Open 2 ONLINE ONLINE hisdb1 Open 1 ONLINE ONLINE hisdb1 1 ONLINE ONLINE hisdb2 1 ONLINE ONLINE hisdb2 1 ONLINE ONLINE hisdb2 3．檢查cluster狀態(tài)：p570a crsctl check clusterCRS4537: Cluster Ready Services is onlineCRS4529: Cluster Synchronization Services is onlineCRS4533: Event Manager is online4．驗(yàn)證數(shù)據(jù)庫狀態(tài)$ srvctl status database d hisdbInstance hisdb1 is running on node hisdb1Instance hisdb2 is running on node hisdb2p570a srvctl status instance d dbrac i orcl1Instance orcl1 is running on node p570ap570a srvctl status instance d dbrac i orcl2Instance orcl2 is running on node p570b5．驗(yàn)證應(yīng)用狀態(tài)srvctl status nodeappsInstance hisdb1 is running on node hisdb1Instance hisdb2 is running on node hisdb2$ srvctl status nodeappsVIP hisdb1vip is enabledVIP hisdb1vip is running on node: hisdb1VIP hisdb2vip is enabledVIP hisdb2vip is running on node: hisdb2Network is enabledNetwork is running on node: hisdb1Network is running on node: hisdb2GSD is disabledGSD is not running on node: hisdb1GSD is not running on node: hisdb2ONS is enabledONS daemon is running on node: hisdb1ONS daemon is running on node: hisdb26．節(jié)點(diǎn)應(yīng)用程序 —（配置）srvctl config nodeappsNetwork exists: 1/, type staticVIP exists: /hisdb1vip/, hosting node hisdb1VIP exists: /hisdb2vip/, hosting node hisdb2GSD existsONS exists: Local port 6100, remote port 6200, EM port 20167．?dāng)?shù)據(jù)庫 —（配置）srvctl config database d hisdb aDatabase unique name: hisdbDatabase name: hisdbOracle home: /oracle/app/oracle/product/Oracle user: oracleSpfile: +DATA/hisdb/Domain:Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: hisdbDatabase instances: hisdb1,hisdb2Disk Groups: DATAMount point paths:Services:Type: RACDatabase is enabledDatabase is administrator managed8．ASM —（狀態(tài)和配置）srvctl status asmASM is running on hisdb2,hisdb1srvctl config asm aASM home:/oracle/app/grid/product/ASM listener: LISTENERASM is enabled. 9．TNS 監(jiān)聽器 —（狀態(tài)和配置）srvctl status listenerASM home: /oracle/app/grid/product/ASM listener: LISTENERASM is enabled.$ srvctl status listenerListener LISTENER is enabledListener LISTENER is running on node(s): hisdb2,hisdb1srvctl config listener aASM home:/oracle/app/grid/product/ASM listener: LISTENERASM is enabled.$ srvctl status listenerListener LISTENER is enabledListener LISTENER is running on node(s): hisdb2,hisdb1$ srvctl config listener aName: LISTENERNetwork: 1, Owner: gridHome: CRS home /oracle/app/grid/product/ on node(s) hisdb1,hisdb2End points: TCP:152110．SCAN —（狀態(tài)和配置）srvctl status scanSCAN VIP scan1 is enabledSCAN VIP scan1 is running on node hisdb2srvctl config scanSCAN name: hisdbscan, Network: 1/SCAN VIP name: scan1, IP: /hisdbscan/6. 開機(jī)與關(guān)機(jī)操作ORACLE RAC 啟動(dòng)及關(guān)閉操作開機(jī)操作（一）開機(jī)(通過HMC中加電直接啟動(dòng)分區(qū)進(jìn)行系統(tǒng))啟動(dòng)GRID群集系統(tǒng)（一般情況下開機(jī)自動(dòng)啟動(dòng)）等5分鐘左右啟動(dòng)完成GRID啟動(dòng)會(huì)自己?jiǎn)?dòng)ASM實(shí)例，監(jiān)聽及數(shù)據(jù)庫實(shí)例2 查看GRID啟動(dòng)是否正常(1) ifconfig –a 查看IP是否啟動(dòng)正常.(2) 用ORACLE運(yùn)行crs_stat –t或crsctl status res t 全面檢查GRID狀態(tài) ora.... ONLINE ONLINE hisdb1 ora.... ONLINE ONLINE hisdb1 ora.... ONLINE ONLINE hisdb1ora.... ora.... ONLINE ONLINE hisdb1ora.... ora.... ONLINE ONLINE hisdb2 ONLINE ONLINE hisdb1 ONLINE ONLINE hisdb2 OFFLINE OFFLINEora....network ora.... ONLINE ONLINE hisdb1 ora.... ONLINE ONLINE hisdb1ora.... application ONLINE ONLINE hisdb1ora.... application ONLINE ONLINE hisdb1ora.... application OFFLINE OFFLINEora.... application ONLINE ONLINE hisdb1ora.... ora.... ONLINE ONLINE hisdb1ora.... application ONLINE ONLINE hisdb2ora.... application ONLINE ONLINE hisdb2ora.... application OFFLINE OFFLINEora.... application ONLINE ONLINE hisdb2ora.... ora.... ONLINE ONLINE hisdb2 ONLINE ONLINE hisdb2 ONLINE ONLINE hisdb1ora.... ora.... ONLINE ONLINE hisdb1 ora.... ONLINE ONLINE hisdb2運(yùn)行結(jié)果如上則說明CRS及數(shù)據(jù)庫啟動(dòng)正常,能啟動(dòng)應(yīng)用如果不能自動(dòng)停機(jī)可用以下的命令啟動(dòng)（手功啟動(dòng)CRS）等5分鐘左右啟動(dòng)完成。在2臺(tái)服務(wù)器中，分別用root用戶運(yùn)行 /oracle/app/grid/product/查看數(shù)據(jù)庫狀態(tài)Su – oracleSqlplus / as sysdbaSelect * from tab。 如果有輸出，數(shù)據(jù)庫正常啟動(dòng)。（二）關(guān)機(jī)AIX 先手工關(guān)閉ORACLE RAC 數(shù)據(jù)庫su oracle$srvctl stop database –d hisdb 或分別在兩臺(tái)服務(wù)器上運(yùn)行su – oraclesqlplus / as sysdbashutdown immediate關(guān)閉CRS群集系統(tǒng)(分別在兩臺(tái)服務(wù)器上運(yùn)行) /oracle/app/grid/product/(單機(jī):crsctl stop has 這是ORACLE dataguard的啟動(dòng)方式）關(guān)閉主機(jī)命令 shutdown F操作系統(tǒng)重啟命令shutdown –Fr(重啟后ORACLE GRID會(huì)自動(dòng)啟動(dòng)，如果用shutdown immediate關(guān)閉數(shù)據(jù)庫，系統(tǒng)啟動(dòng)后要用startup來啟動(dòng)數(shù)據(jù)庫)48 /