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.