This discussion is archived
3 Replies Latest reply: Feb 11, 2013 3:07 AM by 603257 RSS

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

913367 Newbie
Currently Being Moderated
Hi,
I wish to know the Location of query log files in OBIEE 11g (version 11.1.1.5)??
  • 1. Re: Location of query log files in OBIEE 11g (version 11.1.1.5)
    AmithY Expert
    Currently Being Moderated
    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.
  • 2. Re: Location of query log files in OBIEE 11g (version 11.1.1.5)
    MuRam Expert
    Currently Being Moderated
    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
  • 3. Re: Location of query log files in OBIEE 11g (version 11.1.1.5)
    603257 Journeyer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points