Oracle所有者不是dba 引起sqlplus / as sysdba 登入報錯ORA-01031

標題： Oracle所有者不是dba 引起sqlplus / as sysdba 登入報錯ORA-01031 

---

[root@sinosoft ~]# id  oracle 
uid=501(oracle) gid=1302(oinstall) 組=1302(oinstall)

[root@sinosoft ~]# usermod -g oinstall -G dba,oper,asmdba,asmadmin oracle
[root@sinosoft ~]# id oracle
uid=501(oracle) gid=1302(oinstall) 組=1302(oinstall),1200(asmadmin),1201(asmdba),1300(dba),1301(oper)
[root@sinosoft ~]# su - oracle
[oracle@sinosoft ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 16 14:52:32 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>