TOC\o"1-2"\h\z\u一、項(xiàng)目概 二、示意 三、當(dāng)前服務(wù)器使用情 四、服務(wù)器、存儲(chǔ)、數(shù)據(jù)庫(kù)詳細(xì)配 五、項(xiàng)目驗(yàn)收 12RHEL5.764Oracle10.2.0.5RHEL5.764Oracle10.2.0.5FCSwitchFCSwitchFC存儲(chǔ)主FC存儲(chǔ)備HZIEERAC1服務(wù)器HPDL580G78cpu,256G,4*300GSAS2服務(wù)器HPDL580G78cpu,256G,4*300GSAS5HZIEE存儲(chǔ)EMCVNX5700,16×300GFC6HZIEE存儲(chǔ)EMCVNX5500,5×2TFC硬盤(pán)塊硬盤(pán)做MainDBMainDBLUNDBRACLUN網(wǎng)關(guān)服務(wù)器名：maindb222、ip地址 網(wǎng)關(guān)maindb222-vipip地址：192.168.100.22/24Maindb221-Maindb222-121RAC數(shù)據(jù)庫(kù)12341存儲(chǔ)處理器A2SPBIP31存儲(chǔ)處理器A2SPBIP311開(kāi)啟SAN機(jī)234兩臺(tái)HP5#crs_statgrid用捷6 startinstance-dhziee-ihziee1su–sqlplus“/assysdba”7grid1$sqlplus“/assysdba”#srvctlstopinstance-dhziee-ihziee1是關(guān)閉第實(shí)例需修改為hziee22#crsctlstop兩臺(tái)HP3#ps–ef|grep4#shutdownhnow關(guān)機(jī)兩臺(tái)服務(wù)器都需要執(zhí)行567關(guān)閉SAN機(jī)$表示oraclegrid1123121是2是oracle1sysdba$sqlplus“/as2查詢listener$lsnrctlstop可以打開(kāi)/34下次重起數(shù)據(jù)庫(kù)時(shí)oracle會(huì)自動(dòng) 56$crs_stat7$emctlstart8使用 打enterprise如果圖標(biāo)出現(xiàn)亂常用sqlsqlplus"MAXSIZE",024/1024))*100,2)"USED%"fromgroupby 024/1024))*100,2)desc;selectinst_id,count(*)fromgv$sessiongroupbyblock住別的會(huì)話的select*fromv$lockwhereblock=blockselect*fromv$lockwhereid1=注意：id13killsession（altersystem權(quán)限的用戶來(lái)執(zhí)行altersystemkillsessionsidv$lock中獲取(selectsidfromv$sessionwhereblock=1;)，serial#可以從v$session中獲取(selectserial#fromv$sessionwheresid=&sid;)killblocksession的sessionselect'altersystemkillsession'''||s.sid||','||s.serial#||''';'fromv$sessionswheresidin(selectsidfromv$lockwhereblock=1);sid正在運(yùn)行的sqlselectsql_textwherea.hash_value=(selectfromv$sessionwhereb.sid orderbypieceRAC數(shù)據(jù)庫(kù)的項(xiàng)目合同，在經(jīng)過(guò)近十個(gè)工作日的安裝調(diào)試，現(xiàn)已正試安裝完畢。新建成的》11

HZIEEHZIEERACH