ORACLE RAC安装过程碰到问题处理汇总

来源：互联网发布：格里芬16赛季数据编辑：程序博客网时间：2024/06/01 07:47

安装oracle rac双机过程磁到问题，记录汇总
1.系统环境
VBOX虚拟机
Redhat 6.3
Oracle GI 11.2.0.4.0
Oracle DB 11.2.0.4.0

2.fdisk -l 不显示磁盘
在node2上，挂载的asmdisk并没有显示，而是node1上正常显示
查看/proc/partitions是有记录信息的,而通过fdisk -l看不到

cat /proc/partitions major minor  #blocks  name   8        0   52428800 sda   8        1     512000 sda1   8        2   51915776 sda2   8       16    1048576 sdb   8       32    1048576 sdc   8       48    1048576 sdd   8       64    8388608 sde   8       80    8388608 sdf   8       96    8388608 sdg 253        0   49389568 dm-0 253        1    2523136 dm-1

处理：
start_udev 启动udev模块

3.libcap.so.1: cannot open shared object file

#日志记录：Creating /etc/oratab file...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Using configuration parameter file: /app/grid/11.2.0/crs/install/crsconfig_paramsCreating trace directoryUser ignored Prerequisites during installationInstalling Trace File AnalyzerFailed to create keys in the OLR, rc = 127, Message:  /app/grid/11.2.0/bin/clscfg.bin: error while loading shared libraries: libcap.so.1: cannot open shared object file: No such file or directory Failed to create keys in the OLR at /app/grid/11.2.0/crs/install/crsconfig_lib.pm line 7660./app/grid/11.2.0/perl/bin/perl -I/app/grid/11.2.0/perl/lib -I/app/grid/11.2.0/crs/install /app/grid/11.2.0/crs/install/rootcrs.pl execution failed

处理：

rpm -ivh compat-libcap1-1.10-1.x86_64.rpm执行root的界面先不要退出，安装完这个包之后，再次执行root.sh就可以了

4.关于ORA_NLS10
安装过程中报错

an internal error ocurred within cluster verification framework uable to obtain network interface list from Oracle Clusterware PRCT-1011：Failed to run"oifcfg".Detailed error:null

处理：
unset环境变量ORA_NLS10
export ORA_NLS10=$ORACLE_HOME/nls/data 注释掉这句

5.PRVF-7617 TCP connectivity check failed for subnet
两个节点之间的防火墙没有关闭
service iptables save
service iptables stop
chkconfig iptables off

6.清空使用过的ASM磁盘组的使用过的信息
如果被用于ASM的磁盘以前曾经被使用，现在使用时提示是备用，无法使用时，可以清空磁盘头

dd if=/dev/zero of=/dev/asm-b_crs bs=512 count=10dd if=/dev/zero of=/dev/asm-c_crs bs=512 count=10dd if=/dev/zero of=/dev/asm-d_crs bs=512 count=10

7.rpm包冲突
[root@emisdba Packages]# rpm -ivh pdksh-5.2.14-30.x86_64.rpm
warning: pdksh-5.2.14-30.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 73307de6: NOKEY
error: Failed dependencies:
pdksh conflicts with ksh-20100621-16.el6.x86_64

rpm包冲突，删除包ksh-20100621-16.el6.x86_64 ，安装oracle需要的包 pdksh-5.2.14-30.x86_64.rpm

8.dbca无法找到asm磁盘组，而导致失败
oracle用户没有加入asmdba权限组
id oralce
uid=501(oracle) gid=5001(oinstall) 组=5001(oinstall),5002(dba),5003(oper),5006(asmdba)
usermod -g oinstall -G dba,asmdba,oper oracle

GRID_HOME/bin 和 ORACLE_HOME/bin目录下，oracle文件权限错误
cd $ORACLE_HOME/bin
ls -l oracle
-rwsr-s–x 1 oracle asmadmin 239626689 9月 7 15:56 oracle 这个是正确的权限，当与这个不一致时，要修改成一致的
chmod +s oracle
注：执行chown -R 会修改这个文件的权限，导致无法正常发现磁盘组和正常启动数据库等问题

另外可以考虑的方面有：
asm磁盘组权限问题
asm group是否有mount
asm instance是否启动
asm 等资源是否在线等方面查看 crsctl stat res -t

0 0