Exadata · Oracle

When is the last time you changed a flashdisk or harddisk on Exadata ?

Why is this question is important for a DBA ? Actually the results are pretty surprising when you execute the query and see the last inserted date of a harddisk or a flashdisk. In another way, that information shows you the time you changed a faulty harddisk or flashdisk on the exadata. If you deleted… Continue reading When is the last time you changed a flashdisk or harddisk on Exadata ?

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… Continue reading Where is my logfile ?