Oracle Database Insight Pack

Posted: June 11, 2015 Modified: October 24, 2017


Overview

The Oracle Database Insight pack provides the capability to index and search against Oracle Database log files in IBM Operations Analytics – Log Analysis, in conjunction with Logstash to enable faster problem identification in Oracle DB Alert-related problems.

Oracle database log analysis content results
Oracle database log analysis content results

The Oracle Database Insight Pack supports logs from the following:

  • Oracle Database 11g Release 2
  • Oracle Database 12c Release 1

The Oracle Database Insight Pack supports searching and indexing of the following:

  • Oracle Database alert logs

Insight Pack Dashboard

Use the Oracle Database Insight Pack dashboards to find Oracle DB Alert-related problems in the shortest time, and drill down into the problem to identify the root cause. The Oracle Database Insight Pack app contains the following dashboards:

Oracle DB Alert Volume Over Time Dashboard
Plots line charts showing log record volume by hour, day, and month.

Oracle DB Information Links!
Lists hyperlinks to Oracle Database documentation, support and troubleshooting resources.

Additional information

The Oracle Database Insight Pack is installed using the pkg_mgmt utility. Reference the Readme Documentation for full installation and un-installation instructions.

Setup steps

  1. Upload the Oracle Database Insight Pack archive file to the system running IBM Operations Analytics – Log Analysis.
  2. Install the Oracle Database Insight Pack using pkg_mgmt.sh.
  3. Use the pkg_mgmt.sh command to determine the location of the insight pack.
  4. Create the data source for the Oracle Database Insight Pack.
  5. Create the out-of-the-box saved searches for the Oracle Database Insight Pack.

Considerations

  1. Files with long log records require adjustments to the Java stack size so that they can be ingested.
  2. If you update the -Xss value parameter within the jvm.options file, you must restart the IBM Operations Analytics – Log Analysis system.
  3. Configuring Logstash with the provided Logstash configuration file allows Oracle Database events to be forwarded to IBM Operations Analytics – Log Analysis.

Training Information

Review the following video for information on using and setting up the Insight Pack.

Training and overview presentation used in the training video.

View US Price & Buy

IBM Operations Analytics-Log Analysis Insight Packs for Applications- Standard Install License.

Updated: 22 April 2016
Version: 1.1.0.0
Cost: License Fee
Support: Supported

Resources

Product Information
Product Documentation
Documentation
Forum

Requirements

  • IBM Operations Analytics – Log Analysis 1.3.0, 1.3.1, 1.3.2, 1.3.3.x, 1.3.5.1
  • Logstash 1.4.2, 1.5.3, 2.2.1
  • Oracle Database 11g R2 or 12c R1
  • Purchased “IBM Operations Analytics-Log Analysis Insight Packs for Applications – Standard 1.1” License for each installed Insight Pack.

Support

This package is subject to the License terms included with the Insight Pack, along with those displayed upon download.

To report a problem with deploying this entry, entitled customers may contact the country specific IBM support channel, reference the IBM Worldwide Directory. Also use the “Support” link to access the support site for IBM Operations Analytics – Log Analysis information.