Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
EM Grid Control target discovery after a clone | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

EM Grid Control target discovery after a clone

  • Posted by Arjun Raja
  • On July 22, 2009
  • 1 Comments

If a database is cloned or recreated on another machine with the same name, the new database will not be discovered on the GRID.

There is a reason behind this .

Example

Database called test already discovered on GRID – database on ABC machine.

Create or clone a database with the same name test on another machine XYZ.

Try to discover this new database on the GRID using the manual option or the option to monitor via grid control while creating the database.

The new database test will not be discovered on the GRID and cannot be seen in the list of targets on the GRID .

That is because a databse with the same name the test database has also has been discovered and runs from another box.

Only when a manual install was attempted and the name of the instance was issued as test.domain instead of just test that it worked .

As you can see below – the repository ( sysman in emrep database ) has a table called mgmt_targets which maintains these details and does not allow duplicates( so a little tweaking is necessary )

The agent tried to upload test automatically when installed on the new box and start it up- and it failed to do so as this entry exists in the table.

Currently both databases are disovered – run this command in the emrep ( repository database) as sysman.

SQL> select target_name, from mgmt_targets where target_name like ‘%TEST%’;

TARGET_NAME
test
test.domain

 

1 Comments

zynga
  • Mar 21 2010
i would not have guessed this had been outstanding a couple years ago yet it's crazy precisely how time changes the manner you experience varied concepts, thank you for the blog post it's nice to read something smart now and then in lieu of the common garbage mascarading as information sites on the web, i'm going to have fun with a few hands of zynga poker, take care

Leave Reply

Your email address will not be published. Required fields are marked *