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
