Monday, 30 December 2013

OBIEE 11g – Important Log Files & Log File Locations List


This blog is an attempt to answer questions around important log files for OBIEE 11g, log file locations and location example. What are more fascinating for me are more and more questions around max size and rotation policy of log files which I will cover in subsequent blogs.

OBIEE 11g Log Files

OBIEE 11g log files, log location and location example are listed as below. I have copied this information from Oracle Support web.

Troubleshooting Usage
Log Name
Log Location/ Location Example

Install\De-install\Patch



Examples:
deinstall2010-08-15_09-01-33PM.out
deinstall2010-08-15_09-01-33PM.log
installProfile2010-08-15_09-01-33PM.log
oraInstall2010-08-15_09-01-33PM.out
oraInstall2010-08-19_01-21-49AM.err
OPatch2010-08-19_02-15-05-AM.log
2010-08-19_01-21-49AM.log
installProfile2010-08-19_01-21-49AM.log

Linux and UNIX: USER_HOME/oraInventory/logs/

Windows: C:\Program Files\Oracle\Inventory\logs\

Location Example

C:\Program Files\Oracle\Inventory\logs

Startup\Shutdown\Execution


WLS Admin Server
AdminServer.log
bifoundation_domain.log
AdminServer-diagnostic.log(BI JEE log (Action Services and Security Services), - review in FMC)
access.log
logs\bipublisher \bipublisher.log  ?????

<Middleware_HOME>\user_projects\domains\bifoundation_domain\servers\AdminServer\logs

Location Example

C:\OBIEE11G\user_projects\domains\bifoundation_domain\servers\AdminServer\logs
WLS Managed Server
bi_server1.log
bi_server1.out
bi_server1.out00001 etc
bi_server1-diagnostic.log (BI JEE log (Action Services and Security Services), - review in FMC)
access.log
logs\bipublisher \bipublisher.log  ?????

<Middleware_HOME>\user_projects\domains\bifoundation_domain\servers\bi_server1\logs

Location Example C:\OBIEE11G\user_projects\domains\bifoundation_domain\servers\bi_server1\logs
BI System Components (BI instance)








OracleBIServerComponent
nqserver.log
Nqquery.log
Administrator_NQSAdminTool.log
Administrator_nQUDMLExec.log

(For detailed info  : See System Administrator's Guide for Oracle Business Intelligence Enterprise Edition, 8.2 Understanding Diagnostic Log and Log Configuration Files)

<ORACLE_INSTANCE>\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1\

Location Example
C:\OBIEE11G\instances\instance2\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1\

OracleBIPresentationServicesComponent
sawlog0.log
webcatupgrade0.log
\catalogcrawler\
sawcatalogcrawlerlogsys0.log

<ORACLE_INSTANCE>\diagnostics\logs\ OracleBIPresentationServicesComponent \coreapplication_obips1\

Location Example

C:\OBIEE11G\instances\instance2\diagnostics\logs\OracleBIPresentationServicesComponent\coreapplication_obips1\

OracleBISchedulerComponent
nqscheduler-<n>.log
<ORACLE_INSTANCE>\diagnostics\logs\OracleBISchedulerComponent\coreapplication_obisch1

Location Example
C:\OBIEE11G\instances\instance2\diagnostics\logs\OracleBISchedulerComponent\coreapplication_obisch1
OracleBIJavaHostComponent
Jh.log
Jh-n.log

<ORACLE_INSTANCE>\diagnostics\logs\ OracleBIJavaHostComponent\coreapplication_obijh1\

Location Example
C:\OBIEE11G\instances\instance2\diagnostics\logs\OracleBIJavaHostComponent\coreapplication_obijh1\


OracleBIClusterControllerComponent
Nqcluster-<n>.log

<ORACLE_INSTANCE>\diagnostics\logs\ OracleBIClusterControllerComponent\coreapplication_obiccs1\

Location Example
C:\OBIEE11G\instances\instance2\diagnostics\logs\OracleBIClusterControllerComponent\coreapplication_obiccs1\

OPMN

DeBug.log
Opmn.log
Service.log etc

C:\OBIEE11G\instances\instance2\diagnostics\logs\OPMN\opmn

Troubleshooting Java Components


As above plus


EmbeddedLDAP (can be used in conjunction with the access.logs, as above
EmbeddedLDAP.log
EmbeddedLDAPAccess.log
DOMAIN_HOME/servers/server_name/data/ldap/log/EmbeddedLDAP.log DOMAIN_HOME/servers/server_name/data/ldap/log/

Location Example
C:\OBIEE11G\user_projects\domains\bifoundation_domain\servers\bi_server1\data\ldap\log\EmbeddedLDAP*.log

Miscellaneous


Repository log
<Repository Name> .rpd.log

<ORACLE_INSTANCE>\OracleBIServerComponent\coreapplication_obis1\repository\

Location Example

C:\OBIEE11G\instances\instance2\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository\SampleAppLite.rpd.Log

Upgrade
ua<timestamp>.log
BI_ORACLE_HOME\upgrade\logs
Usage Tracking (Only if redirected to logs)
NQAcct.yyyymmdd.hhmmss.log
STORAGE_DIRECTORY parameter in the Usage Tracking section of the
NQSConfig.INI file determines the location of usage tracking log files
BI Agent Log
Agent-JobID-InstanceID.xxx
The default location for log files is the Log directory in the Oracle Business
Intelligence installation directory on the computer where the Oracle BI Scheduler is
installed.

No comments:

Post a Comment