Linux6.5x86_64安装11.2.0.4RAC手工建库添加节点

1、Linux 6.5 x86_64 安装 RAC目录1 介绍41 环境规划41.1 网络规划41.2 存储规划42 安装操作系统42.1 关闭一些无效的服务42.2 关闭防火墙52.3 配置网卡52.4 修改主机名62.5 配置/etc/hosts62.6 安装依赖包72.7 修改主机参数102.8 添加用户112.9 配置目录，配置权限，配置profile112.10 配置存储132.11 变成udev142.12 复制新主机143 grid的安装153.1 安装截图163.2 安装过程中执行2个脚本264 Databas的安装264.1 安装截图264.2 安装过程中执行1个

2、脚本345 手工建库355.1 在rac001 建立口令文件355.2 建立pfile 文件,修改initORCL1.ora后， 如下355.3 创建目录365.4 instance启动数据库到nomount365.5 建库，建库脚本如下：365.6 建立数据字典，运行以下数据字典的脚本375.7 创建spfile,并修改initORCL1.ora375.8 添加undo tablespace,REdo385.9 rac02创建目录385.10 修改相应的rac参数385.11 设置节点2的sys密码和启动文件385.12 启动节点2395.13 注册database、instance，并验证

3、396 添加节点396.1 补上依赖包396.2 配置oracle用户在rac1，rac2 rac3 相互信任396.3 执行安装前检查406.4 执行grid节点的添加406.4.1 中间有2个脚本要在rac03执行416.5 执行database节点的添加416.5.1 中间有1个脚本要在rac03执行416.6 添加undo tablespace,REdo416.7 rac03创建目录416.8 修改相应的rac参数416.9 设置节点3的sys密码和启动文件426.10 启动节点3421 介绍c1 环境规划1.1 网络规划节点PublicPrivateVipSanipHostname节

4、点11111rac01节点2222rac02节点3333rac03节点Public 名字Private 名字Vip 名字Sanip 名字Hostname节点1rac01rac01privrac01viprac01scanrac01节点2rac02rac02privrac02viprac02节点3rac03rac03privrac03viprac031.

5、2 存储规划项目大小盘的数目OCR2G1*2GVote2G1*2GData20G5*10G2 安装操作系统2.1 关闭一些无效的服务chkconfig cups offchkconfig sendmail offchkconfig isdn offchkconfig smartd offchkconfig ntpd offchkconfig iptables offservice iptables stopmv /etc/ntp.conf /etc/ntp.conf.bakmv /etc/resolv.conf /etc/resolv.conf.bak2.2 关闭防火墙chkconfig ip

6、tables offservice iptables stopchkconfig iptables off2.3 配置网卡1.root进入linux，删除/etc/udev/rules.d/70-persistent-net.rules文件，2.重启3.参考70-persistent-net.rules中的内容，编辑/etc/sysconfig/network-scripts/ifcfg-eth0/etc/sysconfig/network-scripts/ifcfg-eth1vi /etc/sysconfig/network-scripts/ifcfg-eth0DEVICE=eth0ONBO

7、OT=yesBOOTPROTO=staticIPADDR=1NETMASK=HWADDR=00:50:56:2B:FB:F6vi /etc/sysconfig/network-scripts/ifcfg-eth1DEVICE=eth1ONBOOT=yesBOOTPROTO=staticIPADDR=1NETMASK=HWADDR=00:0C:29:D6:E6:F34.重启网卡service network restartor/etc/init.d/network restart2.4 修改主机

8、名节点1rootlocalhost # vi /etc/sysconfig/networkNETWORKING=yesHOSTNAME=rac01节点1rootlocalhost # vi /etc/sysconfig/networkNETWORKING=yesHOSTNAME=rac02节点1rootlocalhost # vi /etc/sysconfig/networkNETWORKING=yesHOSTNAME=rac032.5 配置/etc/hosts3个节点使用相同的信息rootlocalhost # vi /etc/hosts localhost localho

9、st.localdomain localhost4 localhost4.localdomain4:1 localhost localhost.localdomain localhost6 localhost6.localdomain61 rac011 rac01priv1 rac01vip2 rac022 rac02priv2 rac02vip3 rac033 rac03priv192.168.1

10、0.23 rac03vip1 rac01scan2.6 安装依赖包3个主机都要安装依赖包rootlocalhost # rootlocalhost # cd /media/RHEL_6.5 x86_64 Disc 1/rootlocalhost RHEL_6.5 x86_64 Disc 1# cd Packages/rootlocalhost Packages# rpm -ivh binutils-.2-5.36.el6.x86_64.rpm warning: binutils-.2-5.36.el6.x86_64.rpm: Head

11、er V3 RSA/SHA256 Signature, key ID fd431d51: NOKEYPreparing. # 100% package binutils-.2-5.36.el6.x86_64 is already installedrootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rpm -ivh compat-libcap1-1.10-1.x86_64.rpm warni

12、ng: compat-libcap1-1.10-1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEYPreparing. # 100% 1:compat-libcap1 # 100%rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rpm -ivh compat-libstdc+-33-3.2.3-69.el6.x86_64.rpm warning: compat-libstdc+-33-3.2.3-69.el6.x8

13、6_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEYPreparing. # 100% 1:compat-libstdc+-33 # 100%rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rpm -ivh gcc-4.4.7-4.el6.x86_64.rpm warning: gcc-4.4.7-4.el6.x86_64.rpm: Header V3 RSA/SHA256 S

14、ignature, key ID fd431d51: NOKEYPreparing. # 100% package gcc-4.4.7-4.el6.x86_64 is already installedrootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rpm -ivh libstdc+-devel-4.4.7-4

15、.el6.x86_64.rpm warning: libstdc+-devel-4.4.7-4.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEYPreparing. # 100% 1:libstdc+-devel # 100%rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rpm -ivh gcc-c+-4.4.7-4.el6.x86_64.rpm warning: gcc-c+-4.4.7-4.el6.x8

16、6_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEYPreparing. # 100% 1:gcc-c+ # 100%rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rpm -ivh glibc-2.12-1.132.el6.x86_64.rpm warning: glibc-2.12-1.132.el6.x86_64.rpm: Header V3 RSA/SHA256 Sig

17、nature, key ID fd431d51: NOKEYPreparing. # 100% package glibc-2.12-1.132.el6.x86_64 is already installedrootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rpm -ivh glibc-devel-2.12-1.132.el6.x86_64.rpm warning: glibc-devel-2.12-1.132.el6.x86_64.rpm: Heade

18、r V3 RSA/SHA256 Signature, key ID fd431d51: NOKEYPreparing. # 100% package glibc-devel-2.12-1.132.el6.x86_64 is already installedrootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rpm -ivh libgcc-4.4.7-4.el6.x86_64.rpm warning: libgcc-4.4.7-4.el6.x86_64.r

19、pm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEYPreparing. # 100% package libgcc-4.4.7-4.el6.x86_64 is already installedrootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rpm -ivh libstdc+-4.4.7-4.el6.x86_64.rpm warning: libstdc+-4.4.7-4.el6.x86

20、_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEYPreparing. # 100% package libstdc+-4.4.7-4.el6.x86_64 is already installedrootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rpm -ivh libstdc+-devel-4.4.7-4.el6.x86_64.rpm warning: libstdc+-de

21、vel-4.4.7-4.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEYPreparing. # 100% package libstdc+-devel-4.4.7-4.el6.x86_64 is already installedrootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm warning: libaio-0.3.107-

22、10.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEYPreparing. # 100% package libaio-0.3.107-10.el6.x86_64 is already installedrootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rpm -ivh libaio-devel-0.3.107-10.el6.x86_64.rpm warning:

23、 libaio-devel-0.3.107-10.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEYPreparing. # 100% 1:libaio-devel # 100%rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rpm -ivh sysstat-9.0.4-22.el6.x86_64.rpm warning: sysstat-9.0.4-22.el6

24、.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEYPreparing. # 100% package sysstat-9.0.4-22.el6.x86_64 is already installedrootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rootlocalhost Packages# rpm -ivh elfutils-libelf-devel-0.152-1.

25、el6.x86_64.rpm warning: elfutils-libelf-devel-0.152-1.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEYPreparing. # 100% 1:elfutils-libelf-devel # 100%rootlocalhost Packages# 通过ftp上传pdksh-5.2.14-30.x86_64.rpm 到 /root 目录rootlocalhost # rpm -ivh pdksh-5.2.14-30.x86_64.rpm warning:

26、 pdksh-5.2.14-30.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 73307de6: NOKEYPreparing. # 100% 1:pdksh # 100%rootlocalhost #2.7 修改主机参数3个节点都要修改vi /etc/sysctl.confkernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 6815744net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default =

27、 262144net.core.wmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_max = 1048576fs.aio-max-nr = 1048576vi /etc/security/limits.confgrid soft nofile 1024grid hard nofile 65536grid soft nproc 2047grid hard nproc 16384grid soft stack 10240grid hard stack 32768oracle soft nofile 1024oracle ha

28、rd nofile 65536oracle soft nproc 2047oracle hard nproc 16384oracle soft stack 10240oracle hard stack 327682.8 添加用户3个节点都要执行=root执行创建目录，创建用户/usr/sbin/groupadd -g 54321 oinstall/usr/sbin/groupadd -g 54322 dba/usr/sbin/groupadd -g 54323 oper/usr/sbin/groupadd -g 54325 dgdba/usr/sbin/groupadd -g 54327 as

29、mdba/usr/sbin/groupadd -g 54328 asmoper/usr/sbin/groupadd -g 54329 asmadmin/usr/sbin/useradd -u 54321 -g oinstall -G asmadmin,asmdba,asmoper,dba grid/usr/sbin/useradd -u 54322 -g oinstall -G dba,dgdba,asmadmin,oper,asmdba oracle=设置grid，oracle的密码passwd gridpasswd oracle2.9 配置目录，配置权限，配置profile节点1：=roo

30、tmkdir -p /u01/app/oraclemkdir -p /u01/app/gridmkdir -p /u01/app/11.2.0/gridchown -R oracle:oinstall /u01/app/chmod -R 775 /u01/-gridvi .bash_profileexport ORACLE_BASE=/u01/app/gridexport ORACLE_HOME=/u01/app/11.2.0/gridexport PATH=$ORACLE_HOME/bin:$PATHexport ORACLE_SID=+ASM1节点2：=rootmkdir -p /u01/

31、app/oraclemkdir -p /u01/app/gridmkdir -p /u01/app/11.2.0/gridchown -R oracle:oinstall /u01/app/chmod -R 775 /u01/-gridvi .bash_profileexport ORACLE_BASE=/u01/app/gridexport ORACLE_HOME=/u01/app/11.2.0/gridexport PATH=$ORACLE_HOME/bin:$PATHexport ORACLE_SID=+ASM2节点3=rootmkdir -p /u01/app/oraclemkdir

32、-p /u01/app/gridmkdir -p /u01/app/11.2.0/gridchown -R oracle:oinstall /u01/app/chmod -R 775 /u01/-gridvi .bash_profileexport ORACLE_BASE=/u01/app/gridexport ORACLE_HOME=/u01/app/11.2.0/gridexport PATH=$ORACLE_HOME/bin:$PATHexport ORACLE_SID=+ASM32.10 配置存储=虚拟机的共享存储的配置在dos命令行下cd C:Program Files (x86)V

33、MwareVMware Workstationvmware-vdiskmanager.exe -c -s 2G -a lsilogic -t 2 E:rac11204shareocr.vmdkvmware-vdiskmanager.exe -c -s 2G -a lsilogic -t 2 E:rac11204sharevote.vmdkvmware-vdiskmanager.exe -c -s 10G -a lsilogic -t 2 E:rac11204shareDATA1.vmdkvmware-vdiskmanager.exe -c -s 10G -a lsilogic -t 2 E:r

34、ac11204shareDATA2.vmdkvmware-vdiskmanager.exe -c -s 10G -a lsilogic -t 2 E:rac11204shareDATA3.vmdkvmware-vdiskmanager.exe -c -s 10G -a lsilogic -t 2 E:rac11204shareDATA4.vmdkvmware-vdiskmanager.exe -c -s 10G -a lsilogic -t 2 E:rac11204shareDATA5.vmdk修改vmx文件，加上scsi1.present = TRUEscsi1.virtualDev = l

35、silogicscsi1.sharedBus = virtualscsi1:1.present = TRUEscsi1:1.mode = independent-persistentscsi1:1.filename = E:rac11204shareocr.vmdkscsi1:1.deviceType = plainDiskscsi1:2.present = TRUEscsi1:2.mode = independent-persistentscsi1:2.filename = E:rac11204sharevote.vmdkscsi1:2.deviceType = plainDiskscsi1

36、:3.present = TRUEscsi1:3.mode = independent-persistentscsi1:3.filename = E:rac11204shareDATA1.vmdkscsi1:3.deviceType = plainDiskscsi1:4.present = TRUEscsi1:4.mode = independent-persistentscsi1:4.filename = E:rac11204shareDATA2.vmdkscsi1:4.deviceType = plainDiskscsi1:5.present = TRUEscsi1:5.mode = in

37、dependent-persistentscsi1:5.filename = E:rac11204shareDATA3.vmdkscsi1:5.deviceType = plainDiskscsi1:6.present = TRUEscsi1:6.mode = independent-persistentscsi1:6.filename = E:rac11204shareDATA4.vmdkscsi1:6.deviceType = plainDiskscsi1:8.present = TRUEscsi1:8.mode = independent-persistentscsi1:8.filena

38、me = E:rac11204shareDATA5.vmdkscsi1:8.deviceType = plainDiskdisk.locking = falsediskLib.dataCacheMaxSize = 0diskLib.dataCacheMaxReadAheadSize = 0diskLib.DataCacheMinReadAheadSize = 0diskLib.dataCachePageSize = 4096diskLib.maxUnsyncedWrites = 02.11 变成udevfor i in b c d e f g h ;doecho KERNEL=sd*, BUS

39、=scsi, PROGRAM=/sbin/scsi_id -whitelisted -replace-whitespace -device=/dev/$name, RESULT=/sbin/scsi_id -whitelisted -replace-whitespace -device=/dev/sd$i, NAME=asm-disk$i, OWNER=grid, GROUP=asmadmin, MODE=0660 /etc/udev/rules.d/99-oracle-asmdevices.rulesdone启动udev/sbin/start_udev这里可以看到盘ls -ltr /dev/

40、*asm*2.12 复制新主机1.root进入linux，删除/etc/udev/rules.d/70-persistent-net.rules文件，2.重启3.参考70-persistent-net.rules中的内容，编辑/etc/sysconfig/network-scripts/ifcfg-eth0/etc/sysconfig/network-scripts/ifcfg-eth1vi /etc/sysconfig/network-scripts/ifcfg-eth0DEVICE=eth0ONBOOT=yesBOOTPROTO=staticIPADDR=1NETM

41、ASK=HWADDR=00:50:56:2B:FB:F6vi /etc/sysconfig/network-scripts/ifcfg-eth1DEVICE=eth1ONBOOT=yesBOOTPROTO=staticIPADDR=1NETMASK=HWADDR=00:0C:29:D6:E6:F34.重启网卡service network restartor/etc/init.d/network restart3 grid的安装上传p13390677_112040_Linux-x86-64_3of7.zipunzip解

42、压p13390677_112040_Linux-x86-64_3of7.zip运行./runInstaller3.1 安装截图3.2 安装过程中执行2个脚本4 Databas的安装上传p13390677_112040_Linux-x86-64_1of7.zip，p13390677_112040_Linux-x86-64_2of7.zip解压p13390677_112040_Linux-x86-64_1of7.zip，p13390677_112040_Linux-x86-64_2of7.zip运行./runInstaller4.1 安装截图4.2 安装过程中执行1个脚本5 手工建库5.1 在ra

43、c001 建立口令文件su - oraclecd $ORACLE_HOME/dbsoraclerac001 dbs$ $ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=abcd1234 entries=3 force=y5.2 建立pfile 文件,修改initORCL1.ora后， 如下su - oraclecd $ORACLE_HOME/dbsoraclerac001 dbs$ cat initORCL1.ora*.audit_file_dest=/u01/app/oracle/diag/rdbm

44、s/ORCL/adump*.cluster_database=false*.compatible=.0*.control_files=+DATA/ORCL/controlfile/control01.ctl*.core_dump_dest=/u01/app/oracle/diag/rdbms/ORCL/cdump*.db_block_size=8192*.db_create_file_dest=+DATA*.db_domain=*.db_file_multiblock_read_count=128*.db_name=ORCL*.db_recovery_file_dest=+DA

45、TA*.db_recovery_file_dest_size=2147483648*.dispatchers=(PROTOCOL=TCP) (SERVICE=ORCLXDB)ORCL1.instance_number=1*.job_queue_processes=10ORCL1.log_archive_dest_1=location=+DATA*.log_archive_format=arch_%t_%s_%r.log*.open_cursors=300*.pga_aggregate_target=200M*.processes=150*.remote_listener=rac01scan:1

46、521*.remote_login_passwordfile=exclusive*.sga_max_size=500M*.sga_target=0ORCL1.thread=1*.db_cache_size=117440512*.java_pool_size=117440512*.large_pool_size=117440512*.shared_pool_size=247463936*.streams_pool_size=117440512*.undo_management=AUTOORCL1.undo_tablespace=UNDOTBS15.3 创建目录mkdir -p /u01/app/

47、oracle/diag/rdbms/ORCL/cdumpmkdir -p /u01/app/oracle/diag/rdbms/ORCL/adump5.4 instance启动数据库到nomountstartup nomount pfile=initORCL1.ora;create spfile from pfile=initORCL1.ora;shutdown abortstartup nomount 5.5 建库，建库脚本如下：CREATE DATABASE ORCLuser sys identified by abcd1234user system identified by abcd1

48、234controlfile reuseLOGFILE GROUP 1 (+DATA/ORCL/ONLINELOG/redo01a.log) SIZE 10M REUSE,GROUP 2 (+DATA/ORCL/ONLINELOG/redo02a.log) SIZE 10M REUSEMAXLOGFILES 5MAXLOGMEMBERS 5MAXLOGHISTORY 1MAXDATAFILES 100MAXINSTANCES 1CHARACTER SET ZHS16GBKNATIONAL CHARACTER SET AL16UTF16DATAFILE +DATA/ORCL/DATAFILE/s

49、ystem01.dbf SIZE 325M AUTOEXTEND off SYSAUX DATAFILE +DATA/ORCL/DATAFILE/sysaux01.dbf SIZE 100M AUTOEXTEND off default tablespace users datafile +DATA/ORCL/DATAFILE/user01.dbf size 100M autoextend off default temporary tablespace temp tempfile +DATA/ORCL/DATAFILE/temp01.dbf size 100M autoextend off UNDO TABLESPACE undotbs1 DATAFILE +DATA/ORCL/DATAFILE/undotbs01.dbf SIZE 100M AUTOEXTEND off ;5.6 建立数据字典，运行以下数据字典的脚本co