文档6创建Oracle资源组0001

1、青州码头小型机项目实施方案(Solaris 10 U7 + Oracle 10g + ZFS + Sun Cluster 3.2 U2)文档六、创建 Oracle 双机软件资源组一、创建 Oracle 双机软件使用的监听用户在节点 1 启动数据库使用 oracle 用户 telnet 登陆节点 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;创建完成后可以关闭数据库了。SQLshutdown immediateSQLquit二、在两个节点上修改 Oracle 监听配置文件修改 /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) 二、在两个节点安装 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. 以后再配置”后开始安装到完成。三、创 建 Oracle 故障转移资源组使用 root 用户 telnet 登陆节点 1 主机，使用以下命令创建资源组：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运行以上命令后完成资源组创建。可以使用以下命令进行资源组的一些相关操作：clresourcegroup delete -F oracle-rg 删除资源组及其它包含的所有资源clresourcegroup switch -n fqoradb2 oracle-rg 把资源组切换到节点 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、信息群集节点 =- 节点状态 -状态节点名称OnlineOnlinefqoradb1fqoradb2 群集传输路径 =端点 1 端点 2 状态fqoradb1:bge1fqoradb2:bge1Path onlinefqoradb1:bge0fqoradb2:bge0Path online群集法定设备 =- Quorum Votes Summary from latest node reconfiguration -需要的 现有的可能的233- Quorum Votes by Node (current status) -节点名称 现有的 可能的 状态fqoradb111Onlinefqora

16、db211Online- Quorum Votes by Device (current status) -设备名称现有的可能的状态d511Online群集设备组 =- 设备组状态 -设备组名称主节点辅助状态- 备用节点、非活动节点和转换中的节点设备组名称 备用节点非活动节点 正在转换的节点- 多属主设备组的状态 - 设备组名称 节点名称 状态群集资源组 =组名称节点名称 已暂停 状态oracle-rgfqoradb1 NoOnlinefqoradb2 NoOffline群集资源 =状态消息资源名称节点名称状态fqoradbfqoradb1OnlineOnline - LogicalHostname onlinefqoradb2OfflineOfflineoracle-hastorageplusfqoradb1OnlineOnlinefqoradb2OfflineOfflineoracle-serverfqoradb1OnlineOnlinefqoradb2OfflineOfflineoracle-listenerfqoradb1Onli