安装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 by
Database Configuration Assistant when a database is created
Finished 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_params
Creating trace directory
User ignored Prerequisites during installation
Installing Trace File Analyzer
Failed 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=10
dd if=/dev/zero of=/dev/asm-c_crs bs=512 count=10
dd 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