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]; 
----
{{include_html banner_html, "!Oracle"}}