Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

Home > Success Center > Database Performance Analyzer (DPA) > Register an Oracle standby database for monitoring

Register an Oracle standby database for monitoring

Table of contents
No headers
Created by Interspire Import, last modified by Mandeville on Dec 02, 2016

Views: 133 Votes: 0 Revisions: 12

You can start an Oracle standby database in read-only mode to run reports and perform other activities against it. You can monitor the read-only database with DPA, however there is a special registration process. Standard registration fails when the database is read-only.

 

You must register another Oracle database that is not read-only, and then repoint DPA to the read-only database.

 

  1. Click Options > Register for Monitoring. Register a separate Oracle database in the Register Instance Wizard.
  2. On the home screen, click Action > Stop Monitor next to the new database.
  3. Click Options > Update Connection Info
  4. Select the newly registered database, and click Next.
  5. Enter the connection and user information of the read-only Oracle database, and complete the wizard.
    • If you registered the production database tied to this standby, the DPA monitoring user should exist.
  6. Log in to the DPA repository database with a SQL statement execution tool.
  7. Find the ID for the newly registered database by running this SQL statement:
    select id, name from cond order by name;  -- remember the ID value for the new database
  8. Modify the name by running a SQL statement like this:
    update cond set name = '&NewName' where id = &IDFromPreviousQuery;
    
    commit;
  9. On the home screen, click Action > Start Monitor next to the standby database.

 

NOTE: This will work as long as the objects currently exist for the monitoring user (likely because the primary was registered and objects replicated). Check out the objects and permissions here.

Last modified
17:17, 2 Dec 2016

Tags

Classifications

Public