同事在arm上测试19c部署时,发截图给我说dbca建库有告警,无法进行,
Cause- OS Authentication might be disabled for this database (orcl).
Action Specify a valid sysdba user name and password to connect to the database.
查找到的问题点是:oracle不在dba组内
处理办法:
[root@db ~]# id oracle
uid=1502(oracle) gid=501(oinstall) groups=501(oinstall),54323(oper)
[root@db ~]# more /etc/group|grep
dba:x:502:
[root@db ~]# usermod -a -G dba oracle
[root@db ~]# id oracle
uid=1502(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),54323(oper)
[root@db ~]# more /etc/group|grep dba
dba:x:502:oracle
20230801更新,报错:PRVF-7566
在应用补丁时,在rac环境也遇到类似问题
grid@db1> cluvfy comp sys -n all -p crs -verbose
。。。。。。。。。。
。。。。。。。。。
Verifying Group Membership: dba ...FAILED
db1: PRVF-7566 : User "grid" does not belong to group "dba" on node "db1"
处理办法-2个节点都执行
# usermod -a -G dba grid