Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Location of query log files in OBIEE 11g (version 11.1.1.5)

913367Mar 4 2012 — edited Feb 11 2013
Hi,
I wish to know the Location of query log files in OBIEE 11g (version 11.1.1.5)??

Comments

Amith Y
Hi There,

If you are asking for the log files where the logical and physical queires of the analysis queries are stored, then it is called nqquery.log and the location path's are below:

10g: BI_ORACLE_HOME/server/Log
11g: ORACLE_INSTANCE/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

Regards,
-Amith.
MuRam
Hi,

Log Files in OBIEE 11g

Login to the URL http://server.domain:7001/em and navigate to:
Farm_bifoundation_domain-> Business Intelligence-> coreapplications-> Dagnostics-> Log Messages

You will find the available files:

Presentation Services Log

Server Log

Scheduler Log

JavaHost Log

Cluster Controller Log

Action Services Log

Security Services Log

Administrator Services Log

However, you can also review them directly on the hard disk.

The log files for OBIEE components are under <OBIEE_HOME>/instances/instance1/diagnostics/logs.

Specific log files and their location is defined in the following table:
Log Location
Installation log <OBIEE_HOME>/logs

nqquery log <OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

nqserver log <OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

servername_NQSAdminTool log <OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

servername_NQSUDMLExec log <OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

servername_obieerpdmigrateutil log (Migration log) <OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

sawlog0 log (presentation) <OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1

jh log (Java Host) <OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIJavaHostComponent\coreapplication_obijh

webcatupgrade log (Web Catalog Upgrade) <OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1

nqscheduler log (Agents) <OBIEE_HOME>/instances/instance1/diagnostics/logsOracleBISchedulerComponent/coreapplication_obisch1

nqcluster log <OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIClusterControllerComponent\coreapplication_obiccs1

ODBC log <OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIODBCComponent/coreapplication_obips1

opmn log <OBIEE_HOME>/instances/instance1/diagnostics/logs/OPMN/opmn

debug log <OBIEE_HOME>/instances/instance1/diagnostics/logs/OPMN/opmn

logquery log <OBIEE_HOME>/instances/instance1/diagnostics/logs/OPMN/opmn

service log <OBIEE_HOME>/instances/instance1/diagnostics/logs/OPMN/opmn

opmn out <OBIEE_HOME>/instances/instance1/diagnostics/logs/OPMN/opmn

Upgrade Assistant log <OBIEE_HOME>Oracle_BI1/upgrade/logs

Regards
MuRam
YourNameHere
Hi,
Are these log files also applicable to 11.1.1.6.2?
Also, do you know the best place to find further information on each of these log files, what they are used for, purge/rotation cycles etc?

Thanks
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 11 2013
Added on Mar 4 2012
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
3 comments
18,001 views