ORA-01031: insufficient privileges

[oracle@dba01 ~]$ cat /etc/oratab -- 으로 내 계정 확인한후에

 

ASM이 먼저 켜져있는지

DB가 먼저 켜져있는지 확인한다

 

sqlplus / as sysasm -- ASM     | . oraenv +ASM

sqlplus / as sysdba -- 일반 DB | . oraenv ORCL

 

 ASM실행 오류 

1. 반드시 계정 확인을 할것 !! 

2. ASM 먼저 키고 DB를 킬것 ! 

---

▶ 오류 찾기의 기본 oerr 명령어로 찾는다. 

인터넷에 검색하지 않고도 쉽게 이유와 해결방법을 제시해 준다. 

[oracle@ocm01 ~]$ oerr ora 1031
01031, 00000, "insufficient privileges"
// *Cause: An attempt was made to change the current username or password
//         without the appropriate privilege. This error also occurs if
//         attempting to install a database without the necessary operating
//         system privileges.
//         When Trusted Oracle is configure in DBMS MAC, this error may occur
//         if the user was granted the necessary privilege at a higher label
//         than the current login.
// *Action: Ask the database administrator to perform the operation or grant
//          the required privileges.
//          For Trusted Oracle users getting this error although granted the
//          the appropriate privilege at a higher label, ask the database
//          administrator to regrant the privilege at the appropriate label.