Oracle rac安装报错 multiple user has uid 0

0    63    1

Tags:

👉 本文共约4942个字,系统预计阅读时间或需19分钟。

前言部分

导读和注意事项

各位技术爱好者,看完本文后,你可以掌握如下的技能,也可以学到一些其它你所不知道的知识,~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 version11.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)

at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:180)

使用图形界面安装报错:

Oracle rac安装报错 multiple user has uid 0

Oracle rac安装报错 multiple user has uid 0

故障分析及解决过程

先查询了一下metalink上的文章,找到了一篇Errors PRCR-1006 PRCR-1071 PROC-5 reported during GI installation as multiple user has uid 0 (文档 ID 2012626.1),应该就是我的问题了,按照文章的介绍,删除了多余的用户,重新执行root.sh就可以了。

原因:有和root用户一样的uid用户,删除该用户,解决过程如下:

[ZFXXX2:root]:/>more /etc/passwd

root:!:0:0:672/F/*BOCSUP//BOC System Super ID:/:/usr/bin/ksh

daemon:!:1:1:672/S/*BOCAIX//BOC AIX Linux system build in ID:/etc:

bin:!:2:2:672/S/*BOCAIX//BOC AIX Linux system build in ID:/bin:

本人提供Oracle、MySQL、PG等数据库的培训和考证业务,私聊QQ646634621或微信db_bao,谢谢!

sys:!:3:3:672/S/*BOCAIX//BOC AIX Linux system build in ID:/usr/sys:

adm:!:4:4:672/S/*BOCAIX//BOC AIX Linux system build in ID:/var/adm:

uucp:!:5:5:672/S/*BOCAIX//BOC AIX Linux system build in ID:/usr/lib/uucp:

guest:!:100:100:672/S/*BOCAIX//BOC AIX Linux system build in ID:/home/guest:

nobody:!:4294967294:4294967294:672/S/*BOCAIX//BOC AIX Linux system build in ID:/:

lpd:!:9:4294967294:672/S/*BOCAIX//BOC AIX Linux system build in ID:/:

lp:*:11:11:672/S/*BOCAIX//BOC AIX Linux system build in ID:/var/spool/lp:/bin/false

invscout:*:6:12:672/S/*BOCAIX//BOC AIX Linux system build in ID:/var/adm/invscout:/usr/bin/ksh

snapp:*:200:13:672/S/*BOCAIX//BOC AIX Linux system build in ID:/usr/sbin/snapp:/usr/sbin/snappd

ipsec:*:201:1:672/S/*BOCAIX//BOC AIX Linux system build in ID:/etc/ipsec:/usr/bin/ksh

nuucp:*:7:5:672/S/*BOCAIX//BOC AIX Linux system build in ID:/var/spool/uucppublic:/usr/sbin/uucp/uucico

pconsole:*:8:0:672/S/*BOCAIX//BOC AIX Linux system build in ID:/var/adm/pconsole:/usr/bin/ksh

esaadmin:*:10:0:672/S/*BOCAIX//BOC AIX Linux system build in ID:/var/esa:/usr/bin/ksh

sshd:*:202:201:672/S/*BOCAIX//BOC AIX Linux system build in ID:/var/empty:/usr/bin/ksh

prmwas:!:203:202:672/C//BOC/ - app user ID:/home/prmwas:/usr/bin/ksh

mon:*:301:1::/home/mon:/usr/bin/ksh

pwd_user:!:0:0::/home/pwd_user:/usr/bin/ksh

sysoper:!:1365:1::/home/sysoper:/usr/bin/ksh

grid:!:1025:1024::/home/grid:/usr/bin/ksh

oracle:!:1024:1024::/oracle:/usr/bin/ksh

[ZFXXX2:root]:/>lsuser ALL|grep id=0

root id=0 pgrp=system groups=system,bin,sys,security,cron,audit,lp,tivlogs home=/ shell=/usr/bin/ksh gecos=672/F/*BOCSUP//BOC System Super ID auditclasses=general login=true su=false rlogin=false daemon=true admin=true sugroups=sysadm admgroups=asmoper,asmdba,asmadmin,dba,was tpath=nosak ttys=ALL expires=0 auth1=SYSTEM auth2=NONE umask=27 registry=files SYSTEM=compat logintimes= loginretries=8 pwdwarntime=0 account_locked=false minage=0 maxage=4 maxexpired=-1 minalpha=1 minloweralpha=0 minupperalpha=0 minother=1 mindigit=0 minspecialchar=0 mindiff=6 maxrepeats=2 minlen=8 histexpire=40 histsize=8 pwdchecks= dictionlist= default_roles= fsize=-1 cpu=-1 data=-1 stack=-1 core=-1 rss=-1 nofiles=-1 fsize_hard=-1 cpu_hard=-1 data_hard=-1 stack_hard=-1 core_hard=-1 rss_hard=-1 nofiles_hard=-1 time_last_login=1456711975 time_last_unsuccessful_login=1456469618 tty_last_login=/dev/pts/0 tty_last_unsuccessful_login=/dev/vty0 host_last_login=22.188.216.132 host_last_unsuccessful_login=ZFXXX2 unsuccessful_login_count=0 roles=

pwd_user id=0 pgrp=system groups=system,staff home=/home/pwd_user shell=/usr/bin/ksh auditclasses=Priv,KeyFile login=true su=true rlogin=true daemon=true admin=false sugroups=ALL admgroups= tpath=nosak ttys=ALL expires=0 auth1=SYSTEM auth2=NONE umask=27 registry=files SYSTEM=compat logintimes= loginretries=8 pwdwarntime=0 account_locked=false minage=0 maxage=4 maxexpired=-1 minalpha=1 minloweralpha=0 minupperalpha=0 minother=1 mindigit=0 minspecialchar=0 mindiff=6 maxrepeats=2 minlen=8 histexpire=40 histsize=8 pwdchecks= dictionlist= default_roles= fsize=-1 cpu=-1 data=-1 stack=-1 core=-1 rss=-1 nofiles=-1 time_last_login=1434012632 tty_last_login=/dev/pts/0 host_last_login=21.122.132.175 unsuccessful_login_count=0 roles=

[ZFXXX2:root]:/>rmuser pwd_user

[ZFXXX2:root]:/>lsuser ALL|grep id=0

root id=0 pgrp=system groups=system,bin,sys,security,cron,audit,lp,tivlogs home=/ shell=/usr/bin/ksh gecos=672/F/*BOCSUP//BOC System Super ID auditclasses=general login=true su=false rlogin=false daemon=true admin=true sugroups=sysadm admgroups=asmoper,asmdba,asmadmin,dba,was tpath=nosak ttys=ALL expires=0 auth1=SYSTEM auth2=NONE umask=27 registry=files SYSTEM=compat logintimes= loginretries=8 pwdwarntime=0 account_locked=false minage=0 maxage=4 maxexpired=-1 minalpha=1 minloweralpha=0 minupperalpha=0 minother=1 mindigit=0 minspecialchar=0 mindiff=6 maxrepeats=2 minlen=8 histexpire=40 histsize=8 pwdchecks= dictionlist= default_roles= fsize=-1 cpu=-1 data=-1 stack=-1 core=-1 rss=-1 nofiles=-1 fsize_hard=-1 cpu_hard=-1 data_hard=-1 stack_hard=-1 core_hard=-1 rss_hard=-1 nofiles_hard=-1 time_last_login=1456711975 time_last_unsuccessful_login=1456469618 tty_last_login=/dev/pts/0 tty_last_unsuccessful_login=/dev/vty0 host_last_login=22.188.216.132 host_last_unsuccessful_login=ZFXXX2 unsuccessful_login_count=0 roles=

咨询过系统方面的同事,这个用户没有用,就直接删除了,后边就是重新执行root.sh脚本了:

---执行失败,重新执行root.sh脚本,这里的ORACLE_HOME指的是GRID_HOME

---$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

Metalink上的文章

Errors PRCR-1006 PRCR-1071 PROC-5 reported during GI installation as multiple user has uid 0 (文档 ID 2012626.1)

In this Document

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.1.0 and later
Generic Linux
Generic UNIX

SYMPTOMS

When attempting to run root.sh after GI installation, the following error occurs.

-----------------------
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 78eb8dc1dbc64f95bf67d18e1ec11b0b (/dev/dev1) [OCR]
2. ONLINE 41936b8b5c9b4f0dbf086589f51537f8 (/dev/dev2) [OCR]
3. ONLINE 478aa42090794f8cbf5fe01c3601b84d (/oracle/app/votedisk/dev3) [OCR]
Located 3 voting disk(s).
PRCR-1006 : failed to add resource: ora.net1.network
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 hqspsl-cgam-r01 -A hqspsl-cgam-r01-vip/255.255.255.128/bond0 on node=hqspsl-cgam-r01 ... failed

CAUSE

Some user is sharing uid as with root user .

Verified it in /etc/passwd

.....
root:x:0:0:root:/root:/bin/bash
......
SuperUser :x:0:100::/home/SuperMan:/bin/bash \<\<\<=======The SuperUser is sharing the same uid 0

SOLUTION

Do not have uid 0 for user other than root

故障处理总结

① 由于安装过程是客户直接写的shell脚本的方式,不容易看出错误,也没有找见脚本runcluvfy.sh,所以安装失败的时候比较纠结,毕竟静默安装给出的错误有的时候不是很明显,安装GRID之前,尽量使用脚本./runcluvfy.sh stage -pre crsinst -n all -verbose来预检查安装环境。

② 其实该错误使用图形界面的时候已经给出的很明显了,root和pwd_user用户有相同的uid,都为0。

Oracle rac安装报错 multiple user has uid 0

标签:

头像

小麦苗

学习或考证,均可联系麦老师,请加微信db_bao或QQ646634621

您可能还喜欢...

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注

4 × 1 =

 

嘿,我是小麦,需要帮助随时找我哦
  • 18509239930
  • 个人微信

  • 麦老师QQ聊天
  • 个人邮箱
  • 点击加入QQ群
  • 个人微店

  • 回到顶部
返回顶部