Knowledge Base >> Register an Oracle Standby Database for Monitoring

Register an Oracle Standby Database for Monitoring - Confio Article 1602

Confio Article: 1602 Published: Jun 06 2011 10:01 AM
Version: 4.3+ Topic(s): Install and Setup Ignite Management
Product(s): Ignite
Database(s): Oracle

An Oracle standby database can be started in a read-only mode to allow reports and other activity to be performed against it. In that case it may make sense to monitor the read-only database with Ignite, however, there is a special registration process that you will need to perform. Normal registration will fail when the database is read only.

 

The processes essentially involves registering another Oracle database and then switching things in Ignite to the read-only database. Here are the steps for manual registration of the standby database:

 

1. Register a separate database in Ignite via the Ignite Wizard.

  • Click the Register Database Instance button on the Ignite Home screen.
  • Follow the wizard to completion.

2. Stop the Ignite monitor immediately after the wizard completes.

  • On the Ignite Home screen, find the database instance just registered.
  • Choose Stop Monitor from the Action dropdown next to this database.

3. Change the connection information in Ignite to point to the Oracle Standby database

  • From the Ignite GUI choose Options > Update Monitored Database Instance Connection.
  • On the next screen choose the newly registered database followed by Next.
  • Modify the connection information as appropriate for the standby database.
  • Assuming you have already registered the production database tied to this standby, the Ignite user should already exist.

4. Change the name of the database displayed on the Ignite home screen

  • Login via SQL*Plus (or any tool that allows execution of SQL statements) to the Ignite repository database.
  • Find the ID for the newly registered database by running this SQL:
select id, name from cond order by name;  -- remember the ID value for the new database
  • Modify the name by running a SQL similar to the following:
update cond set name = '&NewName' where id = &IDFromPreviousQuery;
commit;

5. Start the Ignite monitor for the standby database

  • On the Ignite Home screen, choose Start Monitor from the Action dropdown next to the new database
  • Verify that monitoring starts and Ignite is now monitoring the standby database
Tags: oracle register read only standby manual. registration