How To Browse OEG Traffic Monitor Database Using SQLiteBrowser Or SQLiteEstudio ? (Doc ID 1900338.1)

Last updated on JULY 08, 2016

Applies to:

Oracle API Gateway - Version 11.1.1.6.1 to 11.1.2 [Release 11gR1 to 11gR2]
Information in this document applies to any platform.

Goal

There is the need to browse the data in directory /usr/oracle/Oracle/oeg/enterprisegateway/conf/opsdb.d.
Can a database browser such as SQLiteBrowser be used to view the tables in this "database"?
<Document: 1555515.1> OEG Traffic Monitor Does Not Work And The Trace File Has The "FATAL ...... SQLITE_BUSY: executing COMMIT" Error Reported indicates that SQLLiteBrowser can be used to view the tables.
When trying this, the database could not be open because SQLLiteBrowser looks for the *.db file which does not exist in directory /usr/oracle/Oracle/oeg/enterprisegateway/conf/opsdb.d.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms