登上oem发现grid control的emrep没有awr snapshot,查询
select snap_interval, retention
from dba_hist_wr_control;
发现no rows selected
手工设置一下,
begin dbms_workload_repository.modify_snapshot_settings ( interval => 60, retention => 15*24*60 ); end;
报错
ORA-13516: SWRF Operation failed: SWRF Schema not initialized
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 83
ORA-06512: at line 1
上metalink一查发现是bug,被隐藏参数“_awr_restrict_mode”禁用了
结论:本来以为emrep也就是普通的db加上了awr专用的一些存储过程,添了2个专用tablespace(mgmt……),看来还是阉割了些东西的……
件名: Problem: ORA-13516 When Trying To Make A Manual Snapshot Of Repository Database
Doc ID: 365097.1 タイプ: PROBLEM
最終修正日: 01-NOV-2008 ステータス: PUBLISHED
In this Document
Symptoms
Cause
Solution
References
Applies to:
Enterprise Manager Grid Control - Version: 10.2.0.1 to 10.2.0.4
This problem can occur on any platform.
Symptoms
10.2.0.1 GC with 10.1.0.4 new database holding the repository.
You do the following
1)Targets->Databases->Select the repository database
2)Select performance tab
3)Select snapshots
In this screen you see there are not any snapshots yet. You click on create snapshot button. After a few moments you get the following error:
ORA-13516: SWRF Operation failed: SWRF Schema not initialized
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 31
ORA-06512: at line 1
Cause
The problem is due to the following un-published bugs:
Unpublished Bug 5052360 NT 10202 M5 SQL ERROR: ORA-13516: SWRF OPERATION FAILED
Unpublished Bug 4701817 EM REPOSITORY DATABASE CREATED DURING INSTALL CONTAINS _AWR_RESTRICT_MODE SET
Problem comes from the _awr_restrict_mode initialization parameter which is set to TRUE and turns off all AWR features in the repository database.
Solution
To implement the solution, please execute the following steps:
1. Stop the OMS and the agent:
AGENT_HOME/bin/emctl stop agent
OMS_HOME/opmn/bin/opmnctl stopall
2. Shutdown the repository database
3. Log on as sys in sqlplus and run:
create pfile='//init.ora' from spfile
4. Edit the created init.ora file and remove the following line:
*._awr_restrict_mode=TRUE
5. Back in the sqlplus session run:
create spfile from pfile='//init.ora'
6. Startup the database
7. Start the OMS and the agent
8. Re-try to manually create the snapshot
References
Note 419877.1 - Internal Errors When Editing The Awr Settings From EM
Keywords
INITIALIZATION~PARAMETERS ; GRID~CONTROL ; PFILE ; DBMS_WORKLOAD_REPOSITORY ; ENTERPRISE~MANAGER ; OMS ;
select snap_interval, retention
from dba_hist_wr_control;
发现no rows selected
手工设置一下,
begin dbms_workload_repository.modify_snapshot_settings ( interval => 60, retention => 15*24*60 ); end;
报错
ORA-13516: SWRF Operation failed: SWRF Schema not initialized
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 83
ORA-06512: at line 1
上metalink一查发现是bug,被隐藏参数“_awr_restrict_mode”禁用了
结论:本来以为emrep也就是普通的db加上了awr专用的一些存储过程,添了2个专用tablespace(mgmt……),看来还是阉割了些东西的……
件名: Problem: ORA-13516 When Trying To Make A Manual Snapshot Of Repository Database
Doc ID: 365097.1 タイプ: PROBLEM
最終修正日: 01-NOV-2008 ステータス: PUBLISHED
In this Document
Symptoms
Cause
Solution
References
Applies to:
Enterprise Manager Grid Control - Version: 10.2.0.1 to 10.2.0.4
This problem can occur on any platform.
Symptoms
10.2.0.1 GC with 10.1.0.4 new database holding the repository.
You do the following
1)Targets->Databases->Select the repository database
2)Select performance tab
3)Select snapshots
In this screen you see there are not any snapshots yet. You click on create snapshot button. After a few moments you get the following error:
ORA-13516: SWRF Operation failed: SWRF Schema not initialized
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 31
ORA-06512: at line 1
Cause
The problem is due to the following un-published bugs:
Unpublished Bug 5052360 NT 10202 M5 SQL ERROR: ORA-13516: SWRF OPERATION FAILED
Unpublished Bug 4701817 EM REPOSITORY DATABASE CREATED DURING INSTALL CONTAINS _AWR_RESTRICT_MODE SET
Problem comes from the _awr_restrict_mode initialization parameter which is set to TRUE and turns off all AWR features in the repository database.
Solution
To implement the solution, please execute the following steps:
1. Stop the OMS and the agent:
AGENT_HOME/bin/emctl stop agent
OMS_HOME/opmn/bin/opmnctl stopall
2. Shutdown the repository database
3. Log on as sys in sqlplus and run:
create pfile='//init.ora' from spfile
4. Edit the created init.ora file and remove the following line:
*._awr_restrict_mode=TRUE
5. Back in the sqlplus session run:
create spfile from pfile='//init.ora'
6. Startup the database
7. Start the OMS and the agent
8. Re-try to manually create the snapshot
References
Note 419877.1 - Internal Errors When Editing The Awr Settings From EM
Keywords
INITIALIZATION~PARAMETERS ; GRID~CONTROL ; PFILE ; DBMS_WORKLOAD_REPOSITORY ; ENTERPRISE~MANAGER ; OMS ;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/317003/viewspace-536557/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/317003/viewspace-536557/