Friday, January 22, 2010

My New Grid Control book

Friends,

I am pleased to announce that my new book "Oracle Enterprise Manager Grid Control: Advanced OEM Techniques for the Real World" is getting ready to be published soon (Fall 2010) by Rampant Techpress:



http://www.rampant-books.com/book_1001_advanced_techniques_oem_grid_control.htm


Please do recommend to all your friends and colleagues, it is a great handy book if you really want to make best use of Oracle Enterprise Manager Grid Control.

I have based it on a lot of practical experience and I am sure it will be useful to a lot of you.

Regards,

Porus Homi Havewala
(Oracle ACE Director).

Wednesday, January 20, 2010

EM for Active-Passive environments

A DBA wrote to me and said he has some issues in seeing the targets in a 2 node active
passive cluster using SUN cluster. My advice to him was as follows:

Refer to the Oracle documention chapter "Configuring Oracle Enterprise Manager for Active and Passive Environments"

http://download.oracle.com/docs/cd/B16240_01/doc/em.102/e10954/actpass_env.htm#sthref274

As per this, the EM agent must be deployed to each physical node as well as to the logical IP address. You have obviously not done that. Setting up in an active-passive environment is more involved as compared to setting up in an active-active cluster (Oracle RAC!)

Tuesday, January 19, 2010

Reconfiguring Database Control using EMCA

Someone asked me a question. He wanted to restore a database to a new host. The database included the Enterprise Manager Repository. Using RMAN, he restored the database to the new host, but was unable to start Enterprise Manager on the new host.

My answer:

I presume you are talking of Enterprise Manager Database Control and its repository, and not Grid Control.

Since you have restored the database to a new server, you must manually configure database control using EMCA. This is because available ports etc may be different on different servers and Oracle cant use the same settings, also the Database control configuration files are actually sitting outside the db in the oracle home. So when you copy the database, you are not copying the home and that info is lost, so you must reconfigure database control on the new host.

Please refer to the Oracle documentation at :
http://download-uk.oracle.com/docs/cd/B283...ca.htm#BABDEHCE

This will tell you how to use EMCA to config database control. You may need to deconfig first to clear up any existing repository.

Saturday, January 9, 2010

Easy Disaster Proof Production : My New OTN Article published

I am pleased to announce that in the first month of the new year 2010, a brand-new technical article of mine has been published on the Oracle Technology Network :

Easy Disaster Proof Production with Grid Control
http://www.oracle.com/technology/pub/articles/havewala-easydr.html

The article, based on personal real-life experience, explains how the use of Oracle Enterprise Manager Grid Control for Data Guard setup, management (including switchover or failover), and monitoring can save a lot of time and resources.

Please read, enjoy and recommend to your friends and colleagues.

A Happy New Year 2010 to all of you. All the Best for the New Year.

Regards,

Porus Homi Havewala
(Oracle ACE Director).

Disclaimer

Opinions expressed in this blog are entirely the opinions of the writers of this blog, and do not reflect the position of Oracle corporation. No responsiblity will be taken for any resulting effects if any of the instructions or notes in the blog are followed. It is at the reader's own risk and liability.

Blog Archive