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

1、青州碼頭小型機項目實施方案(Solaris 10 U7 + Oracle 10g + ZFS + Sun Cluster 3.2 U2)文檔六、創(chuàng)建 Oracle 雙機軟件資源組一、創(chuàng)建 Oracle 雙機軟件使用的監(jiān)聽用戶在節(jié)點 1 啟動數據庫使用 oracle 用戶 telnet 登陸節(jié)點 1 主機，運行以下命令：$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)建完成后可以關閉數據庫了。SQLshutdown immediateSQLquit二、在兩個節(jié)點上修改 Oracle 監(jiān)聽配置文件修改 /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 文件內容如下：# 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) 二、在兩個節(jié)點安裝 Sun Cluster HA for Oracle掛載 Cluster 光盤鏡像， 使用 root 用戶 telnet 登陸主機， 使用以下命令安裝： #lofiadm a /iso/SC_32U2_DVD.iso /dev/lofi

7、/1#mount F hsfs /dev/lofi/1 /mnt 開始運行安裝程序 #cd /mnt/Solaris_sparc#./Installer組件選擇選定產品 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鮪入要安馥的姐件，以逗號分隔（或前入A安裝全部狙件）A返目，廣退出

12、16選擇“ 2. 以后再配置”后開始安裝到完成。三、創(chuàng) 建 Oracle 故障轉移資源組使用 root 用戶 telnet 登陸節(jié)點 1 主機，使用以下命令創(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運行以上命令后完成資源組創(chuàng)建?？梢允褂靡韵旅钸M行資源組的一些相關操作：clresourcegroup delete -F oracle-rg 刪除資源組及其它包含的所有資源clresourcegroup switch -n fqoradb2 oracle-rg 把資源組切換到節(jié)點 2 上運行clresourcegroup online + 使所有資源組上線clresourcegroup offline

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

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

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