《Oracle11gRAC在RHEL62(x8664)上成功安装.docx》由会员分享，可在线阅读，更多相关《Oracle11gRAC在RHEL62(x8664)上成功安装.docx（34页珍藏版）》请在三一办公上搜索。
1、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
2、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
3、.*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 -U
4、vh 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/s
5、bin/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
6、为编号，根据实际情况而定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.127.0.0.1 localhost.localdomain localhost# Public172.
7、33.10.3 GIS-A.localdomain GIS-A172.33.10.4 GIS-B.localdomain GIS-B# Private172.32.50.3 GIS-A-priv.localdomain GIS-A-priv172.32.50.4 GIS-B-priv.localdomain GIS-B-priv# Virtual172.33.10.19 rac1-vip.localdomain rac1-vip172.33.10.20 rac2-vip.localdomain rac2-vip# SCAN172.33.10.23 rac-scan.localdomain ra
8、c-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_loc
9、al_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 2047ora
10、cle 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=dis
11、abledAlternatively, 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
12、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=-
13、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 f
14、ollowing 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
15、 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_FORM
16、AT 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/oracl
17、e/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/jl
18、ib 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
19、 $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, PROG
20、RAM=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 /de
21、v/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用户执行下面
22、程序./runInstallerSelect the Install and Configure Grid Infrastructure for a Cluster option, then click the Next button.注意：安装时请参考使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (四) - Zhong Weicheng Study Notes - 博客频道 - CSDN.NET.htm和使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (五) - Zhong Weicheng
23、 Study Notes - 博客频道 - CSDN.NET.htm。Skip software updatesInstall any Configure Oracle Grid Infrastructure for a ClusterAdvanced Installationadd Simplified Chinese不配置GNS,填写scan名称如果之前没有配置ssh用户等效,也可以在这里配置Remote binaries check succeeded指定用于Public网络和Private网络的网络接口。进行所需更改以与下表中各值保持一致配置ASM存储+CRSUse same pass
24、words for these accountsDo not use Intelligent Platform Management Interface (IPMI)ASM使用的是UDEV绑定设备,没有使用asmlib,忽略这个警告使用root用户在node1,node2上执行以下脚本,这里使用 one by one方式使用grid用户执行asmca,创建名为DATADG和FRADG的ASM磁盘组create安装数据前，要配置两个节点的监听，并启动使用oracle用户在 Oracle Real Application Clusters 中安装 Oracle Database softwareS
25、ikp Software UpdatesInstall database software onlyReal Application Clusters database installation如果之前没有配置oracle用户的ssh等效性,可以在这里配置,具体过程请看GI安装过程,这里不再演示add Simplified ChineseEnterprises Edition忽略DNS错误installssh node2使用root用户在node1,node2上执行root.shExit在任意node使用dbca创建集群化数据库选择Oracle Real Application Clusters database
