Oracle11gRAC在RHEL62(x8664)上成功安装.docx

Oracle 11gRAC实施文档1). Hardware RequirementsAll hardware Requirements is OK!2)You are free to change the IP addresses to suit your network, but remember to stay consistent with those adjustments throughout the rest of the article.Once the basic installation is complete, install the following packages whilst logged in as the root user. This includes the 64-bit and 32-bit versions of some packages.cd /media/GHOST/Packages#注意/media/GHOST/Packages为RHEL安装目录，根据实际情况进行调整。有些包需要从网上下载。rpm -Uvh binutils-2.*rpm -Uvh compat-libstdc+-33*rpm -Uvh elfutils-libelf-0.*rpm -Uvh elfutils-libelf-devel-*rpm -Uvh gcc-4.*rpm -Uvh gcc-c+-4.*rpm -Uvh glibc-2.*rpm -Uvh glibc-common-2.*rpm -Uvh glibc-devel-2.*rpm -Uvh glibc-headers-2.*rpm -Uvh ksh-2*rpm -Uvh libaio-0.*rpm -Uvh libaio-devel-0.*rpm -Uvh libgcc-4.*rpm -Uvh libstdc+-4.*yum install libstdc*rpm -Uvh libstdc+-devel-4.*rpm -Uvh make-3.*rpm -Uvh sysstat*rpm -Uvh unixODBC-2.*rpm -Uvh unixODBC-devel-2.*# Install the following package from the Oracle grid media.cd /home/oracle/grid/rpmrpm -Uvh cvuqdisk*3）1. Create OS groups using the command below. Enter these commands as the root user:#/usr/sbin/groupadd -g 501 oinstall#/usr/sbin/groupadd -g 502 dba#/usr/sbin/groupadd -g 504 asmadmin#/usr/sbin/groupadd -g 506 asmdba#/usr/sbin/groupadd -g 507 asmoper2. Create the users that will own the Oracle software using the commands:#/usr/sbin/useradd -u 502 -g oinstall -G dba,asmdba oracle#/usr/sbin/useradd -u 503 -g oinstall -G asmadmin,asmdba,asmopergrid#注意501为编号，根据实际情况而定3. Set the password for the oracle account using the following command. Replace password with your own password.#注意，下面是修改密码passwd oraclepasswd grid3) If you are not using DNS, the /etc/hosts file must contain the following information. localhost.localdomain localhost# Public GIS-A.localdomain GIS-A GIS-B.localdomain GIS-B# Private GIS-A-priv.localdomain GIS-A-priv GIS-B-priv.localdomain GIS-B-priv# Virtual9 rac1-vip.localdomain rac1-vip0 rac2-vip.localdomain rac2-vip# SCAN3 rac-scan.localdomain rac-scan#注意，这些IP根据实际情况而定，GIS-A为服务器名称4)Add or amend the following lines to the /etc/sysctl.conf file.fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 1054504960kernel.shmmni = 4096# semaphores: semmsl, semmns, semopm, semmnikernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default=262144net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=1048586Run the following command to change the current kernel parameters./sbin/sysctl -pAdd the following lines to the /etc/security/limits.conf file.oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536Add the following lines to the /etc/pam.d/login file, if it does not already exist.session required pam_limits.soDisable secure linux by editing the /etc/selinux/config file, making sure the SELINUX flag is set as follows.SELINUX=disabledAlternatively, this alteration can be done using the GUI tool (System Administration Security Level and Firewall). Click on the SELinux tab and disable the feature.Either configure NTP, or make sure it is not configured so the Oracle Cluster Time Synchronization Service (ctssd) can synchronize the times of the RAC nodes. In this case we will deconfigure NTP.# service ntpd stopShutting down ntpd: OK # chkconfig ntpd off# mv /etc/ntp.conf /etc/ntp.conf.orig# rm /var/run/ntpd.pidIf you are using NTP, you must add the -x option into the following line in the /etc/sysconfig/ntpd file.OPTIONS=-x -u ntp:ntp -p /var/run/ntpd.pidThen restart NTP.# service ntpd restartCreate the directories in which the Oracle software will be installed.mkdir -p /u01/app/11.2.0/gridmkdir -p /u01/app/oracle/product/11.2.0/db_1chown -R oracle:oinstall /u01chmod -R 775 /u01/Login as the oracle user and add the following lines at the end of the .bash_profile file.#此文件的文件格式很重要，最好copy其他服务器文件，进行修改。下面为grid用户下的.bash_profile。ORACLE_SID根据实际情况而定# .bash_profile# Get the aliases and functionsif -f /.bashrc ; then. /.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/binexport PATHalias ls=ls -FA ORACLE_SID=+ASM2; export ORACLE_SID ORACLE_BASE=/u01/app/grid; export ORACLE_BASE ORACLE_HOME=/u01/app/11.2.0/grid; export ORACLE_HOME ORACLE_PATH=/u01/app/oracle/common/oracle/sql; export ORACLE_PATH ORACLE_TERM=xterm; export ORACLE_TERM NLS_DATE_FORMAT=DD-MON-YYYY HH24:MI:SS; export NLS_DATE_FORMAT TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11 NLS_LANG=AMERICAN_AMERICA.ZHS16GBK; export NLS_LANG PATH=.:$JAVA_HOME/bin:$PATH:$HOME/bin:$ORACLE_HOME/bin PATH=$PATH:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin PATH=$PATH:/u01/app/common/oracle/bin export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/oracm/lib LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/lib:/usr/lib:/usr/local/lib export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE CLASSPATH=$CLASSPATH:$ORACLE_HOME/jlib CLASSPATH=$CLASSPATH:$ORACLE_HOME/rdbms/jlib CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib export CLASSPATH THREADS_FLAG=native; export THREADS_FLAG export TEMP=/tmp export TMPDIR=/tmp umask 022 alias sqlplus=rlwrap sqlplus alias rman=rlwrap rman alias ggsci=rlwrap ggsci alias logdump=rlwrap logdump alias asmcmd=rlwrap asmcmd alias base=cd $ORACLE_BASE alias home=cd $ORACLE_HOME用UDEV挂接存储如果用下面的这种方式编辑规则文件，udev设置是可以出来的编辑more 99-oracle-asmdevices.rules文件注意：如果root下执行scsi_id -whitelisted -replace-whitespace -device=/dev/emcpowera得到的编码跟360060160308135004e1a0a4d8cade311一致表示格式正确。此文件格式很重要，最好从其他服务器上copy，修改KERNEL=emcpowera, SUBSYSTEM=block, PROGRAM=scsi_id -whitelisted -replace-whitespace -device=/dev/emcpowera, RESULT=360060160308135004e1a0a4d8cade311, NAME=asm-1, OWNER=grid, GROUP=asmadmin, MODE=0660rootchnap-itd64 rules.d# /sbin/start_udev正在启动 udev：确定rootchnap-itd64 rules.d# ls -l /dev/asm-1*brw-rw- 1 grid asmadmin 8, 17 1月 28 20:00 /dev/asm-1brw-rw- 1 grid asmadmin 8, 17 1月 28 20:00 /dev/asm-2brw-rw- 1 grid asmadmin 8, 17 1月 28 20:00 /dev/asm-4Install the Grid InfrastructureMake sure the rac1 and rac2 virtual machines are started, then login to rac1 as the oracle user and start the Oracle installer.注意：现在root下执行xhost +再到grid用户执行下面程序./runInstallerSelect the Install and Configure Grid Infrastructure for a Cluster option, then click the Next button.注意：安装时请参考使用UDEV在Oracle Linux 6上安装Oracle 11g RAC() (四) - Zhong Weicheng Study Notes - 博客频道 - CSDN.NET.htm和使用UDEV在Oracle Linux 6上安装Oracle 11g RAC() (五) - Zhong Weicheng Study Notes - 博客频道 - CSDN.NET.htm。Skip software updatesInstall any Configure Oracle Grid Infrastructure for a ClusterAdvanced Installationadd Simplified Chine