资源描述
Oracle 11gRAC实施文档
1). Hardware Requirements
All 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/rpm
rpm -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 asmoper
2. 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,asmoper grid
#注意501为编号,根据实际情况而定
3. Set the password for the oracle account using the following command. Replace password with your own password.
#注意,下面是修改密码
passwd oracle
passwd grid
3) If you are not using DNS, the "/etc/hosts" file must contain the following information.
127.0.0.1 localhost.localdomain localhost
# Public
172.33.10.3 GIS-A.localdomain GIS-A
172.33.10.4 GIS-B.localdomain GIS-B
# Private
172.32.50.3 GIS-A-priv.localdomain GIS-A-priv
172.32.50.4 GIS-B-priv.localdomain GIS-B-priv
# Virtual
172.33.10.19 rac1-vip.localdomain rac1-vip
172.33.10.20 rac2-vip.localdomain rac2-vip
# SCAN
172.33.10.23 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 = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 1054504960
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
Run the following command to change the current kernel parameters.
/sbin/sysctl -p
Add the following lines to the "/etc/security/limits.conf" file.
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
Add the following lines to the "/etc/pam.d/login" file, if it does not already exist.
Disable secure linux by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.
SELINUX=disabled
Alternatively, 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 stop
Shutting down ntpd: [ OK ]
# chkconfig ntpd off
If 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.pid"
Then restart NTP.
# service ntpd restart
Create the directories in which the Oracle software will be installed.
chown -R oracle:oinstall /u01
chmod -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 functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
alias 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得到的编码跟一致表示格式正确。此文件格式很重要,最好从其他效劳器上copy,修改
[root@chnap-itd64 rules.d]# /sbin/start_udev
正在启动 udev:[确定]
[root@chnap-itd64 rules.d]# ls -l /dev/asm-1*
brw-rw---- 1 grid asmadmin 8, 17 1月 28 20:00 /dev/asm-1
brw-rw---- 1 grid asmadmin 8, 17 1月 28 20:00 /dev/asm-2
brw-rw---- 1 grid asmadmin 8, 17 1月 28 20:00 /dev/asm-4
Install the Grid Infrastructure
Make 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用户执行下面程序
./runInstaller
Select the "Install and Configure Grid Infrastructure for a Cluster" option, then click the "Next" button.
。
Skip software updates
Install any Configure Oracle Grid Infrastructure for a Cluster
Advanced Installation
add Simplified Chinese
不配置GNS,填写scan名称
如果之前没有配置ssh用户等效,也可以在这里配置
Remote binaries check succeeded
指定用于Public网络和Private网络的网络接口。进行所需更改以与下表中各值保持一致
配置ASM存储
+CRS
Use same passwords for these accounts
Do 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 software
Sikp Software Updates
Install database software only
Real Application Clusters database installation
如果之前没有配置oracle用户的ssh等效性,可以在这里配置,具体过程请看GI安装过程,这里不再演示
add Simplified Chinese
Enterprises Edition
忽略DNS错误
install
ssh node2
Exit
在任意node使用dbca创立集群化数据库
选择 Oracle Real Application Clusters database
展开阅读全文