1.PURPOSE AND SCOPE
Finding the location of Alert log, ASM Alert log, Cluster log and OS logs
2.PRACTICE
2.1 Finding location of Alert log.
2.1.1 Need to connect sqlplus and check the parameter of background_dump_dest.
# sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 21 09:53:17 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SQL> show parameter background NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ background_dump_dest string /u01/app/oracle/diag/rdbms/stdby/stdby/trace
2.1.2 And our alert log is in that location
#ls /u01/app/oracle/diag/rdbms/stdby/stdby/trace/a*.log -rw-r----- 1 oracle dba 5006 Aug 21 09:08 /u01/app/oracle/diag/rdbms/stdby/stdby/trace/alert_AA.log
2.2 Finding the ASM Alert log location
2.2.1 To connect ASM instance we need to change our ORACLE_SID.If our enviroment is cluster we need to set it like +ASM1 or +ASM2 etc.. it depends on node number.
#export ORACLE_SID=+ASM
2.2.2 Need to connect sqlplus and check the parameter of background_dump_dest .
# sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 21 09:53:17 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SQL> show parameter background NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ background_dump_dest string /u01/app/oracle/product/11.1.0/db_1/rdbms/asm/+asm/log/
2.2.3 And our alert log is in that location
#ls /u01/app/oracle/product/11.1.0/db_1/rdbms/asm/+asm/log/a*.log -rw-r----- 1 oracle dba 5006 Aug 21 09:08 /u01/app/oracle/product/11.1.0/db_1/rdbms/asm/+asm/log/alert_ASM.log
2.3 Location of Cluster logs
2.3.1 First we need to check is our Cluster home enviroment setted or not.
echo $ORA_CRS_HOME /u01/oracle/product/crs/
2.3.2 And we can reach Cluster logs with this command
ls $ORAC_CRS_HOME/log/aler*
2.4 Os log locationSistem log lokasyonu
2.4.1 It would be much better to connect OS with root acc.
vi /var/log/dmesg
or
dmesg | less