Oracle エラー対応

エラー対応

Oracle |

エラー内容を確認するコマンド oerr

$ 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.

対応

ORA-00988: missing or invalid password(s)

• 数字で始まるパスワードの場合、ダブルクォーテーションで囲む

ORA-01950: 表領域'XXXXX'に対する権限がありません

ALTER USER [USERNAME]
 QUOTA UNLIMITED ON [TABLESPACE_NAME]; 

---