Tag Archives: EM

NON-SYSTEM DATA SEGMENTS IN SYSTEM TABLESPACES policy is firing for ORDDATA and APEX users [ID 1328174.1]

Found that you have EM reporting segments in SYSTEM and SYAUX tablespaces ? This is down to a bug in EM, Metalink note 1328174.1 explains it.

Posted in Enterprise Manager, Errors, Oracle | Tagged , , , | Comments Off

Data Guard requires more database privileges than are currently granted to you. Contact your DBA for more information.

You get the error: “Data Guard requires more database privileges than are currently granted to you. Contact your DBA for more information.” When selecting primary on a production database in OEM. Here’s the permissions required.

Posted in Enterprise Manager, Oracle | Tagged , , , , | Comments Off

Recording Database Size.

A user asks “I would like to check the growth of a particular tablespace on the database for a month or so, do you perhaps, have a script that can assist.” If you have no process capturing the size of … Continue reading

Posted in Database Size, Monitoring | Tagged , , , , , , , | Comments Off

Creating and working with Groups in EMCLI.

Here’s a spin off to create and manage/monitor groups in OMS, but using EMCLI to configure them.

Posted in EMCLI, Oracle Configuration Manager | Tagged , , | 1 Comment

Running BSU in offline mode.

Updating WebLogic in offline mode.

Posted in Enterprise Manager, OMS | Tagged , , , | Comments Off

Patch 9405592 on EM results in ORA-04091, Trigger Mutation

ORA-04091, Trigger Mutation Patched OEM 10.2.0.5 to 10.2.0.5.2 with patch 9405592, and I started getting errors in the emoms.log. java.sql.SQLException: ORA-04091: table SYSMAN.MGMT_DB_HDM_METRIC_HELPER is mutating, trigger/function may not see it ORA-06512: at “SYSMAN.MGMT_DB_HDM_METRIC_TR”, line 4 ORA-04088: error during execution of … Continue reading

Posted in Oracle | Tagged , , , , , , , , | Comments Off

Applying patch 9405592 to OEM

Here’s the Application of the 10.2.0.5.0 April 2010 patch on OEM.

Posted in Enterprise Manager | Tagged , , , , , , , , | Comments Off

Configuring Oracle Enterprise Manager and Agents for Proxy.

I had a problem with Configuring a database, and had problems resolving it. A Metalink SR and investigation led to the solution and something I didn’t think about before.

Posted in Oracle | Tagged , , , , , , , | Comments Off

Proxy Configuration.

Moved to WordPress.

Posted in Enterprise Manager, Oracle | Tagged , , , , , , , , , | Comments Off

Using setupCCR.

OCM and setupCCR. Part of the Oracle Configuration Manager and installed in various guises, heres the setupCCR, how to use it and what it does.

Posted in Oracle Configuration Manager | Tagged , , , | Comments Off