linux as 2.1 ORA-01031: insufficient privileges 解決方法
[root@localhost log]# su - oracle
sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.1.0 - Production on 星期三 9月 17 15:55:05 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-01031: insufficient privileges
報錯 沒有足夠許可權
[oracle@localhost oracle]$ id oracle
uid=501(oracle) gid=502(orainstall) groups=502(orainstall)
發現oracle使用者不在dba組中
用root使用者登入
編輯/etc/group 把紅色字型 oracle加進去
vi /etc/group
pvm:x:24:
piranha:x:60:
netdump:x:34:
user:x:500:
dba:x:501:oracle
orainstall:x:502:
"/etc/group" 45L, 614C written
[root@localhost log]# su - oracle
[oracle@localhost oracle]$ sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.1.0 - Production on 星期三 9月 17 12:28:55 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
連線到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> exit
從Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production中斷開
[oracle@localhost oracle]$ id oracle
uid=501(oracle) gid=502(orainstall) groups=502(orainstall),501(dba)
正常
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-448752/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ora-01031:insufficient privileges解決方法
- ORA-01031: insufficient privileges的解決方法
- ORA-01031: insufficient privileges錯誤解決方法
- Linux oracle ORA-01031: insufficient privilegesLinuxOracle
- sqlplus "/ as sysdba" 連不上,報ora-01031:insufficient privileges解決方法SQL
- conn / as sysdba 出現ORA-01031: insufficient privileges 解決辦法
- create view receive "ORA-01031: insufficient privileges"View
- 建立資料庫時“Insufficient privileges”的解決方法DK資料庫
- oracle 10g linux 遠端登入 ORA-01031: insufficient privilegesOracle 10gLinux
- oracle rac dg庫報錯ORA-01031: insufficient privilegesOracle
- 在AIX 平臺下遇到ORA-01031: insufficient privilegesAI
- RMAN system 遠端連線 ORA-01031: insufficient privileges
- Oracle遠端登入報錯:ora-01031:insufficient privilegesOracle
- SYS遠端連線出錯ORA-01031:Insufficient privileges
- ORA-01031: insufficient privileges重新配置sys登入密碼密碼
- 使用SYS使用者遠端登陸報許可權不足的解決:ORA-01031: insufficient privileges
- sys使用者遠端登入報ORA-01031 insufficient privileges
- SYS使用者登入Oracle報錯ORA-01031: insufficient privilegesOracle
- sqlplus / as sysdba報錯ORA-01031: insufficient privileges的原因分析SQL
- ORA-01031: 資料庫恢復時的insufficient privileges錯誤QS資料庫
- 儲存過程編譯報錯:PL/SQL:ORA-01031:insufficient privileges儲存過程編譯SQL
- sys使用者執行 grant授權提示ORA-01031: insufficient privileges
- [20240826]奇怪ORA-01031 insufficient privileges報錯.txt
- linux環境下sqlplus sys/sys@ORCL as sysdba報錯 ORA-01031: insufficient privilegesLinuxSQL
- 11gR2 Restart Database SRVCTL啟動DB報ORA-01031: insufficient privilegesRESTDatabase
- Oracle的SYS使用者登入報許可權不足(ORA-01031: insufficient privileges)Oracle
- SQL> conn sys/sys@vm_sigle as sysdba; 報ORA-01031: insufficient privileges錯誤SQL
- Oracle 軟體克隆後sysdba登入提示沒有許可權ora-01031: insufficient privilegesOracle
- ORA-20000: Insufficient privileges to analyze an object in SchemaObject
- MongoDB報錯Insufficient free space for journal files的解決方法MongoDB
- ORA-0131:Insufficient privileges.(DEBUG CONNECT SESSION)Session
- xmanager之linux 解決方法Linux
- Dynamics CRM 安裝SSRS Extension時報Could not find the name or insufficient right to see name的解決方法
- linux inode已滿解決方法Linux
- Difference of Revoke System Privileges and Object PrivilegesObject
- Linux 忘記密碼解決方法Linux密碼
- Linux——ssh登入很慢解決方法Linux
- MogDB-openGauss default privileges 使用方法