SolutionPack for Oracle Database Summary Sheet – ViPR SRM 3.6.2

Table of Contents

Overview

The SolutionPack for Oracle Database monitors the status and performance of an Oracle database. The SolutionPack gives visibility into listeners, tablespaces, versions, connections, commits and rollbacks. You can survey the Oracle core process, such as the SGA, and verify the hit ratio about cache, dictionary cache, latch cache, library cache, sort and sessions.

Main reports

Entire Oracle database infrastructure summary

Detailed database size

Oracle RAC view

Instances availability

Cross server KPIs

Supported collection interfaces

For information about supported collection interfaces, refer to the ViPR SRM Support Matrix.

Back to Top

Installing the SolutionPack

Before you begin

Procedure

  1. Click Administration.
  2. Click Centralized Management.
  3. Click SolutionPacks.
  4. Click SolutionPack Center.
  5. Select the SolutionPack in the Browse and Install SolutionPacks window.
  6. Click Install.
  7. Type the instance name.
  8. Assign a server for each component.
    In a typical four server deployment, the recommended servers are selected automatically.
  9. Click Next.
    The window displays data collection details.
  10. From the Data collection drop-down menu, select existing settings that have been specified for other components, or select Add a new data collection.
    If you select Add a new data collection, type information about the data collection. In Hostname or IP address to send data to, use localhost on port 2020, which is the Collector host where the Load Balancer Connector is installed.
  11. Leave Enable alerting on data collected checked.
  12. Optionally select the Enable property import for server enrichment checkbox. This will allow the system to show additional information about the database, such as where the database and its tablespace are located and on which file system.
  13. In the Backend configuration section, type the host information and credentials for the Primary Backend Host.
  14. Select Configure collector advanced settings to configure polling settings.
  15. Click Next.
    The window displays reports settings.
  16. From the Web-Service Gateway drop-down menu, select existing settings that have been specified for other components, or select Add a new Web-Service Gateway.
    If you select Add a new Web-Service Gateway, type information about the web-service gateway.
  17. In Administration Web-Service Instance, select an existing instance or create a custom instance.
  18. Click Install.
  19. Click Ok when the installation is complete.
  20. Click Discovery Center > Devices Management.
  21. Click Add new device.
  22. Click Oracle Database.
  23. Select the server and collector instance where you want to store the configuration details for this device, and then enter the hostname or IP address of the host, supply the login credentials, and specify the appropriate configuration settings.
  24. Click Test to validate the credentials.
  25. Click OK.
  26. Click Save.
Back to Top

Configuring the SolutionPack with an unprivileged account

The ViPR SRM collector must connect to each instance of Oracle databases and perform SQL queries. You can use either an administrator equivalent system account, or create a dedicated system account for the collector. If you want to use the last option, please ask the DBA administrator to run the following query against every instances/RAC cluster. This will create a watch4net account with specific grants for the ViPR SRM collector.

Procedure

  1. Create the watch4net user:
    create user watch4net identified by <securepassword> default tablespace users temporary tablespace temp;
  2. Grant the necessary privileges to the watch4net user by running the following grants:
    grant create session to watch4net;
    grant select on V_$SYSSTAT to watch4net;
    grant select on v_$filestat to watch4net;
    grant select on v_$database to watch4net;
    grant select on dba_data_files to watch4net;
    grant select on dba_extents to watch4net;
    grant select on dba_segments to watch4net;
    grant select on dba_free_space to watch4net;
    grant select on v_$parameter to watch4net;
    grant select on v_$sgainfo to watch4net;
    grant select on v_$rowcache to watch4net;
    grant select on v_$librarycache to watch4net;
    grant select on v_$latch to watch4net;
    grant select on v_$rollstat to watch4net;
    grant select on v_$dispatcher to watch4net;
    grant select on v_$instance to watch4net;
    grant select on v_$sesstat to watch4net;
    grant select on v_$statname to watch4net;
    grant select on v_$session to watch4net;
    grant select on v_$sess_io to watch4net;
    grant select on v_$asm_disk to watch4net;
    grant select on v_$asm_diskgroup to watch4net;
    grant select on v_$logfile to watch4net;
    grant select on v_$log to watch4net;
    grant select on sys.dba_tablespaces to watch4net;
    grant select on v$iostat_file to watch4net;
    grant select on dba_libraries to watch4net;
    

Results

Your dedicated account is configured.

Back to Top

Limitations

The All >> Report Library >> Oracle Database >> Inventory >> List all servers report does not work on SRM 3.5.x or SRM 3.6.x.

Back to Top