齐天传txt:Redhat AS 5.0下配置Oracle 10g RAC

来源:百度文库 编辑:九乡新闻网 时间:2024/04/29 05:34:57
Redhat AS 5.0下配置Oracle 10g RAC   [ 日期:2007-09-03 ]   [ 来自:本站原创 ]
环境说明:
操作系统: Redhat AS 5.0 (kernel 2.6.18-8.e15xen)
数据库: Oracle 10g 10.2.0.1配置步骤:
1.调整系统内核参数
vi /etc/sysctl.conf
=====================================
kernel.shmall = 2097152
kernel.shmmax = 4294967296
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024    65000
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 262144
=====================================
然后执行/sbin/sysctl -p 生效2.设置oracle用户的shell限制
vi /etc/security/limits.conf
oracle               soft      nproc     2047
oracle               hard     nproc     16384
oracle               soft      nofile     1024
oracle               hard     nofile      655363.修改登录配置文件
vi /etc/pam.d/login
=====================================
session      required    /lib/security/pam_limits.so
vi /etc/profile
if [ \$USER = "oracle" ]; then
if [ \$SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
=====================================4.配置Hangcheck计时器
vi /etc/modprobe.conf
=====================================
options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180
=====================================
vi /etc/rc.local
=====================================
/sbin/modprobe hangcheck-timer
=====================================5.创建用户和安装目录(在集群主机上的用户ID和组ID必须相同)
mkdir -p /u01/app/oracle/product/10.2.0/db_1
mkdir -p /u01/app/oracle/product/10.2.0/crs
groupadd -g 115 dba
groupadd -g 125 oinstall
useradd -m -u 175 -g oinstall -G dba oracle
passwd oracle
chown -R oracle:oinstall /u01
chmod -R 775 /u016.设置Oracle用户的环境变量
su - oracle
vi .bash_profile
=====================================
# User specific environment and startup programs
umask 022
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORA_CRS_HOME=$ORACLE_BASE/product/10.2.0/crs
export ORACLE_PATH=$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin
export ORACLE_SID=qzpoais
export NLS_LANG=AMERICAN_AMERICA.UTF8
export NLS_DATE_FORMAT="mm/dd/yyyy hh24:mi:ss"
export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin
export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin
export ORACLE_TERM=xterm
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$ORACLE_HOME/nls/data
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$ORACLE_HOME/nls/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export CLASSPATH=$ORACLE_HOME/JRE
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export THREADS_FLAG=native
export TEMP=/tmp
export TMPDIR=/tmp
====================================
然后执行source .bash_profile 生效7.编辑Hosts文件
vi /etc/hosts
====================================
10.133.129.181    OraclusterA
10.133.129.182    OraclusterB
10.133.129.183    OraclusterA-vip
10.133.129.184    OraclusterB-vip
10.10.10.1        OraclusterA-priv
10.10.10.2        OraclusterB-priv
====================================
备注:如果127.0.0.1记录所对应的名称有出现主机名则要去掉,如OraclusterA.localhost.localdomain 改为localhost.localdomain,否则在安装CRS的节点添加识别时会出错8.安装所需软件包
使用rpm -qa  XXX 查看是否已安装
以下为所需软件包:
make                            系统默认安装
binutils                          系统默认安装
gcc                               系统默认安装
compat-db                      cd3中
compat-gcc                     cd2中
compat-gcc-c++              cd2中
compat-libstdc++            系统默认安装
compat-libstdc++-deve    系统默认安装
openmotif21                   cd2中
setarch-1.3-1                  系统默认安装
libxp
备注:RHEL5不同于RHEL4,默认没有安装libxp软件包,直接导致openmotif无法安装(依赖关系),并在安装时提示:/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory ,必须到光盘中找到对应的软件包并安装,详见:metalink Note:443617.1