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 65536 3.修改登录配置文件
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 /u01 6.设置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 |
|