文檔6創(chuàng)建Oracle資源組

1、青州碼頭小型機(jī)項(xiàng)目實(shí)施方案(Solaris 10 U7 + Oracle 10g + ZFS + Sun Cluster 3.2 U2)文檔六、創(chuàng)建 Oracle 雙機(jī)軟件資源組一、創(chuàng)建 Oracle 雙機(jī)軟件使用的監(jiān)聽(tīng)用戶在節(jié)點(diǎn) 1 啟動(dòng)數(shù)據(jù)庫(kù)使用 oracle 用戶 telnet 登陸節(jié)點(diǎn) 1 主機(jī)，運(yùn)行以下命令：$lsnrctl start$sqlplus /nologSQLconn / as sysdbaSQLstartupSQLcreate user ora_monitor identified by ORA_MONITOR default tablespace system quo

2、ta 1m on system;SQLgrant connect, resource to ora_monitor;SQLgrant select on v_$sysstat to ora_monitor;SQLgrant select on v_$archive_dest to ora_monitor;SQLgrant create session to ora_monitor;SQLgrant create table to ora_monitor;創(chuàng)建完成后可以關(guān)閉數(shù)據(jù)庫(kù)了。SQLshutdown immediateSQLquit二、在兩個(gè)節(jié)點(diǎn)上修改 Oracle 監(jiān)聽(tīng)配置文件修改 /u

3、01/oracle/product/10.2.0/network/admin/tnsnames.ora 文件如下：# tnsnames.ora Network Configuration File: /u01/oracle/product/10.2.0/network/admin/tnsnames.ora# Generated by Oracle configuration tools.ORA10G =(DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = fqoradb)(PORT = 1521)(CONNECT_DA

4、 TA =(SERVICE_NAME = ora10g)EXTPROC_CONNECTION_DATA =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)(CONNECT_DA TA =(SID = PLSExtProc)(PRESENTATION = RO)修改 /u01/oracle/product/10.2.0/network/admin/listener.ora 文件內(nèi)容如下：# listener.ora Network Configuration File: /u01/oracle/pro

5、duct/10.2.0/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = fqoradb)(PORT = 1521)SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAM

6、E = PLSExtProc)(ORACLE_HOME = /u01/oracle/product/10.2.0)(PROGRAM = extproc)(SID_DESC =(SID_NAME = ora10g)(ORACLE_HOME = /u01/oracle/product/10.2.0)(GLOBAL_DBNAME = ora10g) 二、在兩個(gè)節(jié)點(diǎn)安裝 Sun Cluster HA for Oracle掛載 Cluster 光盤(pán)鏡像， 使用 root 用戶 telnet 登陸主機(jī)， 使用以下命令安裝： #lofiadm a /iso/SC_32U2_DVD.iso /dev/lofi

7、/1#mount F hsfs /dev/lofi/1 /mnt 開(kāi)始運(yùn)行安裝程序 #cd /mnt/Solaris_sparc#./Installer組件選擇選定產(chǎn)品 Sun Cluster Agents 3.2 1/09*X *X *CX *：X *CX *cxj *cxj *cx *X1.2.47.F9.Sun Sun Sun Sun Sun Sun Sun Sun SunCluster Cluster Cluster Cluster Cluster Cluster Cluster Cluster ClusterHA forHA forHA forHA forHA forJava Sys

8、ten Application Server Java System Fessae Queue Java System Directory Server Java Systeji flfessaing ServerSunSunSunSunApplication Server EE (riADB)HA/Scalable for Sun Java System Veb ServerHA for Instant MessagingHA for Sun Java Systen Calendar ServerHA for Apache Tomcat*X10.Sun ClusterHAforApache*

9、X11.Sun ClusterHAforDHC? CX12.Sun ClusterHAforDNS IX13.Sun ClusterHAforMySQL*CX14.Sun ClusterHAforSun N1 Service Frovisionmj*X15.Sun ClusterHAforNFS*CX16.Sun ClusterHAforOracleIX17.Sun ClusterHAforSanbaIX18.Sun ClusterHAforSun N1 Grid EngineIX19.Sun ClusterHAforSolaris Containers*X20.Sun ClusterSupp

10、ort for Oracle RAC IX21.Sun ClusterHAforOracle E-Busir.ess Suit 2*CXSun ClusterHAforSAP liveCacke*XSun ClusterHAforWebSphere Message Broker*LXSun ClusterHAforWebSphere MQ*LXSun ClusterHAforOracle 9遼S*XSun ClusterHAforSAPDb*XSun ClusterHAforSAP Web Application Server*LXSun ClusterHAforSAP*LXSun Clust

11、erHAforPostgreSQL*LXSun ClusterHAforSybase ASE*CX31.Sun ClusterHAforBEA WebLogic Server*X32.Sun ClusterHAforSiebel*X33.Sun ClusterHAforKerberos*X34.Sun ClusterHAforSwift Alliar.ce Gateway*X35.Sun ClusterHAforSwift ALliar.ce Access*X36.Sun ClusterHAforInfornixSyst em鮪入要安馥的姐件，以逗號(hào)分隔（或前入A安裝全部狙件）A返目，廣退出

12、16選擇“ 2. 以后再配置”后開(kāi)始安裝到完成。三、創(chuàng) 建 Oracle 故障轉(zhuǎn)移資源組使用 root 用戶 telnet 登陸節(jié)點(diǎn) 1 主機(jī)，使用以下命令創(chuàng)建資源組：clresourcegroup create oracle-rg clreslogicalhostname create -g oracle-rg fqoradb clresourcetype register SUNW.HAStoragePlus-p AffinityOn=TRUE oracle-hastorageplusclresourcetype register SUNW.oracle_server clresource

13、type register SUNW.oracle_listeneroracle-serveroracle-listenerclresourcegroup online -M oracle-rg運(yùn)行以上命令后完成資源組創(chuàng)建?？梢允褂靡韵旅钸M(jìn)行資源組的一些相關(guān)操作：clresourcegroup delete -F oracle-rg 刪除資源組及其它包含的所有資源clresourcegroup switch -n fqoradb2 oracle-rg 把資源組切換到節(jié)點(diǎn) 2 上運(yùn)行clresourcegroup online + 使所有資源組上線clresourcegroup offline

14、 +使所有資源組離線clresource disable 資源名停用某個(gè)資源clresource delete 資源名 刪除某個(gè)資源，刪除前需要先停止它c(diǎn)lresourcetype unregister 注冊(cè)資源名刪除注冊(cè)資源類(lèi)型(如 SUNW.HAStoragePlus 、 SUNW.oracle_server 、 SUNW.oracle_listener ) cluster status 查看資源組運(yùn)行情況可以切換資源組核查資源組運(yùn)行情況， 無(wú)誤后可以使用 scshutdown g0 y 關(guān)閉主機(jī)， 再 boot 開(kāi)機(jī)查看資源組是否正常加載。以下是青州 cluster status 的輸出

15、信息群集節(jié)點(diǎn) =- 節(jié)點(diǎn)狀態(tài) -狀態(tài)節(jié)點(diǎn)名稱(chēng)OnlineOnlinefqoradb1fqoradb2 群集傳輸路徑 =端點(diǎn) 1 端點(diǎn) 2 狀態(tài)fqoradb1:bge1fqoradb2:bge1Path onlinefqoradb1:bge0fqoradb2:bge0Path online群集法定設(shè)備 =- Quorum Votes Summary from latest node reconfiguration -需要的 現(xiàn)有的可能的233- Quorum Votes by Node (current status) -節(jié)點(diǎn)名稱(chēng) 現(xiàn)有的 可能的 狀態(tài)fqoradb111Onlinefqora

16、db211Online- Quorum Votes by Device (current status) -設(shè)備名稱(chēng)現(xiàn)有的可能的狀態(tài)d511Online群集設(shè)備組 =- 設(shè)備組狀態(tài) -設(shè)備組名稱(chēng)主節(jié)點(diǎn)輔助狀態(tài)- 備用節(jié)點(diǎn)、非活動(dòng)節(jié)點(diǎn)和轉(zhuǎn)換中的節(jié)點(diǎn)設(shè)備組名稱(chēng) 備用節(jié)點(diǎn)非活動(dòng)節(jié)點(diǎn) 正在轉(zhuǎn)換的節(jié)點(diǎn)- 多屬主設(shè)備組的狀態(tài) - 設(shè)備組名稱(chēng) 節(jié)點(diǎn)名稱(chēng) 狀態(tài)群集資源組 =組名稱(chēng)節(jié)點(diǎn)名稱(chēng) 已暫停 狀態(tài)oracle-rgfqoradb1 NoOnlinefqoradb2 NoOffline群集資源 =狀態(tài)消息資源名稱(chēng)節(jié)點(diǎn)名稱(chēng)狀態(tài)fqoradbfqoradb1OnlineOnline - LogicalHostname onlinefqoradb2OfflineOfflineoracle-hastorageplusfqoradb1OnlineOnlinefqoradb2OfflineOfflineoracle-serverfqoradb1OnlineOnlinefqoradb2OfflineOfflineoracle-listenerfqoradb1Onli