ORA-13516: AWR Operation failed: CATPROC not valid
一臺測試機上安裝11.2.0.4資料庫進度到80%多的時候報ORA-13516: AWR Operation failed: CATPROC not valid.
當時在設定密碼的時含有@符號,和以下文件相符:
DBCA fails in the middle of database creation with ORA-13516 / ORA-06512 (文件 ID 1929718.1)
In this Document
Symptoms
Cause
Solution
Applies to:
Oracle Database - Standard Edition - Version 11.2.0.2 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
Symptoms
DBCA fails while in the middle of creating the database with the following errors
ORA-13516: AWR Operation failed: CATPROC not valid
ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 206
ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 239
ORA-06512: at line 1
Cause
ORA-13516 DURING DB CREATION WHEN DB PWD CONTAINS " " (SPACE) CHARACTER Bug ID 8633879
This Bug is suspended due to lack of required information, but the issue is solved by using workaround (removing the space and the special characters used in the passwd)
Solution
Do not include any spaces or special characters in the password,
If you are particular with the passwords, then you can reset the passwords once the database is created. Eg:
conn / as sysdba
alter user USERNAME identified by PWD;
上面講到密碼中包含空格或是特殊字元就可能會在dbca時出現以上錯誤.在建庫的時候要避免使用空格或是特殊字元.當然和密碼中特殊字元相關的錯誤,也可能出現在rman中等.
根據這篇文章.個人覺得,oracle的密碼,最好是隻包含數字,字母,和($,#,_)這三個特殊字元,並且以字母開頭會比較好.
當時在設定密碼的時含有@符號,和以下文件相符:
DBCA fails in the middle of database creation with ORA-13516 / ORA-06512 (文件 ID 1929718.1)
In this Document
Symptoms
Cause
Solution
Applies to:
Oracle Database - Standard Edition - Version 11.2.0.2 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
Symptoms
DBCA fails while in the middle of creating the database with the following errors
ORA-13516: AWR Operation failed: CATPROC not valid
ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 206
ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 239
ORA-06512: at line 1
Cause
ORA-13516 DURING DB CREATION WHEN DB PWD CONTAINS " " (SPACE) CHARACTER Bug ID 8633879
This Bug is suspended due to lack of required information, but the issue is solved by using workaround (removing the space and the special characters used in the passwd)
Solution
Do not include any spaces or special characters in the password,
If you are particular with the passwords, then you can reset the passwords once the database is created. Eg:
conn / as sysdba
alter user USERNAME identified by PWD;
上面講到密碼中包含空格或是特殊字元就可能會在dbca時出現以上錯誤.在建庫的時候要避免使用空格或是特殊字元.當然和密碼中特殊字元相關的錯誤,也可能出現在rman中等.
根據這篇文章.個人覺得,oracle的密碼,最好是隻包含數字,字母,和($,#,_)這三個特殊字元,並且以字母開頭會比較好.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28539951/viewspace-1752962/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- dbca建立資料庫時報錯ORA-13516: AWR Operation failed: CATPROC not valid資料庫AI
- Failed to get D-Bus connection: Operation not permittedAIMIT
- Docker 警告 Plugin XXX is not valid: failed to fetch metadataDockerPluginAI
- docker安裝matlab mount failed: Operation not permitted.DockerMatlabAIMIT
- ORA-27300: OS system dependent operation:fork failed with statusAI
- 歸檔日誌滿導致ORA-13516錯誤,awr報表不能自動收集
- ORA-27300: OS system dependent operation:fork failed with status: 12AI
- SVN chechout failed: xxx is not valid as filename in directory svn檢出錯誤AI
- Flutter:VM snapshot must be valid. Check failed: vm. Must be able to initializeFlutterAI
- PHP報錯getimagesize(): SSL operation failed with code 1問題解決方案PHPAI
- [已解決] [HiveCatalog]Kerberos GSS initiate failed, No valid credentials provided, Cannot read from System.inHiveROSAIIDE
- MySQL建立使用者報錯 ERROR 1396 (HY000): Operation CREATE USER failed for 'afei'@'%'MySqlErrorAI
- [Javascript] ++operationJavaScript
- tidb Error: Operation aborted by user answer '' (cliutil.operation_aborted)TiDBError
- ORACLE AWROracle
- 【AWR】Oracle資料庫建立awr基線Oracle資料庫
- 【AWR】Oracle批量生成awr報告指令碼Oracle指令碼
- 講講AWR
- macOS: sudo : Operation not permittedMacMIT
- [Javascript] Encapsulate chunk operationJavaScript
- 036 Valid Sudoku
- spring - mvc - @ValidSpringMVC
- Longest Valid Parentheses
- 【AWR】Oracle awr相關檢視及體系介紹Oracle
- FSMO(Flexible Single Master Operation)FlexAST
- 3.4.3 Restoring the System to Normal OperationRESTORM
- group by event_name, operation
- 【最佳化】AWR
- oracle工具 awr formatOracleORM
- Leetcode 20 Valid ParenthesesLeetCode
- Leetcode 36 Valid SudokuLeetCode
- 125. Valid Palindrome
- 65-Valid Number
- cuda runtime error (801) : operation not supportedError
- [20230103]COUNT STOPKEY operation.txtTopK
- AWR TOP SQL實現SQL
- Leetcode 32 Longest Valid ParenthesesLeetCode
- CSS :valid 選擇器CSS
- fatal: Not a valid object name: 'master'ObjectAST