sqlplus / as sysdba 提示ORA-01031: insufficient privileges
我安装的是oracle rac 共8个node 1-7node会出现这个错误,8节点正常,
我id了一下 8个node都是 uid=109(sysvldb) gid=20(users) groups=105(oinstall),8500(dba),42424(svrtech)
可以看到用户sysvldb在dba组里面但为什么却会出现01031这个error呢
------------------------------------------------------------------------
一下是/etc/group内容
root::0:root
other::1:root,hpdb
bin::2:root,bin
sys::3:root,uucp
adm::4:root,adm
daemon::5:root,daemon
mail::6:root
lp::7:root,lp
tty::10:
nuucp::11:nuucp
users::20:root
nogroup:*:-2:
smbnull::101:
cimsrvr::102:
hpsmh::103:
sshd::104:
oper::8501:aime,aime1,aime2,aime3,aime4,aime5,aime6,aime7,aime8,aime9,aime10
oinstall::105:aime,sysvldb
+
dba::8500:daemon,aime,aime1,aime2,aime3,aime4,aime5,aime6,aime7,aime8,aime9,aime
10,optena,cshet,root,daemon,shamsubr,skapugan,sysvldb
svrtech::42424:daemon,root,aime,aime1,aime2,aime3,aime4,aime5,aime6,aime7,aime8,
aime9,aime10,cshet,root,daemon,shamsubr,skapugan,sysvldb
----------------------------------------------------------------------------------------------
这个问题困扰了我好久,希望大家能帮我看看问题可能会出现在哪里
sqlplus
username:sys as sysdba
passwork: *******
这样可以正常进入数据库。
我安装的是oracle rac 共8个node 1-7node会出现这个错误,8节点正常,
我id了一下 8个node都是 uid=109(sysvldb) gid=20(users) groups=105(oinstall),8500(dba),42424(svrtech)
可以看到用户sysvldb在dba组里面但为什么却会出现01031这个error呢
------------------------------------------------------------------------
一下是/etc/group内容
root::0:root
other::1:root,hpdb
bin::2:root,bin
sys::3:root,uucp
adm::4:root,adm
daemon::5:root,daemon
mail::6:root
lp::7:root,lp
tty::10:
nuucp::11:nuucp
users::20:root
nogroup:*:-2:
smbnull::101:
cimsrvr::102:
hpsmh::103:
sshd::104:
oper::8501:aime,aime1,aime2,aime3,aime4,aime5,aime6,aime7,aime8,aime9,aime10
oinstall::105:aime,sysvldb
+
dba::8500:daemon,aime,aime1,aime2,aime3,aime4,aime5,aime6,aime7,aime8,aime9,aime
10,optena,cshet,root,daemon,shamsubr,skapugan,sysvldb
svrtech::42424:daemon,root,aime,aime1,aime2,aime3,aime4,aime5,aime6,aime7,aime8,
aime9,aime10,cshet,root,daemon,shamsubr,skapugan,sysvldb
----------------------------------------------------------------------------------------------
这个问题困扰了我好久,希望大家能帮我看看问题可能会出现在哪里
sqlplus
username:sys as sysdba
passwork: *******
这样可以正常进入数据库。
SQLNET.AUTHENTICATION_SERVICES 配置项
Some Oracle releases have problems with identifying the OSDBA group when it is
not the users primary group.
If you encounter problems with connecting and the OSDBA group is set correctly
try making the users primary group the OSDBA group, or use 'newgrp' as in (b)
above.
都显示正常
就是dbca 安装数据库的时候到最后会出现ORA-01031:
sqlplus / as sysdba 进不去数据库的问题
现在解决了,
但是srvctl 还有问题也是01031的问题 估计还是权限问题,但是不影响数据库应用