oem配置awr，修改awr数据的上传频率

1.登录
[oracle@lxbem13c01 bin]$ ./emcli awrwh_reconfigure -list
Error: Session expired. Run emcli login to establish a session.
[oracle@lxbem13c01 bin]$ ./emcli login -username=sysman
Enter password :

Login successful
2.查看
[oracle@lxbem13c01 bin]$ ./emcli awrwh_reconfigure -list
Upload Interval (hours) = 24
Retention (years) = 1
Dump Location = /u01/app/oracle/product/Middleware_13c/agent_inst/awr_t
AWR Warehouse reconfigured successfully
3.修改
[oracle@lxbem13c01 bin]$ ./emcli awrwh_reconfigure -upload_interval=6
Submitted Reconfigure Job: CAW_RECONFIGURE_1521605975608
AWR Warehouse reconfigured successfully
4.查看修改结果
[oracle@lxbem13c01 bin]$ ./emcli awrwh_reconfigure -list
Upload Interval (hours) = 6
Retention (years) = 1
Dump Location = /u01/app/oracle/product/Middleware_13c/agent_inst/awr_t
AWR Warehouse reconfigured successfully
[oracle@lxbem13c01 bin]$

EM13c: How To Change Upload Interval Of SnapShots In AWR Warehouse Repository Database In 13.2 OEM Cloud Control (文档 ID 2247438.1)

In this Document 

APPLIES TO:

Enterprise Manager for Oracle Database - Version 13.2.2.0.0 and later
Information in this document applies to any platform.

GOAL

 How to change upload interval of snapshots in AWR warehouse repository database in 13.2 Cloud Control

SOLUTION

Changing of AWR warehouse repository database retention period is currently possible with 13.2.2 database plugin.

Ensure database plugin on OMS is 13.2.2 then run the following command to change the upload interval of snapshots in AWR Warehouse Repository database:

<OMS_HOME>/bin>./emcli awrwh_reconfigure -upload_interval <New upload interval>

upload_interval: New upload interval (in hours)

Example: 
[oracle@anandu bin]$ ./emcli awrwh_reconfigure -upload_interval=12
Submitted Reconfigure Job: CAW_RECONFIGURE_1490290053857
AWR Warehouse reconfigured successfully

 

To see the current configuration of AWR warehouse repository database, following command can be used:

<OMS_HOME>/bin>./emcli awrwh_reconfigure -list

Example:
[oracle@anandu bin]$ ./emcli awrwh_reconfigure -list
Upload Interval (hours) = 12
Retention (years) = 1
Dump Location = /u03/anandu/agent_awr/agent_inst/awr_t
AWR Warehouse reconfigured successfully

REFERENCES

NOTE:2247437.1 - EM13c: How To Change Retention Period Of AWR Warehouse Repository Database In 13.2 OEM Cloud Control
NOTE:2235005.1 - EM13c: How To Change Staging Location Of AWR Dump Files On Source Database In 13.2 OEM Cloud Control
NOTE:2247439.1 - EM13c: How To Change Staging Location Of Dump Files On AWR Warehouse Repository Database In 13.2 OEM Cloud Control