Exadata · Oracle

Where is my logfile ?

A brief summary of “Location of Different Logfiles in Exadata Environment (Doc ID 1326382.1)”

------CELL nodes
Cell alert.log file
	/opt/oracle/cell/log/diag/asm/cell/{node name}/trace/alert.log

MS logfile & trace 
	/opt/oracle/cell/log/diag/asm/cell/{node name}/trace/ms-odl.log
	/opt/oracle/cell/log/diag/asm/cell/{node name}/trace/ms-odl.trc

------DATABASE nodes	
Database alert.log 
	$ORACLE_BASE/diag/rdbms/{DBNAME}/{sid}/trace/alert_{sid}.log

ASM alert.log
	$ORACLE_BASE/diag/asm/+asm/+ASM{inst}/trace/alert_+ASM{inst}.log

Clusterware CRS alert.log
	$GRID_HOME/log/{node name}/alert{node name}.log 

Diskmon logfiles
	$GRID_HOME/log/{node name}/diskmon/diskmon.lo*

------OS General
OS Watcher 
	/opt/oracle.oswatcher/osw/archive/
	bzip2 -d  *dat.bz2

OS log file 
	/var/log/messages

Login logs 
	/var/log/secure
	[root@host]# last oracle	

Kernel messages	
	[root@host]# dmesg
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s