[10gGrid Contril]EMREP启用AWR遇到的故障

登上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 ;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/317003/viewspace-536557/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/317003/viewspace-536557/