OBIEE 11G - Log Files (Oracle Diagnostic Logging - ODL)
Table of Contents
About
Access and configuration of the log files is centralized on the diagnostics tab of the BI coreapplication in the FMW Control web interface with the help of ODL (Oracle Diagnostic Logging is a centralized framework for logging).
Articles Related
Management
Log Viewer
To access the Log Viewer, click on the log viewer link. This viewer is the viewer of WLDF. See WebLogic - Diagnostics Framework (WLDF)
Execution Context ID (ECID)
When log entries for error messages and warnings are generated across multiple log files, they can be difficult to trace. However, it is possible to view logging information for specific user transactions across multiple log files. Transaction level logging associates a unique transaction ID, which is called the Execution Context ID (ECID)
Diagnostic log files
Diagnostic log files are files used to store message information that is generated by Oracle Business Intelligence servers.
These log files are stored in the following location:
ORACLE_INSTANCE\diagnostics\logs\component_type\coreapplication
where component type is one of the following:
The following diagnostic log files are used in Oracle Business Intelligence:
Where <n> = date and timestamp for example 20101209-2135
| Component | Log Files | Description | Searchable in Log Viewer |
|---|---|---|---|
| Presentation Services | \CatalogCrawler\sawcatalogcrawlerlogsysn.log | The catalog crawler log file | No |
| Presentation Services | sawlogn.log | The Presentation Services log file that represents the latest part of diagnostic log output | Yes |
| Oracle BI Server | nqquery<n>.log | The Oracle BI Server query log | No |
| Oracle BI Server | nqserver<n>.log | The Oracle BI Server main diagnostic log | Yes |
| Oracle BI Administration Tool | nqsadmintool.log | The log for the Oracle BI Administration Tool | ? |
| JavaHost | jh-n.log | The JavaHost Server main diagnostic log | Yes |
| Oracle BI Scheduler | nqscheduler-<n>.log and Agent-<n>.log | The Oracle BI Scheduler log file | Yes |
| Cluster Controller | nqcluster-yyyyMMdd-hhmm.log | The Oracle BI Cluster Controller diagnostic file | Yes |
| Action Services and Security Services | AdminServer-diagnostic.log | BI JEE log | Yes |
| Action Services and Security Services | bi_server1-diagnostic.log | BI JEE log | Yes |
Oracle BI Server utilities - For example, biserverxmlexec and equalizerpds, also generate their own logs when they are run.
| NQSUDMLExec.log | ORACLE_INSTANCE\diagnostics\logs\OracleBIServerComponent/coreapplication_obis1 |
| obieerpdmigrateutil.log (Migration log) | ORACLE_INSTANCE\diagnostics/logs/OracleBIServerComponent/coreapplication_obis1 |
| webcatupgrade.log (Web Catalog Upgrade) | ORACLE_INSTANCE\diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1 |
| ODBC.log | ORACLE_INSTANCE\diagnostics/logs/OracleBIODBCComponent/coreapplication_obips1 |
| Upgrade Assistant log | FMW_HOME\Oracle_BI1/upgrade/logs |