在Solaris 10 X86上安装Oracle 10g RAC详解

1、在Solaris 10 X86上安装Oracle 10g RAC详解 (1) HYPERLINK /yu_gq/blog/;t=d.selection?(d.selection.type!=None?d.selection.createRange().text:):(d.getSelection?d.getSelection():);void(saveit=window.open(/storeit.aspx?t=+escape(d.title)+&u=+escape(d.location.href)+&c=+escape(t),saveit,scrollbars=no,width=590,he

2、ight=300,left=75,top=20,status=no,resizable=yes);saveit.focus(); o 收藏到我的网摘中，并分享给我的朋友 HYPERLINK /longrujun/archive/2006/04/25/675934.aspx 概述本文详细介绍了如何在基于Solaris 10 X86的节点上来安装Oracle 10g RAC的具体步骤和注意事项，同时也提供了具体的命令操作以及安装过程的截屏，最后是创建一个Cluster数据库的具体步骤。系统环境两台Sun的基于 AMD64的机器(V20Z) 一台Sun的Storage(3510)一个百兆交换机Sol

3、aris 10 X86 1/06Oracle 10g EE RAC for Solaris X86 with Oracle patch 4186426其中两个V20Z节点通过光纤卡直接和Storage3510相连接安装前期配置本文中的Oracle RAC的安装是基于两个节点的配置，很多步骤需要在两个节点(RAC1 和RAC2）上都要完成,以下是安装Oracle RAC前需要做的准备工作:1,在所有节点上创建Oracle用户组和帐号bash-3.00# groupadd -g 100 oinstallbash-3.00# groupadd -g 101 dbabash-3.00# mkdir -

4、p /export/homebash-3.00# useradd -u 200 -g oinstall -G dba -s /usr/bin/bash -d /export/home/oracle -m oraclebash-3.00# id -a oracleuid=200(oracle) gid=100(oinstall) groups=101(dba)添加完用户后需要为oracle用户设置密码，使得帐号生效。2，在所有节点上验证用户nobody是否存在bash-3.00# id -a nobodyuid=60001(nobody) gid=60001(nobody) groups=600

5、01(nobody)3，为所有的节点设置网络地址对于每个节点，Oracle RAC需要设置一个公共的网络地址，一个虚拟的未用网络地址和一个私有网络地址，对于公共的网络地址，这里假设已经在安装系统时已经配置完成，即将bge0配置为公共地址，以下是配置其他网络地址的具体步骤，bash-3.00# ifconfig bge0:1 plumb upbash-3.00# ifconfig bge0:1 12 netmask bash-3.00# ifconfig bge1 plumb upbash-3.00# ifconfig bge1 2 netmask 可以将这些步骤写入/etc/profile,使

6、得每次系统启动后，这些地址自动就配置完成。最终的网络配置为：bash-3.00# ifconfig -alo0: flags=2001000849 mtu 8232 index 1inet netmask ff000000 bge0: flags=1000843 mtu 1500 index 2inet 22 netmask ffffff00 broadcast 55ether 0:9:3d:0:75:20 bge0:1: flags=1000843 mtu 1500 index 2inet 12 netmask ffffff00 broadcast 55bge1: flags=1000803

7、 mtu 1500 index 3inet 2 netmask ffffff00 broadcast 55ether 0:9:3d:0:75:21 bash-3.00$ netstat -rnRouting Table: IPv4Destination Gateway Flags Ref Use Interface- - - - - - 1 U 1 0 bge1 21 U 1 47 bge0 11 U 1 0 bge0:1 21 U 1 0 bge0 UH 23 25657 lo04,在所有节点上，生成文件/etc/hostname.bge0 和/etc/hostname.bge1具体内容如下

8、，并需将网络配置写入文件/etc/hostsbash-3.00$ more /etc/host*:/etc/hostname.bge0:RAC1:/etc/hostname.bge1:rac_priv_host1:/etc/hosts:# Internet host table# localhost 21 RAC1. RAC122 RAC2. RAC211 RAC1-VIR. RAC1-VIR12 RAC2-VIR. RAC2-VIR1 rac_priv_host12 rac_priv_host25,配置信任主机Oracle RAC需要将所有节点配置成为信任主机，即在所有节点上生成具有以下内容

9、的文件/etc/hosts.equiv,并进行测试bash-3.00$ more /etc/hosts.equiv RAC1. oracleRAC2. oracleRAC1 oracleRAC2 oraclersh RAC2 dateThu Jan 19 02:12:12 CST 2006rsh RAC2 hostnameRAC26,在所有节点上创建Oracle RAC安装目录并设置权限bash-3.00# mkdir -p /u01/app/oracle/product/oraclebash-3.00# chown -R oracle:oinstall /u01/app/oracle /pr

10、oduct/oraclebash-3.00# chmod -R 755 /u01/app/oracle/product/oraclebash-3.00# mkdir -p /u01/crs/oracle/product/crsbash-3.00# chown -R oracle:oinstall /u01/crs/oracle/product/crsbash-3.00# chmod -R 755 /u01/crs/oracle/product/crs为安装Oracle CRS在所有节点上设置Oracle的环境变量在$HOME/.profile,$HOME为用户oracle的起始目录bash-3

11、.00$ cat .profile ORACLE_BASE=/u01/app/oracleexport ORACLE_BASEORACLE_HOME=/u01/crs/oracle/product/crsexport ORACLE_HOMEPATH=$PATH:$ORACLE_HOME/bin:/usr/bin:/usr/ccs/bin:/bin:/usr/openwin/binexport PATH在所有节点上将以下系统设置写入文件/etc/systemset semsys:seminfo_semmni 100set semsys:seminfo_semmns 1024set semsys:

12、seminfo_semmsl 256set semsys:seminfo_semvmx 32767set shmsys:shminfo_shmmax 4294967295set shmsys:shminfo_shmmin 1007,存储设备的配置:在这里，我们用了Sun Storage3510来做为安装Oracle 10g RAC的设备，并将其配置为raw partitions，以下为具体的需求:Oracle和Oracle CRS需要的Raw Partitions数目和大小从以上的表格可以看出，对于两个节点的Oracle RAC,我们需要在存储器上配置17个raw partitions(创建O

13、racle数据库需要15个，安装Oracle CRS需要2个）,由于每个Solaris的磁盘最多只能有7个slice供使用(slice 2,8,9是不能用做分区的),所以需要在Storage 3510上来分多个磁盘来满足需要,然后在Solaris中对每个盘进行分区，注意的是为了避免CRS或是Oracle数据库文件覆盖磁盘中的分区表，在分slices时不能从cylinder 0(比如slice 2)开始。由于3510的分区在Solaris中的设备名为一个很长的字符串，为了更方便的表示这些设备，这里采用了创建连接到这些设备的方法，并设置相应的属性和权限，这两个设备是为Oracel CRS安装用的，

14、见以下步骤：mkdir /ORACLEcd /ORACLEln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C802d0s0 ocrchown -RL root:oinstall ocrchmod -R 640 ocrln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C802d0s1 votechown -RL oracle:dba vote chmod -R 640 vote安装Oracle CRS当以上所有的配置完成后，我们就可以进行Oracle CRS的安装了启动Oracle CRS安装脚本，注意参数

15、-ignoreSysPrereqs是为了忽略版本检查带来的错误，./runInstaller -ignoreSysPrereqs以下是具体的安装步骤和图示,1,欢迎界面，直接点击next2,指定详细目录和凭证 此时会弹出一个提示栏要求在RAC1上运行一个脚本，如下：/u01/crs/oracle/oraInventory/orainstRoot.sh chmod: WARNING: cant access /var/opt/oracleCreating the Oracle inventory pointer file (/var/opt/oracle/oraInst.loc)Changing

16、 groupname of /u01/crs/oracle/oraInventory to oinstall.2,指定安装文件的路径，缺省的安装路径来自于我们先前在$HOME/.profile的设置3,选择语言-点击下一步4,配置cluster5,指定网络接口的用途，这里我们指定bge0做为公共网络接口，bge1做为私有网络接口6,指定OCR的路径为/ORACLE/ocr7,指定Vote的路径为 /ORACLE/ocr此时需要用户在所有节点上以root身份来运行脚本orainstRoot.sh,如下：/u01/crs/oracle/oraInventory/orainstRoot.sh Cre

17、ating the Oracle inventory pointer file (/var/opt/oracle/oraInst.loc)Changing groupname of /u01/crs/oracle/oraInventory to oinstall./u01/crs/oracle/oraInventory/orainstRoot.shchmod: WARNING: cant access /var/opt/oracleCreating the Oracle inventory pointer file (/var/opt/oracle/oraInst.loc)Changing g

18、roupname of /u01/crs/oracle/oraInventory to oinstall.8,然后会出现安装配置的小结界面，点击下一步后就进入安装阶段：9,安装过程,从图中我们看到CRS安装程序自动向另一个节点RAC2拷贝文件在安装后期，会提示用户在所有节点上以 root身份来运行root.sh，如下：/u01/crs/oracle/product/crs/root.sh Running Oracle10 root.sh script.The following environment variables are set as:ORACLE_OWNER= oracleORACL

19、E_HOME= /u01/crs/oracle/product/crsFinished running generic part of root.sh script.Now product-specific root actions will be performed.Checking to see if Oracle CRS stack is already up.Setting the permissions on OCR backup directoryOracle Cluster Registry configuration upgraded successfullyWARNING:

20、directory /u01/crs/oracle/product/ is not owned by rootWARNING: directory /u01/crs/oracle/product is not owned by rootWARNING: directory /u01/crs/oracle is not owned by rootclscfg: EXISTING configuration version 2 detected.clscfg: version 2 is 10G Release 1.assigning default hostname rac1 for node 1

21、.assigning default hostname rac2 for node 2.Successfully accumulated necessary OCR keys.Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.node : node 1: rac1 rac_priv_host1 rac1node 2: rac2 rac_priv_host2 rac2clscfg: Arguments check out successfully.NO KEYS WERE WRITTEN. Supply -force param

22、eter to override.-force is destructive and will destroy any previous clusterconfiguration.Oracle Cluster Registry for cluster has already been initializedAdding daemons to inittabPreparing Oracle Cluster Ready Services (CRS):Expecting the CRS daemons to be up within 600 seconds.CSS is active on thes

23、e nodes.rac1rac2CSS is active on all nodes.Waiting for the Oracle CRSD and EVMD to startOracle CRS stack installed and running under init(1M)/u01/crs/oracle/product/crs/root.sh Running Oracle10 root.sh script.The following environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /u01/crs/or

24、acle/product/crsFinished running generic part of root.sh script.Now product-specific root actions will be performed.Checking to see if Oracle CRS stack is already up.Setting the permissions on OCR backup directoryOracle Cluster Registry configuration upgraded successfullyWARNING: directory /u01/crs/

25、oracle/product/ is not owned by rootWARNING: directory /u01/crs/oracle/product is not owned by rootWARNING: directory /u01/crs/oracle is not owned by rootassigning default hostname rac1 for node 1.assigning default hostname rac2 for node 2.Successfully accumulated necessary OCR keys.Using ports: CSS

26、=49895 CRS=49896 EVMC=49898 and EVMR=49897.node : node 1: rac1 rac_priv_host1 rac1node 2: rac2 rac_priv_host2 rac2Creating OCR keys for user root, privgrp root.Operation successful.Now formatting voting device: /ORACLE/voteSuccessful in setting block0 for voting disk.Format complete.Adding daemons t

27、o inittabPreparing Oracle Cluster Ready Services (CRS):Expecting the CRS daemons to be up within 600 seconds.CSS is active on these nodes.rac1rac2CSS is active on all nodes.Waiting for the Oracle CRSD and EVMD to startOracle CRS stack installed and running under init(1M)以上步骤完成后，整个CRS的安装就完成了我们可以做一些测试

28、来验证CRS的安装是否正确cd /u01/crs/oracle/product/crs/bin/pwd/u01/crs/oracle/product/crs/bin./olsnodes -nrac1 1rac2 2同时要注意，当Oracle CRS安装完成后，以下进程是必须要在运行状态的：1，oprocd Cluster的进程监控器2，evmd 事件管理守护进程3，ocssd Cluster节点关系管理进程4, crsd - 高可靠性恢复和管理操作进程安装Oracle10g数据库安装好CRS后，就可以在此基础上安装Oracle 10g 了，由于Oracle 10g和Solaris 10 X86

29、在内存管理方式有些不兼容，对于双CPU的V20Z机器，我们需要将一个CPU暂时离线，等Oracle安装好后可以将离线的CPU重新起动,暂停一个CPU的步骤如下：psradm -f 1psrinfo 0 on-line since 01/19/2006 16:47:511 off-line since 01/19/2006 18:48:26为安装Oracle 10g在所有节点上重新设置Oracle的环境变量在$HOME/.profile,$HOME为用户oracle的起始目录bash-3.00$ cat .profile ORACLE_BASE=/u01/app/oracleexport ORA

30、CLE_BASEORACLE_HOME=/u01/crs/oracle/product/oracleexport ORACLE_HOMEPATH=$PATH:$ORACLE_HOME/bin:/usr/bin:/usr/ccs/bin:/bin:/usr/openwin/binexport PATH开始安装Oralce 10g,如下，同样， 参数-ignoreSysPrereqs是为了忽略版本检查带来的错误./runInstaller -ignoreSysPrereqs以下为具体的步骤和截屏1，欢迎界面后就进入到指定安装路径界面，缺省路径来自于$HOME/.profile的设置3,制定Clus

31、ter安装模式，在这里我们选中两个节点，RAC1和RAC24,接下来的界面中选择安装类型为”Enterprise Edition”,在其后的数据库配置中，这里选择先不创建一个起始数据库，本文中将在Oracle 10g安装好后再创建一个数据库6,接下来就进入到安装界面，可以看到Oracle安装到了所有节点同样，安装后期会提示用户在所有节点上以root身份运行脚本root.sh,这时在RAC1运行是还要进行VIP配置。/u01/app/oracle/product/oracle/root.sh Running Oracle10 root.sh script.The following enviro

32、nment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /u01/app/oracle/product/oracleEnter the full pathname of the local bin directory: /usr/local/bin: Creating /usr/local/bin directory.Copying dbhome to /usr/local/bin .Copying oraenv to /usr/local/bin .Copying coraenv to /usr/local/bin .Addin

33、g entry to /var/opt/oracle/oratab file.Entries will be added to the /var/opt/oracle/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.此时Oracle安装程序会进行VIP配置，需要选择网络接口和各个节

34、点的虚拟地址配置完成后会出现显示整个配置的结果：同时需要在另一个节点RAC2上运行root.sh/u01/app/oracle/product/oracle/root.sh Running Oracle10 root.sh script.The following environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /u01/app/oracle/product/oracleEnter the full pathname of the local bin directory: /usr/local/bin: Cre

35、ating /usr/local/bin directory.Copying dbhome to /usr/local/bin .Copying oraenv to /usr/local/bin .Copying coraenv to /usr/local/bin .Creating /var/opt/oracle/oratab file.Adding entry to /var/opt/oracle/oratab file.Entries will be added to the /var/opt/oracle/oratab file as needed byDatabase Configu

36、ration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.CRS resources are already configured以上步骤完成后，整个Oracle 10g的安装就完成了。下面我们还需要进行Oracle网络服务的配置，具体步骤如下：netcaOracle Net Services Configuration:1, 在网络服务配置时选择”Cluster co

37、nfiguration”,如下图所示：2,选中需要进行配置的节点，这里选中RAC1和RAC2。3,以后的配置可以按照缺省项一步步进行，最后直到配置成功完成。1,在创建数据库之前，我们还需要添加一个Oracle的补丁4186426,这个补丁解决了启动Oracle实例时会失败的错误，用户可以从上得到这一补丁,需要注意的是安装这个补丁时要按照它提供的步骤进行，这里不做详述.在所有节点上创建数据库1，由于创建oracle数据库需要多个raw devices,这里为了方便起见，将这些raw devices的设备文件连接成更易懂的文件名,同时需要设置相应的属主和权限，具体步骤如下：cd ORACLEmkd

38、ir dbchown oracle:root dbcd dblsln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C800d0s0 systemln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C800d0s1 sysauxln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C800d0s3 undotbs1ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C800d0s4 undotbs2ln -s /dev/rdsk/

39、c3t600C0FF00000000007D35237AD84C800d0s5 temp ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s0 exampleln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s1 users ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s3 redo1_1ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s4 redo1_2ln -

40、s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s5 redo2_1ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s6 redo2_2ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s7 spfile ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C802d0s3 control1ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C802

41、d0s4 control2ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C802d0s5 pwdfile pwd /ORACLE/dbchown -RL oracle:dba *chmod -R 660 *将以上的目录做为创建数据库所需raw devices的配置文件，具体步骤为：mkdir -p /u01/app/oracle/oradata/tree并在此目录下创建文件tree_raw.conf,具体内容如下：cat tree_raw.conf system=/ORACLE/db/systemsysaux=/ORACLE/db/sysauxe

42、xample=/ORACLE/db/exampleusers=/ORACLE/db/userstemp=/ORACLE/db/tempundotbs1=/ORACLE/db/undotbs1undotbs2=/ORACLE/db/undotbs2redo1_1=/ORACLE/db/redo1_1redo1_2=/ORACLE/db/redo1_2redo2_1=/ORACLE/db/redo2_1redo2_2=/ORACLE/db/redo2_2control1=/ORACLE/db/control1control2=/ORACLE/db/control2spfile=/ORACLE/db

43、/spfilepwdfile=/ORACLE/db/pwdfile然后编辑文件/export/home/oracle/.profile,将以下几列加入DBCA_RAW_CONFIG=/u01/app/oracle/oradata/tree/tree_raw.confexport DBCA_RAW_CONFIG2，在各节点上分别设置环境变量RAC1,ORACLE_SID=tree1export ORACLE_SIDRAC2,ORACLE_SID=tree2export ORACLE_SID3,和安装Oracle数据库一样，需要将节点RAC1和RAC2上的另一个CPU离线，可参照安装Oracle数

44、据库一节中的步骤来做。=以oracle用户来创建一个Cluster数据库，具体步骤如下：dbca创建数据库步骤：1,选择数据库的类型,这里需要选择创建Oracle Real Application Clusters database然后选择创建一个数据库并随后在节点选择时选中两个节点RAC1和RAC2.4,在选择模板时，这里选择创建”General Purpose”的数据库。5,随后按照提示输入全局数据库的名字，这里设定名字为”tree”6,在随后的数据库管理选项中选取Oracle Enterprise Manager Grid Control,即不选中”Configure the Datab

45、ase with Enterprise Manage”的选项以后的步骤中需要设定密码，设定存储和恢复机制以及数据库内容和服务，这里按照缺省值设定即可。随后要设置数据库的初始参数，在此，根据机器的内存大小，设定SGA为800M，PGA 为200M，用户可根据具体的环境来设定相应的大小接下来需要配置数据库的存储并设置创建数据库的一些选项,所有这些设置完成后，就开始创建数据库，最终顺利建立，见下图：在此我们还可以来起动并验证一下刚刚创建的数据库-oracle:RAC1srvctl status database -d treeInstance tree1 is running on node rac1Instance tree2 is running on node rac2srvctl status nodeapps -n RAC1VIP is running on node: RAC1GSD is running on node: RAC1Listene