oracle
Oracle RDBMS Monitor

The oracle probe will run selected SQLs to extract vital information about your Oracle RDBMS instances. The information is presented to the database-administrator as alarms and/or as a report. The following information is monitored:

  • Database uptime
  • Tablespace growth
  • Database growth
  • Tablespace status
  • Index status
  • Data-file status
  • Rollback segment status
  • Fragmented segments
  • The extents that can't extend
  • The data dictionary cache-hit ratio
  • The data buffer cache-hit ratio
  • The Redo copy latch-hit ratio
  • The library cache-hit ratio
  • The sort-hit ratio
  • PGA resource consumption (monitor memory consumption of Oracle users)
  • The rollback segment contention
  • The number of invalid objects
  • The number of chained rows
  • The number of users currently logged onto the server
  • The MTS response time
  • The number of MTS waits
  • The enqueue resources
  • The UGA memory usage
  • User locks and locked users
  • Lock waits event time
  • The user buffer cache-hit ratio
  • System waits and user waits
  • Datafile i/o
  • System statistics
  • Global cache serviceutilization for RAC
  • Global cache fusion ratio for RAC
  • Global cache lock get time for RAC
  • Global cache lock conversion timeouts for RAC
  • Global cache average lock get time for RAC
  • Global cache corrupt blocks count for RAC
  • Global cache lost blocks count for RAC
  • Number of Long running queries
  • Tablespace Size
  • Database Size
  • Resource Utilization %
  • Dataguard Status
  • Dataguard Gap
  • Dataguard Timegap
  • Tablespace Temp Free
  • Active Users
  • Flash recovery area memory free
  • Active Connection Ratio

Requirements

Oracle INSTANT CLIENT is not supported.
Other: A database user with the privilege'SELECT_CATALOG_ROLE','gv_$sort_segment' and 'sys.ts$'
Script for a monitoring user: (connect as sys)

create user nimmon identified by nimmon;
grant connect to nimmon;
grant select_catalog_role to nimmon;
grant select on gv_$sort_segment to nimmon;
grant select on sys.ts$ to nimmon;
In case it's a CDB user then prefix username with 'c##' or 'C##' like for example
create user c##nimmon identified by nimmon;
Oracle user 'system' has these rigths already granted.
Role based login is also supported for e.g. : sys as sysdba

The probe can monitor Oracle databases running on UNIX and Windows platforms.

Installation notes

1. Make sure, the Oracle Client is set up and configured correctly. Oracle libraries have to be in system PATH. On LINUX the environmental variables ORACLE_SID and ORACLE_HOME have to be set for the Nimsoft controller. This can be done either in the controller GUI, or by editing the starting script 'nimbus', usualy located at /etc/init.d (the robot needs to be restarted).
2. Get the package oracle.zip from Internet Updates.
3. Get a valid license from http://www.nimsoft.no
. 4. Install oracle.zip on the machine running Oracle Client (use drag & drop from Nimbus Archive).
5. Double click on oracle probe to launch probe property sheet.
6. Configure the probe acc. to your specifications and connection requirements.
Note: On UNIX/Linux platforms make sure the $ORACLE_HOME libraries are in the pathbefore starting Nimsoft robot.
To load the shared libraries on Linux machine make sure “Current Enforcing Mode” of SELinux is set to permissive mode.

Supported Oracle versions and clients For supported combinations of Oracle servers and clients, please see the probe documentation.
Revision history
Date Description State Version
03.03.2020

What's New:

  • Added support for Oracle 18C RAC and 19c NON-RAC and RAC databases.

Fixed Defect:

  • Fixed an issue where Oracle probe configuration error for custom check points using Admin console. Support Case Number: 01337227
  • Fixed an issue where Oracle probe sent timeout error for custom query when the query takes more than 30 seconds using IM. Support Case Number: 01176220
  • Fixed an issue where Oracle Probe 5.41 don't clear alerts after probe reboot. Support Case Number: 01351957
MD5 Checksum: b0591db001dbb6f9c3adb1ddb25965a8
SHA-1 Checksum: 1df02a7289c6087ab59f4965db99da797c91ca5c
GA 5.45
30.01.2020 5.42 Beta What's New: Added support for Oracle 18C RAC and 19c NON-RAC and RAC databases. Please note this version of probe is tested and supported on Windows platforms. Fixed Defects: Fixed an issue where Oracle probe configuration error for custom check points using Admin console. Support Case Number: 01337227 Fixed and issue where Oracle probe sent timeout error for custom query when the query takes more then 2 min using IM. Support Case Number:01176220 Fixed and issue where Oracle Probe 5.41 don't clear alerts after reboot the probe. Support Case Number:01351957 5.42
08.02.2019

What's New:

  • Added support for Oracle 12c R2 and 18c databases.
  • Added support for the use of stored procedures in creating custom checkpoints. For more information, see Custom Checkpoints.
  • New MCS template (oracle_mcs_template 5.33). Added an option allowing you to use the same value as specified in “Alarm Source” for the “Source” field of QoS messages. For more information, see Oracle MCS Profile Type Configuration.

Fixed Defects:

  • Fixed an issue where not all activated RAC checkpoints collect QoS event though this option is enabled in the RAC template. Support Case Number: 01169941
  • Fixed and issue where the probe was not able to monitor Oracle ASM diskgroups and other services. Support Case Number: 00985582

For Detailed Release Notes-Please refer

https://docops.ca.com/rest/ca/product/latest/topic?format=rendered&language=&space=UIMPGA&hid=oracle_RN

Note: Support case(s) may not be viewable to all

MD5 Checksum: 2504e2c3dee90deb31f52b6cd3f4d614
SHA-1 Checksum: 916a6c6a2d378cfd4279ba0145134a63e0983c17
5.41
27.10.2017

What's New:

Fixed Defects:

  • The settings updated in the checkpoints sections of Oracle did not reflect in the profile when configured from the Administration Console. Salesforce case number: 650309

For Detailed Release Notes-Please refer to

https://docops.ca.com/rest/ca/product/latest/topic?format=rendered&language=&space=UIMPGA&hid=oracle_RN

Note: Support case(s) may not be viewable to all

md5sum: 6e203f6d60045eb431b2e0db9892c8be
sha1sum: 760798f61b593ee670aa99efe3ba9785ce3bcb25
5.30
14.04.2017 What's New:
  • (Admin Console only) Added support to create custom checkpoints for RAC connections.
  • Added support to map checkpoint alarms to database instance name.
Fixed Defects:
  • For the RAC common tablespace_free checkpoint, the probe displayed multiple grids for both QoS and thresholds. Support case number 686906
  • On Linux systems, the probe crashed after you enabled all checkpoints and QoS for an ASM profile and saved the configuration. Support case number 621689
For Detailed Release Notes-Please refer to

https://docops.ca.com/rest/ca/product/latest/topic?format=rendered&language=&space=UIMPGA&hid=oracle_RN

Note: Support case(s) may not be viewable to all

md5sum: b8366b3282c0639108f072f1d147b35e
sha1sum: 3558872caea0b2d4a0d19359645cba2664b5f610
5.20
12.10.2016 What's New:
1. Added support to monitor Oracle Automatic Storage Management (ASM) on Oracle 11g and 12c databases for RAC and non-RAC systems.
2. Additionally, added support for the following properties of ASM:
(i) ASM Disk Count
(ii) ASM Disk Bytes Read
(iii) ASM Disk Bytes Write
(iv) ASM Disk Group Count
(v) ASM Disk Group Total Space
(vi) ASM Disk Group Used Space
(vii) ASM Disk Group Used Space Percentage
(viii) ASM Disk Read Request
(ix) ASM Disk Write Request
(x) ASM Disk Total Space
(xi) ASM Disk Used Space
(xii) ASM Disk Used Space Percentage
3. Added Blocking Session information in the lock_waits_4 alarm message.
4. Included Oracle error message when the listener is down in the check_dbalive checkpoint.

For Detailed Release Notes-Please refer
https://wiki.ca.com/rest/ca/product/latest/topic?format=rendered&language=&space=UIMPGA&hid=oracle_RN
5.10
22.07.2016 Fixed Defects:

1. (For RAC checkpoint in Admin Console) The probe did not generate alarms for the second threshold if the first threshold did not breach. Support case number 427677
2. The probe displayed the resource_util checkpoint data under separate two nodes on Unified Service Management (USM). For more information, see Known Issues. Support case number 348882
3. When monitoring oracle 12c on an AIX operating system, the probe created a core when the Oracle database was down. For more information, see oracle Troubleshooting. Support case number 300723
4. The probe did not save the configuration on editing or deleting a threshold from any checkpoint. Support case number 261392

For Detailed Release Notes-Please refer
https://wiki.ca.com/rest/ca/product/latest/topic?format=rendered&language=&space=UIMPGA&hid=oracle_RN
Note: Salesforce case(s) may not be viewable to all.
5.01
22.03.2016 What's New:
1. Added support to use the alarm source as the identification method in QoS messages.
2. Added feature to rename the existing connections and profiles in the probe Infrastructure Manager.

Fixed Defects:
1. The probe crashed when upgrading on an RHEL environment. Support case number 246083
2. The probe displayed a profile in suspended state as green (resumed) when you launched the probe in another Infrastructure Manager. Support case number 246864
3. Updated the Admin Console documentation for the default checkpoints that are added as static to a profile in the probe Admin Console. Support case number 260900
4. When deleting the default threshold for the invalid_objects checkpoint, the probe did not generate the count alarms. The probe only generated the default alarms. Support case number 275647
5. The probe did not generate any QoS for the locked_user checkpoint. Support case number 320807
For Detailed Release Notes-Please refer
https://wiki.ca.com/rest/ca/product/latest/topic?format=rendered&language=&space=UIMPGA&hid=oracle_RN
Note: Salesforce case(s) may not be viewable to all.
5.00
30.09.2015 Fixed Defects:
1. When creating a profile from Admin Console, all the checkpoints of the profile are now inactive, by default. Salesforce case: 00159509
2. When opening the probe in a deactivated state, the probe displayed incorrect upgrade message text. Salesforce case: 00160547
3. The probe displayed incorrect status of the activated checkpoints in the Status tab. Salesforce case: 00168455
4. When deploying the probe on a non-Windows OS, the probe now displays the Device ID of the monitored Oracle database. Salesforce case: 70002729

For Detailed Release Notes-Please refer
https://wiki.ca.com/rest/ca/product/latest/topic?format=rendered&language=&space=UIMPGA&hid=oracle_RN
Note: Salesforce case(s) may not be viewable to all.
4.91
15.06.2015 Added support for AIX 6 and 7 platform
For Detailed Release Notes-Please refer
https://wiki.ca.com/rest/ca/product/latest/topic?format=rendered&language=&space=UIMPGA&hid=oracle_RN
4.90
18.12.2014 Updated probe help link

For Detailed Release Notes- Please Refer
https://wiki.ca.com/rest/ca/product/latest/topic?format=rendered&language=&space=UIMPGA&hid=oracle_RN
4.81
28.11.2014 Added support for Oracle 12c Container Database(CDB) and Oracle 12c Pluggable Database(PDB)
Fixed a defect where Profile Timeouts were visible in alarm console even after probe connection was sucessful. The alarms didnt clear even if Clear Alarm on Restart checkbox was selected(Salesforce Case:00144941)


For Detailed Release Notes- Please Refer
http://docs.nimsoft.com/prodhelp/en_US/Probes/AdminConsole/logmon/ReleaseNotes/index.htm
Note:Salesforce case may not be viewable to all
4.80
21.10.2014 Fixed a defect where the Oracle probe GUI flickered on clicking the Profiles/Checkpoints in the Status tab. (Salesforce Case 00143137)

For Detailed Release Notes- Please Refer http://docs.nimsoft.com/prodhelp/en_US/Probes/AdminConsole/oracle/ReleaseNotes/index.htm
4.71
18.08.2014 Added support for Oracle 12c.
For Detailed Release Notes- Please Refer http://docs.nimsoft.com/prodhelp/en_US/Probes/AdminConsole/oracle/ReleaseNotes/index.htm
4.70
15.07.2014 Fixed Defects:
1.TNS alarms were visible in alarm console even after the probe connection was successful. The alarms did not clear even if user changes the connection and Clear Alarm on Restart check box was selected. (SalesForce Case ID: 00122633, 00132174, 00121391)
2. SQL timeout alarms were getting generated irrespective of checkpoint and had incorrect suppression key.
3. For table space that have autoext as Y, probe was calculating wrong value of FREESP variable. Due to this, the messages displayed incorrect values. (SalesForce Case ID: 00132777)
4. The probe package of 32-bit was getting installed on 64-bit AIX machine. (SalesForce Case ID: 00132673)
5. Instance name was not coming in the check_dbalive alarm message where connection was unsuccessful. (SalesForce Case ID: 00131416)
For Detailed Release Notes- Please Refer http://docs.nimsoft.com/prodhelp/en_US/Probes/AdminConsole/oracle/ReleaseNotes/index.htm
4.61
31.03.2014 New Feature
Implemented the Oracle RAC features including 20 new checkpoints for RAC.
Fixed a defect where global cache checkpoints are not returning any value for oracle 11.
Note: This feature and fixed defect are applicable only for oracle probe adapter
For Detailed Release Notes-Please refer
http://docs.nimsoft.com/prodhelp/en_US/Probes/AdminConsole/oracle/ReleaseNotes/index.htm
4.60
24.03.2014 Added a callback to check whether dependencies are present on the box where probe is deployed so that the probe can run successfully. 4.56
17.01.2014 Defect fixed related to the Oracle probe not displaying metrics for all tablespaces. The UMP was not displaying QoS as a chart in the metric tree for all Oracle native checkpoints. Defect fixed related to QOS_ORACLE_tablespace_alloc_free Pct and QOS_ORACLE_tablespace_free Percent checkpoints, generating alarms for each tablespace with almost identical values.
For Detailed Release Notes-Please refer
http://docs.nimsoft.com/prodhelp/en_US/Probes/AdminConsole/oracle/ReleaseNotes/index.htm
4.55
09.10.2013 Fixed the alarm source issue for profile timeout alarm 4.54
17.07.2013 Fixed the key and query for lock_waits checkpoint. 4.53
14.03.2013 Added Probe Defaults 4.52
10.01.2013 Fixed Profile shows template checkpoints if group is used. Fixed ORA-00923 and ORA-24333 error coming in locked_users and rollback_segments checkpoints for Oracle 11g profiles. Fixed misisng no_next_extents messages in the cfg file. Fixed Status Tab not showing current values of monitored checkpoints 4.51
12.06.2012 Fixed Incorrect alarm message in database_size checkpoint.
Added support for AIX 5.
Fixed issue with improper functionality of Suspend/Resume profile.
Changed default alarm message of redo_logs checkpoint.
Fixed issue of oracle probe crashing in solaris.
Added support to modify connection failure message.
Fixed the value of autoextend field in tablespace_alloc_free checkpoint.
Update the resource_util checkpoint query for the oracle bug "Incorrect (always increasing) values showed in v$resource_limit for the transactions field [ID 412314.1]".
Added support to skip DBA/SELECT_CATALOG_ROLE checking.
Fixed issue in checksum calculation during custom template creation.
Fixed issue of checkpoint threshold in profile, if the checkpoint is marked as static into the profile.
Fixed exceptions in Exclude test.
4.50
30.11.2011 Modified the Query for dataguard_gap checkpoint.
Suppression key (alarm key) & qos key is changed for dataguard_gap checkpoint, for upgrades from previous versions the QoS series for this checkpoint will break due to changes in the QoS target key.
New i18 tokens for dataguard gap are added.
4.43
31.08.2011 - Added support for oracle client 11.2 on SOLARIS Sparc.
- Fixed an issue occurring on unix platforms where multiple probe executables were getting spawned instead of a single executable.
4.42
20.06.2011
  • While creating a custom checkpoint $instance variable will now be visible in Variable Window.<\li>
  • Custom checkpoint can now be updates when opened through Status Tab.<\li>
  • Fixed the issue of sending null QOS for dict_cachehit_ratio<\li>
  • Supports oracle client 11.2 for Linux 32 & 64 bit machines.<\li>
  • This version does not support oracle client 11.2 for solaris sparc machine.<\li>
  • Fixed Memory Leak issue <\li>
  • Fixed an issue in tablespace_free checkpoint where the probe was incorrectly calculating free tablespace % for temp tablespaces.<\li>
  • Fixed one more issue in the tablespace_free checkpoint where the free tablespace calculation was incorrect.<\li>
  • Internationalization corrections. <\li>
  • 4.41
    30.09.2010 Added support to set negative values as threshold.
    Added validation if custom query is blank.
    Added code to fetch query from file in edit mode.
    Fixed other minor GUI issues related to custom checkpoint.
    Added field in custom query tab to select predefined connections.
    Added support for role based login.
    Added support for alarms.cfg .
    Added functionality for delta calculation in custom checkpoint.
    Added code to prohibit the use of whitespace in configurator.
    Added support to check if the user has enough rights to run the query.
    Removed validation of adding at least one threshold while creating new checkpoint.
    Fixed GUI crash defects.
    Fixed defect to return valid checksum after restart for Custom query.
    Fixed defect for metric remaining_extents takes way too long to complete.
    Fixed defect; so, correct binary is deployed in 64 bit Linux.
    Fixed defects in v4 framework library.
    4.31
    30.06.2010 Added support for extended NIS database information.
    Fixed an issue where the probe was reporting incorrect values in the GUI.
    4.20
    31.03.2010 Fixed a crash in the probe by applying fix to v4 helper library.
    Fixed defect related to tablespace_free checkpoint.
    4.11
    31.03.2010 Added a new checkpoint active_connection_ratio for monitoring percentage of active connections to total available connections. 4.10
    29.01.2010 Fixed an issue in the database size checkpoint where total database size was reported incorrectly. 4.04
    15.01.2010 Fixed defects in few checkpoint variables and alarms.
    Added fix for memory leak.
    Added fix for SQL query timeout.
    4.03
    18.12.2009 Fixed defect in GUI.
    Fixed defects in few checkpoint variables.
    Probe now sends NULL QoS for all the QoS defined in the QoS list if no data is received.
    4.02
    11.09.2008 Configuration for no_next_extent, invalid_objects and tablespace_deficit corrected.


    Known issue
    The Oracle RAC system statistics used for 'gc_' checkpoints are, starting with Oracle 10.1 no more available. Therefore these checkpoints will return no value if activated.
    3.91
    11.07.2008 Added Support for Solaris.

    Added numbers of objects alarm for these checkpoints.
    - no_next_extent
    - invalid objects
    - tablespace deficits

    WARNING!! Profiles with these checkpoints need to be removed and recreated, because of new functionality.

    Hotfix for Locking users
    3.90
    05.03.2008 Note: While the package contains Solaris binaries, Solaris is not a supported platform at this time. Installation of this probe on Solaris is not recommended.

    Hotfix for Checkpoint Invalid Objects
    3.75
    14.02.2008 Memory leak corrected 3.74
    17.01.2008 Added new NimBUS libraries 3.73
    20.12.2007 Removed support for Oracle 8.0.x. 3.71
    23.11.2007 Corrected minor problems with filters
    Added support for Oracle 11g
    3.70
    16.11.2007 Crash in some checkpoints if instance not available fixed
    QoS error with session_waits fixed
    Error with profiles containing "." fixed
    Problem with sga_memory_free - objects containing ":" fixed
    Queries for Oracle 10g do not try to use rules based optimizer any more
    3.64
    27.07.2007 QoS errors fixed
    Problem in period setting (scheduling) corrected
    One-time run error (scheduling) fixed
    Profile timeout suppression key corrected
    Calculation of free space for temporary and undo-tablespaces corrected
    buf_cachehit_ratio problem fixed
    3.62
    15.06.2007 multiple QoS per checkpoint
    exclude lists
    # of samples for alarming
    new checkpoint long_queries
    auto-update (GUI)
    new checkpoint tablespace_size
    new checkpoint database_size
    new parameter log-size
    new parameter "Alarm Source"
    buf_cache_hit_ratio query adjusted for Oracle 10.2
    3.60
    10.01.2007 A clear is only issued if an alarm has been sent. 3.53
    08.12.2006 High CPU load for gc_ checkpoints in Oracle 8 solved
    Negative values in sort_ratio problem solved
    datafile_status problem with SYSTEM tablespaces solved (v$datafile_header now used instead of v$datafile)
    datafile_status and dbfile_io object threashold saving on UNIX systems problem solved
    tablespace_alloc_free - query changed
    3.52
    25.08.2006 Internal – Config file template added
    LINUX built with Oracle 10 libaries
    3.50
    14.07.2006 "tablespace_free" calculation for multi-file tablespaces corrected. 3.05
    02.06.2006 Linux enabled
    Remaining_extents - problem with 'UNKNOWN' values fixed
    QoS time corrected
    buf_cache_hitratio fixed
    checkpoint execution time report
    Interval value calculation corrected
    QoS source name corrected to robot name
    'invalid_objects' supression key corrected
    new 'buf_cachehit_ratio' formula
    Multithreading - every profile runs in a separate thread
    Scheduling - every checkpoint can have its own schedule
    Multiple thresholds - every checkpoint can have more than one threshold
    Message pool - messages can be customized and reused among checkpoints
    Connection retry - for every connection there can be number of attempts defined, before the probe raise an alarm
    Resizable GUI windows - all wndows with lists are resizable
    3.04
    03.03.2006 Instance name at "locked_users" checkpoint message
    Added Linux support for package.
    2.17
    30.11.2005 Instance name at "locked_users" checkpoint message
    Linux support fix
    2.16
    21.03.2005 10g tolerancy
    new checkpoint lock_waits
    user_locks and locked_users changed
    error in buf_cachehit_ratio_users fixed
    check for % in password removed
    start paramater -n to change probes name
    keeping time_cnt through restart (24hour cycle)
    GUI - new buttom "info" to display GUI and executable version numbers
    2.12
    Requirements
    Platform: Please refer to the Platform Support Matrix located in the Download section of http://support.nimsoft.com
    Software: Windows: Oracle Client (Net Services) 11.x,12.x
    Linux and Solaris: Oracle Client 11.x,12.x
    Nimsoft Robot version 3.00 or higher
    Hardware: None