I have uploaded the material of the german presentation on Oracle Data Guard 11gr2 Whats New to the “presentation” section. It also contains 6 recorded demos using Enterprise Manager Grid Control.
I have uploaded- a step-by-step Installation Guide for Oracle Enterprise Manager Grid Control 11g on RHEL 5.5 x86-32 to the papers section:
In MetaLink Note 853691.1: “ALERT: Important Upgrade Steps Required for Enterprise Manager Grid Control 10gR5 (10.2.0.5) Upgrades”, Oracle Support recommends to install some patches after the upgrade of OEM to 10.2.0.5.
Especially, patch bundle #8708893 solves around 20 bugs which could interfere with normal operations of Grid Control.
Today, I tried to get a nice, clean report about objects with reclaimable space from Segment Advisor. It is no problem to display the list in Enterprise Manager Grid|DB Control, but it is not so easy in SQL*Plus.
This is what i ended up with:
SELECT
segment_owner ,
segment_name,
round(allocated_space/1024/1024) ALLOC_MB ,
round(used_space/1024/1024) USED_MB ,
round(reclaimable_space/1024/1024) RECLAIM_MB ,
(1-ROUND((used_space/allocated_space),2))*100 AS reclaim_pct
FROM TABLE(dbms_space.asa_recommendations('TRUE', 'TRUE', 'FALSE'))
WHERE tablespace_name IN ('TS_DATA')
AND segment_type = 'TABLE'
AND segment_owner LIKE '%'
AND segment_name LIKE '%'
AND (reclaimable_space >= 1000000
OR (((1-ROUND((used_space/allocated_space),2))*100)) > 30)
ORDER BY reclaimable_space DESC
A while ago, I attended a one-day seminar of DOAG, the german oracle user group, which covered Oracle Enterprise Manager – Grid Control 10gR5.
There were presentations about:
The presentation of the New Features is available (although in german) here. The other presentations are available for DOAG members at the DOAG site. Moreover, one of the presenters will install a website for OEM topics on insight-oem.com.
Finally, Oracle Enterprise Manager – Grid Control 10.2.0.5 is available for download for Win32 and Linux x86. Moreover, this is the first release to officially support 11.1.0.7 as repository database as well as the first release to officially support RHEL5 for OMS.
Relevant documents for upgrade are available on MetaLink:
To be continued….
If you are running 10.2.0.4 databases and OEM Grid Control Agent 10.2.0.4 and you see that the number of filedescriptors of emagent is constantly increasing, you are hitting Bug 7031906.
The errors in the logfile look like this:
2008-06-27 14:32:28,973 Thread-301 ERROR engine: [oracle_database,MDDB2.world,health_check] :
nmeegd_GetMetricData failed : Instance Health Check initialization failed due to one of the following causes:
the owner of the EM agent process is not same as the owner of the Oracle instance processes; the owner of the
EM agent process is not part of the dba group; or the database version is not 10g (10.1.0.2) and above.
2008-06-27 14:32:28,973 Thread-301 WARN collector:Error exit. Error message: Instance Health
Check initialization failed due to one of the following causes: the owner of the EM agent process is not same as
the owner of the Oracle instance processes; the owner of the EM agent process is not part of the dba group; or
the database version is not 10g (10.1.0.2) and above.
And if you do pmap -x
Oracle tracks this issue with Bug 7031906 and there are patches available. In case you are running an earlier version of agent or database, check MetaLink Note 602633.1.
I have realized that I have included it in the document “Oracle Enterprise Manager 10gR2 – Grid Control Installation” in the secion “papers”, but unfortunately, in german only.
