rac+CentOS48.docx

1、rac+CentOS48RAC安装： 1.创建虚拟机，创建目录rac1 ,rac2,sharedstorage用于放磁盘 创建rac1,创建虚拟机时磁盘15G，再增加一个网卡， ，创建第一块共享磁盘0.5G，ocr1.disk SCSI 1:0 创建第二块共享磁盘0.5G，ocr1.disk SCSI 1:1 创建第三块共享磁盘3G，ocr1.disk SCSI 1:2 创建第四块共享磁盘3G，ocr1.disk SCSI 1:3 创建第五块共享磁盘3G，ocr1.disk SCSI 1:4 创建第六块共享磁盘3G，ocr1.disk SCSI 1:52.安装linux 安装好linux后，退

2、出光盘,安装VMtool,VM-vmtool,双击vmware包 两个网卡的IP：172。31。0.111 172。31。1。111 # vmware-config-tools.pl 2 800*600 SecureCRT连接上： vi /etc/inittab id : 3 :wq 重新启动 init 6 安装ORACLE之前，要安装RPM包 sysstat.rpm包 rpm -qa | grep gcc rpm -ivh openmotif21-2.1.3.rpm vi /etc/hosts 增加以下信息： #public 172.30.0.77 rac1 172.30.0.78 rac2

3、 #private 172.30.1.77 rac1- rac1-priv 172.30.1.78 rac2- rac2-priv #Virtual 172.30.2.77 rac1- rac1-vip 172.30.2.79 rac2- rac2-vip vi /etc/sysctl.conf 增加内核参数kernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096# semaphores: semmsl, semmns, semopm, semmnikernel.sem = 250 32000 100 128fs

4、.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000 /sbin/sysctl -p 内核参数生效 vi /etc/security /limits.conf* soft nproc 2047* hard nproc 16384* soft nofile 1024* hard nofile 65536 vi /etc/pam.d/login ession required /lib/security/pam_limits.so cat /etc/selinux/config SELINUX=disable service ipta

5、bles status 防火墙是否关闭 vi /etc/modprobe.conf options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180 modprobe -v hangcheck-timergroupadd oinstallgroupadd dbauseradd -g oinstall G dba oraclepasswd oraclemkdir -p /oracle/product/10.2.0/crsmkdir -p /oracle/product/10.2.0/asmmkdir -p /oracle/product

6、/10.2.0/db_1chown -R oracle:oinstall /oraclels -lrsh onrlogin onservice xinetd reloadsu - oraclevi .bash_profile #Oracle Settings export PS1= /bin/hostname s - export EDITOR=vi export TMP=/tmp export TMPDID=$TMP export ORACLE_BASE=/oracle exportASM_HOME=/oracle/product/10.2.0/asm exportORACLE_CRS_HO

7、ME=/oracle/product/10.2.0/crs export ORACLE_HOME=/oracle/product/10.2.0/db_1 exportORACLE_SID=orcl1 exportPATH=$ORACLE_HOEM/bin:$ORACLE_CRS_HOME/bin:/usr/sbin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/bin:/lib:/usr/slib:$PATH export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jli

8、b alias sqlplus=rlwrap sqlplus alias rman=rlwrap rman stty erase H umask 022 if $USER = oracle ; then if $SHELL = /bin/ksh ; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi source .bash_profile 关机: su - init 0 修改虚拟机的vmx文件 disk.locking = FALSE diskLib.dataCacheMaxSize = 0 scs

9、i1.sharedBus = virtual scsi1:0.mode的下面一行 scsi1:0.deviceType = disk scsi1:1.deviceType = disk scsi1:2.deviceType = disk scsi1:3.deviceType = disk scsi1:4.deviceType = disk scsi1:5.deviceType = disk rac1目录下的内容，复制一份到rac2目录，然后同时打开rac1,rac2 对rac2进行适当 的修改,网卡,机器名配置时间服务器rac1# chkconfig ntpd onservice ntpd s

10、tatusservice ntpd startrac2 启动xmanager passive export DISPLAY=172.30.0.32:0.0 system-config-date 设置rac1为时间服务器 Enable NetWork Time Protocol 先上 server 172.30.0.77 vi /etc/rc.local while 1 ; do ntpdate rac1 1/dev/null 2&1; sleep 2; done &rac1 建立ssh有效性su - oracle mkdir /.ssh chmod 700 /.ssh ssh-keygen -

11、t rsassh-keygen -t dsarac2su - oracle mkdir /.ssh chmod 700 /.ssh ssh-keygen -t rsassh-keygen -t dsarac1 cat /.ssh/id_rsa.pub /.ssh/authorized_keys cat /.ssh/id_dsa.pub /.ssh/authorized_keys ssh rac2 cat /.ssh/id_rsa.pub /.ssh/authorized_keysssh rac2 cat /.ssh/id_dsa.pub /.ssh/authorized_keys scp /.

12、ssh/authorized_keys rac2:/.ssh/authorized_keys测试SSH等效性:ssh rac1 datessh rac2 datessh datessh datessh rac1-priv datessh rac2-priv datessh rac1- datessh rac2- daterac2ssh rac1 datessh rac2 datessh ssh ssh rac1-priv datessh rac2-priv datessh rac1- datessh rac2- daterac2ntpd关闭su -service ntpd statusserv

13、ice ntpd stop -*备份*rac1su - oracleexec /usr/bin/ssh-agent $SHELL/usr/bin/ssh-addrac2 su - oracleexec /usr/bin/ssh-agent $SHELL/usr/bin/ssh-addrac1配置裸设备服务,oracle用户要有权限修改裸设备配置文件vi /etc/sysconfig/rawdevices#两个512M的磁盘 /dev/raw/raw1 /dev/sdb1 /dev/raw/raw2 /dev/sdc1:wq配置权限vi /etc/udev/permissions.d/50-ud

14、ev.permisssions#raw devices#raw /*:root.:disk:0660 raw/*:oracle:dba:0660:wqchkconfig -list rawdevicesservice rawdevices restart检查权限oracle,dba cd /dev/rawllrac2配置裸设备服务,oracle用户要有权限修改裸设备配置文件vi /etc/sysconfig/rawdevices /dev/raw/raw1 /dev/sdb1 /dev/raw/raw2 /dev/sdc1:wq配置权限vi /etc/udev/permissions.d/50

15、-udev.permisssions#raw devices#raw /*:root.:disk:0660 raw /*:oracle:dba:0660:wqchkconfig -list rawdevicesservice rawdevices restart检查裸设备的权限cd /dev/rawll创建ASM磁盘:两个节点都安装RPM三个ASM包查看Linux内核uname -rm下载ASM三个包cd /asmrpmrpm -ivh *.rpmrpm -qa | grep oacleasm两个节点都安装好ASM包rac1 创建ASM磁盘 /etc/init.d/oracleasm conf

16、igure oracle dba y y检测ASM驱动是否加载l1.lsmod | grep asm 2.cat /proc/filesystems3.df -ha创建ASM磁盘:/etc/init.d/oracleasm createdisk VOL1 /dev/sdd1/etc/init.d/oracleasm createdisk VOL2 /dev/sde1/etc/init.d/oracleasm createdisk VOL3 /dev/sdf1/etc/init.d/oracleasm createdisk VOL4 /dev/sdg1检查创建是否成功cd /dev/oracle

17、asm/disksll /etc/init.d/oracleasm listdisks /dtc/init.d/oracleasm querydisk VOL1 rac2创建ASM磁盘 /etc/init.d/oracleasm scandisks /etc/init.d/oracleasm listdisks 配置ASM磁盘 /etc/init.d/oracleasm configure oracle dba y y /etc/init.d/oracleasm scandisks /etc/init.d/oracleasm listdisks-*备份 *6.下载安装oracle cluste

18、rware chown -R oracle:oinstall clusterware chown -R oracle:oinstall database rac1 chmod -R 775 /oracle rac2 cd /oracle ls -l chmod -R 775 /oracle rac1 安装clusterware su - oracle export DISPLAY=172.30.0.32:0.0 exec /usr/bin/ssh-agent $SHELL /usr/bin/ssh-add cd /oracle/clusterware 检测环境是否可以安装clusterware

19、 /oracle/clusterware/cluvfy/runcluvfy.sh stage -pre crsinst -n rac1,rac2 cd /oracle/clusterware ./runInstaller path :/oracle/ ./crs Specify Cluster Configuration add rac2- rac2- Specify Network Interface Usage eth0 public OCR: extend : /dev/raw/raw1 Voting Disk Congfiguration extend : /dev/raw/raw2

20、以root用户:执行两个脚本: /oracle/oraInventory/orainstRoot.sh/oracle/product/10.2.0/crs/root.sh 如果报错: 解决eth0 is not public . export DISPLAY=172.30.0.32:0.0 /oracle/product/10.2.0/crs/bin/vipca eth0 rac1 : rac1- rac2 : rac2- rac1: 安装好后: crs_stat -t rac2 crs_stat -t-*备份*rac1 7.单独安装ASM ASM管理多实例 便于升级 cd /oracle/d

21、atabase export DISPLAY=172.30.0.32:0.0 ./runInstaller specify home details OraASM10g_home1 /oracle/product/10.2.0/asm Cluster Installation rac1 rac2Select Configuration Option configure ASMConfigure automatic storage managerment data normal 选择orcl:vol1 orcl:vol2 执行脚本：完成安装安装数据库软件： ./runInstaller 选 In

22、stall database software only 执行脚本:安装完成rac1:配置:listener netca crs_stat -t 查看listenerrac2 crs_stat -t创建另一个ASM磁盘组 dbca configure ASMselect rac1 rac2create newcreate disk group RECOVERY normal orcl:vol3 orcl:vol4 创建数据库dbcaselect rac1 rac2 gobal service name:test1available asm datause oracle-manage files

23、不创建 database service创建好后检查状态rac1crs_stat -tcrs_stat -t -vrac2crs_stat -t crs_stat -t -v rac1stat nnodeapps -n rac1stat nnodeapps -n rac2srvctl status asm -n rac1srvctl status asm -n rac2srvctl status database -d firstraccrsctl check crssqlplus /nologconn /as sysdbaselect instance_name,host_name ,arc

24、hiver,thread# ,status from gv$instance;exit;sqlplus system/oracletestrac1sqlplus system/oracletestrac2sqlplus system/oracletestrac export ORACLE_SID=testrac1sqlplus /as sysdbashow sgaselect file_name from dba_datafiles;exitexport ORACLE_SID=+ASM1sqlplus / as sysdbashow sga启动数据库$srvctl start nodeapps

25、 -n rac1$srvctl start nodeapps -n rac2$srvctl start asm -n rac1$srvctl start asm -n rac2$srvctl start instance -d racdb -i racdb1$srvctl start instance -d racdb -i racdb2可以用以下方动启动crs:$/etc/init.d/init.cssd start$/etc/init.d/init.crs startrac1- ./init.crs start Startup will be queued to init within 90 seconds. rac1- ./init.cssd start Startup will be queued to init within 90