| ページ一覧 | ブログ | twitter |　 書式 | 書式(表) |

MyMemoWiki

「Oracle エラー対応」の版間の差分

提供: MyMemoWiki
ナビゲーションに移動 検索に移動
(ページの作成:「==エラー対応== [Oracle] ===エラー内容を確認するコマンド oerr=== $ oerr ora 1031 01031, 00000, "insufficient privileges" // *Cause: An attempt w…」)
 
 
(同じ利用者による、間の2版が非表示)
1行目: 1行目:
 
==エラー対応==
 
==エラー対応==
−
[Oracle]
+
[[Oracle]] |
 
===エラー内容を確認するコマンド oerr===
 
===エラー内容を確認するコマンド oerr===
 
  $ oerr ora 1031
 
  $ oerr ora 1031
−
  01031, 00000, "insufficient privileges"
+
  01031, 00000, "insufficient pri[[vi]]leges"
 
  // *Cause: An attempt was made to change the current username or password
 
  // *Cause: An attempt was made to change the current username or password
−
  //        without the appropriate privilege. This error also occurs if
+
  //        without the appropriate pri[[vi]]lege. This error also occurs if
 
  //        attempting to install a database without the necessary operating
 
  //        attempting to install a database without the necessary operating
−
  //        system privileges.
+
  //        system pri[[vi]]leges.
−
  //        When Trusted Oracle is configure in DBMS MAC, this error may occur
+
  //        When Trusted [[Oracle]] is configure in DBMS MAC, this error may occur
−
  //        if the user was granted the necessary privilege at a higher label
+
  //        if the user was granted the necessary pri[[vi]]lege at a higher label
 
  //        than the current login.
 
  //        than the current login.
 
  // *Action: Ask the database administrator to perform the operation or grant
 
  // *Action: Ask the database administrator to perform the operation or grant
−
  //          the required privileges.
+
  //          the required pri[[vi]]leges.
−
  //          For Trusted Oracle users getting this error although granted the
+
  //          For Trusted [[Oracle]] users getting this error although granted the
−
  //          the appropriate privilege at a higher label, ask the database
+
  //          the appropriate pri[[vi]]lege at a higher label, ask the database
−
  //          administrator to regrant the privilege at the appropriate label.
+
  //          administrator to regrant the pri[[vi]]lege at the appropriate label.
  
 
===対応===
 
===対応===
−
=====ORA-00988: missing or invalid password(s)=====
+
=====O[[R]]A-00988: missing or invalid password(s)=====
 
*数字で始まるパスワードの場合、ダブルクォーテーションで囲む
 
*数字で始まるパスワードの場合、ダブルクォーテーションで囲む
−
=====ORA-01950: 表領域'XXXXX'に対する権限がありません=====
+
=====O[[R]]A-01950: 表領域'XXXXX'に対する権限がありません=====
 
  ALTER USER [USERNAME]
 
  ALTER USER [USERNAME]
 
   QUOTA UNLIMITED ON [TABLESPACE_NAME];  
 
   QUOTA UNLIMITED ON [TABLESPACE_NAME];  
 
----
 
----
−
{{include_html banner_html, "!Oracle"}}
+
{{include_html [[banner_html]], "!Oracle"}}

2020年2月16日 (日) 04:29時点における最新版

エラー対応

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"}}

「https://www.typea.info/tips_/index.php?title=Oracle_エラー対応&oldid=6411」から取得

© 2006 矢木浩人