Oracle重建awr步驟
1.穩妥起見,建議停機重建
2.如果是rac環境需要修改如下引數:
3.執行如下指令碼開始清除,執行速度很快,因為都是drop,如果遇到某個表不存在的報錯,無須理會
4.執行指令碼執行重建
5.執行指令碼編譯無效物件
6. 11g執行如下指令碼
執行這個指令碼的時候,遇到如下報錯:
解決辦法是對包重新編譯:
7.重新執行第六步
8.生成一個報告試試
遇到如下報錯:
在MOS上找到一篇文章說了這個問題
9.重啟後問題解決
10.修改rac 相關引數
11.生成awr報告
2.如果是rac環境需要修改如下引數:
-
alter system set cluster_database = false scope = spfile;
- @?/rdbms/admin/catnoawr.sql
- @?/rdbms/admin/catawrtb.sql
- @?/rdbms/admin/utlrp.sql
- @?/rdbms/admin/execsvrm.sql
-
BEGIN
-
*
-
ERROR at line 1:
-
ORA-04068: existing state of packages has been discarded
-
ORA-04061: existing state of package "SYS.DBMS_SWRF_INTERNAL" has been
-
invalidated
-
ORA-04065: not executed, altered or dropped package "SYS.DBMS_SWRF_INTERNAL"
-
ORA-06508: PL/SQL: could not find program unit being called:
-
"SYS.DBMS_SWRF_INTERNAL"
- ORA-06512: at line 3
-
alter package dbms_swrf_internal compile;
- alter package dbms_swrf_internal compile body;
8.生成一個報告試試
- exec dbms_workload_repository.create_snapshot;
-
SQL> exec dbms_workload_repository.create_snapshot;
-
BEGIN dbms_workload_repository.create_snapshot; END;
-
-
*
-
ERROR at line 1:
-
ORA-13518: Invalid database id (819500514)
-
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 99
-
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 122
- ORA-06512: at line 1
-
ORA-13518 : 'Invalid Database Id' On Call to DBMS_WORKLOAD_REPOSITORY Package [ID 984447.1]
Changes
Recently AWR was recreated using catnoawr.sql and catawrtb.sql.
Cause
When a function / procedure is called from DBMS_WORKLOAD_REPOSITORY package, it refers table WRM$_DATABASE_INSTANCE to get dbid information.
As the AWR repositories has been recreated , the table doesn't not have any data present in it.
SQL> select * from WRM$_DATABASE_INSTANCE ;
no rows selected
Solution
The WRM$_DATABASE_INSTANCE gets populated with instance information when the instance is rebooted.
So, If you have recreated AWR using catnoawr.sql , catawrtb.sql , then you need to bounce the Instance .
On restart , the table will be populated with the requisite information.
Hence , better option for recreating AWR is to use startup restrict method.
After the recreation activity is completed , shutdown the database and open it normally.
9.重啟後問題解決
10.修改rac 相關引數
- alter system set cluster_database = true scope = spfile;
- @$ORACLE_HOME/rdbms/admin/awrrpt.sql
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20893244/viewspace-2146541/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORACLE重建OEM的步驟Oracle
- Oracle 10G重建OEM 的簡單步驟Oracle 10g
- oracle 10g rac em重建實施步驟Oracle 10g
- Oracle AWR 資料匯入/匯出的步驟Oracle
- ASM 仲裁盤OCR DG損壞,重建步驟ASM
- 重建ASM磁碟組的步驟 [ID 268481.1]ASM
- oracle 安裝步驟Oracle
- oracle升級步驟Oracle
- ORACLE啟動步驟Oracle
- Oracle DataGuard切換步驟Oracle
- 建立oracle快照的步驟Oracle
- 1、啟動oracle的步驟Oracle
- 簡單oracle安裝步驟Oracle
- Oracle EM agent刪除步驟Oracle
- Oracle ADG實施步驟Oracle
- ORACLE RAC OCFS(步驟簡要)Oracle
- VMware中配置ORACLE DATAGUARD步驟Oracle
- Oracle Stream配置詳細步驟Oracle
- Oracle SQL優化基本步驟OracleSQL優化
- Steps to Re-Create ASM Diskgroups(重建asm 磁碟組步驟)ASM
- 水煮oracle28----oracle手工建庫步驟Oracle
- Oracle資料庫啟動步驟Oracle資料庫
- Oracle檢視trace檔案步驟Oracle
- Oracle冷備份的通常步驟Oracle
- oracle啟動的三個步驟Oracle
- Oracle 啟動的三個步驟Oracle
- Oracle SQL語句執行步驟OracleSQL
- Oracle 11.2 RAC改IP步驟Oracle
- oracle線上重定義表步驟Oracle
- 使用Oracle Statpack的具體步驟Oracle
- oracle 伺服器啟動步驟Oracle伺服器
- ORACLE AWROracle
- Oracle AWR ---Oracle
- oracle awrOracle
- [Oracle] Oracle11g listener.log清除步驟Oracle
- Oracle RAC叢集解除安裝步驟Oracle
- 解決Oracle死鎖問題步驟Oracle
- Oracle 11.2 RAC改 Private IP步驟Oracle