Archives for June 2010

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

[Read more…]