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

maohaiqing0304發表於2014-12-21
OracleSQL

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

作者：ｌōττéｒｙ©版權所有[文章允許轉載,但必須以連結方式註明源地址,否則追究法律責任.]


環境：
[oracle@sinosoft admin]$ sqlplus / as sysdba  

SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 16 14:46:47 2014

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

ERROR:
ORA-01031: insufficient privileges
....

[oracle@sinosoft ~]$ sqlplus lottery/lottery     -- 普通使用者沒問題

SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 16 14:53:27 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> 

----檢查
[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> 


  【源於本人筆記】 若有書寫錯誤，表達錯誤，請指正...
此條目發表在 Oracle  分類目錄。將固定連線加入收藏夾。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28602568/viewspace-1375239/，如需轉載，請註明出處，否則將追究法律責任。

相關文章