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.
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.
The Oracle Database Insight Pack is installed using the pkg_mgmt utility. Reference the Readme Documentation for full installation and un-installation instructions.
- Upload the Oracle Database Insight Pack archive file to the system running IBM Operations Analytics – Log Analysis.
- Install the Oracle Database Insight Pack using pkg_mgmt.sh.
- Use the pkg_mgmt.sh command to determine the location of the insight pack.
- Create the data source for the Oracle Database Insight Pack.
- Create the out-of-the-box saved searches for the Oracle Database Insight Pack.
- Files with long log records require adjustments to the Java stack size so that they can be ingested.
- If you update the -Xss value parameter within the jvm.options file, you must restart the IBM Operations Analytics – Log Analysis system.
- Configuring Logstash with the provided Logstash configuration file allows Oracle Database events to be forwarded to IBM Operations Analytics – Log Analysis.
Review the following video for information on using and setting up the Insight Pack.
IBM Operations Analytics-Log Analysis Insight Packs for Applications- Standard Install License.
Cost: License Fee
- IBM Operations Analytics â€“ Log Analysis 1.3.0, 1.3.1, 1.3.2, 1.3.3.x, 18.104.22.168
- 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.
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.