齐天传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
环境说明:
操作系统: 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
Redhat AS 5.0下配置Oracle 10g RAC
使用 CRS 在同一集群上配置 Oracle9i RAC 和 Oracle RAC 10g
Oracle 10g & ASM Install For Redhat Enterprise Linux AS 4
配置虚拟机 _Vmware+Linux+Oracle 10G RAC全程详细图解
Redhat RHEL AS3 下安装 Oracle DB 10g 中文乱码问题的解决
Oracle 10g r2 rac for aix 6.1
RHEL?AS?5?X86_64如何卸载oracle?10g
Vmware+Linux+Oracle 10G RAC全程详细图解_实验准备
在 Linux 和 iSCSI 上构建您自己的 Oracle RAC 10g 第 2 版集...
新建虚拟机_Vmware+Linux+Oracle 10G RAC全程详细图解
Redhat Linux9下安装DNS配置文档
AIX5.3在使用HACMP安装ORACLE RAC 10G时的错误解决 集中讨论37
RedHat Linux9.0安装和配置|服务器技术g
Windows下安装ORACLE 10g操作图解2
AS4 下安装Oracle 10g(ASM & RAW)
10g rac 归档 以及备份测试
RedHat Linux 9 下远程桌面的安装与配置
oracle 10g for HP Itanium 11.31 raw 安装配置文档 - ...
oracle 10g table shrink
Windows下虚拟ASM磁盘搭建基于ASM的Oracle 10g数据库系统
oracle 9i 和oracle 10g 和oracle 11g有什么区别
Redhat DNS Bind配置详解
redhat5.5 安装 oracle 10g - Oracle Linux Web - ...
十步让你成为Oracle 10g DBA - Oracle数据库管理