合 Oracle rac安装报错 multiple user has uid 0
前言部分
导读和注意事项
各位技术爱好者,看完本文后,你可以掌握如下的技能,也可以学到一些其它你所不知道的知识,~O(∩_∩)O~:
① RAC安装类似如下错误的解决方案:
USERS WITH SAME UID
multiple user has uid 0
PROC-5: User does not have permission to perform a cluster registry operation on this key
add scan=ZFPRMDB-scan ... failed
FirstNode configuration failed at /oracle/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 9196.
相关参考文章链接
相关知识点扫盲
Rac安装中,最重要的一步是安装grid的时候执行root.sh脚本,这个可以成功,基本rac可以安装成功,安装rac之前可以使用runcluvfy.sh脚本来检查安装环境
--- GRID校验,这里的ORACLE_HOME指的是GRID_HOME
./runcluvfy.sh stage -pre crsinst -n all -verbose
$ORACLE_HOME/bin/cluvfy stage -pre crsinst -n all -verbose
---------------------------------------重新执行root.sh脚本的2种方式,这里的ORACLE_HOME指的是GRID_HOME
--------------① 脚本方式
---执行失败,重新执行root.sh脚本
---$ORACLE_HOME/crs/install/rootcrs.pl -deconfig -force -verbose
--dd if=/dev/zero of=/dev/rhdiskN bs=1024k count=1024
--lquerypv -h /dev/rhdisk5
--$ORACLE_HOME/root.sh
--------------② 界面方式
---------------删除两节点crsconfig_params中的DATA1和磁盘
$ORACLE_HOME/crs/install/crsconfig_params
ASM_DISK_GROUP=DATA1
ASM_DISKS=/dev/rhdisk5
--root执行
$ORACLE_HOME/crs/install/rootcrs.pl -deconfig -force -verbose
-- GRID 执行
export DISPLAY=22.188.216.132:0.0
$ORACLE_HOME/crs/config/config.sh
故障分析及解决过程
故障环境介绍
项目 | source db |
---|---|
db 类型 | RAC |
db version | 11.2.0.3 |
db 存储 | ASM |
OS版本及kernel版本 | AIX 64位 6.1.0.0 |
故障发生现象及报错信息
USERS WITH SAME UID
multiple user has uid 0
PROC-5: User does not have permission to perform a cluster registry operation on this key
静默安装报错信息:
PRCR-1006 : Failed to add resource ora.scan1.vip for scan1
PRCR-1071 : Failed to register or update resource ora.scan1.vip
PROC-5: User does not have permission to perform a cluster registry operation on this key.
add scan=ZFPRMDB-scan ... failed
FirstNode configuration failed at /oracle/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 9196.
PRCR-1006 : Failed to add resource ora.net1.network for net1
PRCR-1071 : Failed to register or update resource ora.net1.network
PROC-5: User does not have permission to perform a cluster registry operation on this key.
add nodeapps -n zfprmdb1 -A ZFPRMDB1-vip/255.255.255.0/en0 on node=zfprmdb1 ... failed
Failed to add Nodeapps at /oracle/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 9190.
/oracle/app/11.2.0/grid/perl/bin/perl -I/oracle/app/11.2.0/grid/perl/lib -I/oracle/app/11.2.0/grid/crs/install /oracle/app/11.2.0/grid/crs/install/rootcrs.pl execution failed
[main] [ 2016-02-29 09:16:16.124 GMT+08:00 ] [ScanImpl.initialize:111] NEE message = PRCS-1025 : Could not find Single Client Access Name Virtual Internet Protocol(VIP) resources TYPE=ora.scan_vip.type
Exception in thread "main" java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
at java.util.ArrayList.RangeCheck(ArrayList.java:572)
at java.util.ArrayList.get(ArrayList.java:347)
at oracle.cluster.impl.scan.ScanImpl.getScanName(ScanImpl.java:235)
at oracle.sysman.assistants.util.hasi.HAUtils.getScanName(HAUtils.java:2416)
at oracle.sysman.assistants.util.hasi.HAUtils.getScanEZConnectString(HAUtils.java:2928)
at oracle.sysman.assistants.util.attributes.InitParamAttributes.configureRemoteListener(InitParamAttributes.java:2941)
at oracle.sysman.assistants.dbca.backend.Host.createOPSConfiguration(Host.java:1226)
at oracle.sysman.assistants.dbca.backend.SilentHost.performOperation(SilentHost.java:234)
at oracle.sysman.assistants.dbca.backend.Host.startOperation(Host.java:3613)
at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:119)