Sunday, February 17, 2019

ASM alert log file location

Dear All,

In Unix the location of central inventory (oraInventory) can be found from the oraInst.loc file, which exists in the /var/opt/oracle or /etc/ (By default).

 

[oracle@database etc]$ pwd

/etc

[oracle@etc]$ cat oraInst.loc

#Oracle Installer Location File Location

 

inst_group=oracle

inventory_loc=/etc/oraInventory

 

Here, the inventory_loc is ‘/etc/oraInventory’

 

The log files are below:

 

/logs/InstallActions.log

/logs/oraInstall.out

/logs/oraInstall.err

/logs/silentInstall.log   (only for Silent installations)

 

For 10.2.0.X.X to 11.2.0.X.X only

 

/cfgtoollogs/oui/InstallActions.log

/cfgtoollogs/oui/oraInstall.out

/cfgtoollogs/oui/oraInstall.err

/cfgtoollogs/oui/silentInstall.log   (only for Silent installations)

 

2. Database alert log: Database Alter log are files, where every database related activities are recorded like instance start, stop, redo log switching, ORA error etc.

 

A DBA need to check this file for two reasons.

 

    a. To check health of Database.

b. Check details of any error in Database.

 

In Oracle 11g Default path for Alter log files is

 

$ORACLE_BASE/diag/rdbms/{DBNAME}/{sid}/trace/alert_{sid}.log

 

Ex: /u01/app/oracle/diag/rdbms/db01/db001/trace/alert_db001.log

 

In Oracle 10g Environment, use below command to find path for alter log files.

 

SQL> show parameter background_dump_dest

 

NAME                                 TYPE        VALUE

———————————— ———– ——————————

background_dump_dest                 string      /etc/oracle/diag/rdbms/testdb/testdb/trace

 

3. Automatic Storage Management alert log files: ASM is used for providing redundancy and balancing data and load across different disks. Any issue related to ASM below is the path for alter log files (Oracle 11g).

 

$ORACLE_BASE/diag/asm/+asm/+ASM{instance number}/trace/ alert_+ASM {instance number}.log

Ex: /u01/app/oracle/diag/asm/+asm/+ASM2/trace/alert_+ASM2.log

 

4. Clusterware CRS alert log: Real application Cluster is used for high availability and work load distribution among diff-2 servers. To check health of cluster and trouble shooting below is path for alter log file.

 

The following sections describe the locations of the clusterware log files in Database Software Oracle 10g Release 1.

 

Cluster Ready Services Log Files

Cluster Ready Services (CRS) has daemon processes that generate log information. Log files for the CRS daemon (crsd) can be found in the following directories:

 

/crs/init

/crs/.log

 

Oracle Cluster Registry Log Files

The Oracle Cluster Registry (OCR) records log information in the following location:

 

/srvm/log/

 

Cluster Synchronization Services (CSS) Log Files

You can find CSS information that the OCSSD generates in log files in the following locations:

 

/css/log/ocssd.log

/css/init/.log

 

Event Manager Log Files

Event Manager (EVM) information generated by evmd is recorded in log files in the following locations:

 

/evm/log/evmdaemon.log

/evm/init/.log

 

Oracle High Availability Log Files

The Oracle RAC high availability trace files are located in:

 

$ORACLE_BASE//admin/hdump

 

Where $ORACLE_BASE is configured and $ORACLE_HOME/racg/log when $ORACLE_BASE is not available.

 

In Oracle 11g Release 1 onwards logs can be found at this location.

 

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

Ex: /u01/app/11.2.0/grid/log/db02/alertdb02.log

 

5. Diskmon log files : Disk mon log are basically to check any issue with the disk in the system.

 

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

Ex: /u01/app/11.2.0/grid/log/dmorldb02/diskmon/diskmon.log

6. OS Watcher output files : OS watcher logs are helpful for remote DBA when Database Server is hang or reboot automatically. Below is path for Linux/Unix env.

 

/opt/oracle.oswatcher/osw/archive/

 

To get OS watcher data of specific date :

cd /opt/oracle.oswatcher/osw/archive

find . -name ‘*12.01.13*’ -print -exec zip /tmp/osw_`hostname`.zip {} \;

where 12- year 01- Month 13-day

 

7. Os message logfile: OS message log file are logs related to OS related messages. Path for Linux/Unix syatem is below.

 

/var/log/messages

No comments:

Post a Comment