Book review : EM12c

OCM Oracle ACE Porus Homi Havewala wrote a new book on Cloud Control Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos It is a book about Enterprise Manager, but also a book about the Chaos. There is no separation of roles […] there is no DBA Designer (the Senior DBA) […] and no […]

Ow yes it is a “c” !

Rumours about what would come after 8i (internet) 10g (grid) were around, but now it is official, there will be an Oracle Enterprise Manager 12c Read more : http://www.oracle.com/us/products/enterprise-manager/index.html And in the blogosphere http://orana.info

OEM 10gR3 is out!

emgrid 10.2.0.3 is not the second patchset of 10gR2, it is Oracle Enterprise Manager Grid Control Release 3. Well, it is still called a patch set and must be applied to 10.2.0.1 or 10.2.0.2. But it is a new release ! You can download the soft and the doc on otn http://www.oracle.com/technology/software/products/oem/index.html Out of the […]

Monitoring the age of the last backup with OEM

My customer wants to receive alerts if a database has not been backed up (either unsuccessful backup or no backup) for ages. As the customer have Oracle Enterprise Manager Grid Control 10gR2, I started using User Defined Metric (UDM) yesterday. Thanks Troy for his comment at OEM Generic Service I would do 2 checks, backup […]

OEM Generic service

I want to monitor the output of one script in OEM. Let’s say my script is that easy : #!/bin/ksh echo $RANDOM So I go to OEM 10gR2 Grid Control All Targets Add Generic Service – Go Name : random Select System : EM Website System Define availability based on: Service Test Test Type: custom […]

How To Add The Domain Name Of The Host To Name Of The Agent

I have been looking for this note for ages : Metalink note 295949.1 Now I know how to rename my targets in Grid Control! the trick is to stop the agent AH/emctl stop agent to remove the upload and state files/subdirectories cd AH/sysman/emd find state upload recv agntstmp.txt lastupld.xml protocol.ini -type f -exec rm {} […]

grid control release 2

I am waiting for eomgc 10gR2 for AIX so I check the download page often. Instead of adding new plateforms, I notice they just removed Solaris ! Oracle Enterprise Manager 10g Grid Control Release 2 (10.2.0.1) for Solaris Operating System (SPARC) google cache

oem grid control 10gR2 on Suse10

Last friday I installed RAC on my Suse10. Today, I installed Grid Control. Of course it is not supported. The packages I neeeded additionaly are db1 and openmotif. It did not work 100%. I finally started the iasconsole (emctl start iasconsole), and within the iasconsole, I restarted the failed elements. I created the repository manually […]

lock system, restrict dbsnmp

An unlocked user is a security problem. Currently, all my unlocked users have only CREATE SESSION as system privilege, evtl ALTER SESSION. Except SYS, SYSTEM and DBSNMP To minimize this security problem, I implemented the following strategy on my test system. 1) delete password file, set remote_login_passwordfile=NONE, O7_DICTIONARY_ACCESSIBILITY=FALSE 2) alter user SYSTEM account lock; 3a) […]

10.1.0.4 management agent for Unix

I just found in my RSS feed that a new agent has been released. 10.1.0.4 for AIX5L. Well, if you go to the OEM download page, you will see only 10.1.0.2 version for AIX, HPUX, Solaris Sparc. But by clicking on the link, for example Grid Control (10.1.0.2) for AIX5L Based Systems, you will find […]