Friday 24 July 2020

Locate Oracle Clusterware log files

crs log/grid log/clusterwar log location/cluster alert log location in 11g,12c and 18c


Clusterware Log Location Change in 12.1.0.2
cd $ORACLE_BASE/diag/crs/<node_name>/crs/trace
eg
cd /u02/oracle/NFT/diag/crs/<node_name>/crs/trace

same location in Version 18.10.0.0.0

cd $ORACLE_BASE/diag/crs/<node_name>/crs/trace
eg
cd /u02/oracle/NFT/diag/crs/<node_name>/crs/trace


log location for grid /clusterware

eg

[oracrs@Node1 trace]$
[oracrs@Node1 trace]$ pwd
/u02/oracle/prod/diag/crs/Node1/crs/trace
[oracrs@Node1 trace]$

Clusterware/Grid log location for version 11.2.0.4.0

cd $ORACLE_HOME/log/Node1
/u02/oracle/11.2.0.4/grid/log/<Node Name>

[oracrs@Node1 Node1]$
[oracrs@Node1 Node1]$ pwd
/u02/oracle/11.2.0.4/grid/log/Node1
[oracrs@Node1 Node1]$ echo $ORACLE_HOME
/u02/oracle/11.2.0.4/grid
[oracrs@Node1 Node1]$


oracrs@Node1 Node1]$ ls -ltr
total 3276
drwxr-x--- 2 oracrs dba 4096 Jan 31 2017 srvm
drwxr-x--- 2 root dba 4096 Jan 31 2017 gnsd
drwxr-x--- 2 oracrs dba 4096 Jan 31 2017 diskmon
drwxr-x--- 4 oracrs dba 4096 Jan 31 2017 cvu
drwxr-xr-x 2 root dba 4096 Jan 31 2017 acfssec
drwxr-x--- 2 oracrs dba 4096 Jan 31 2017 acfsrepl
drwxr-x--- 2 oracrs dba 4096 Jan 31 2017 acfslog
drwxrwxr-t 4 root dba 4096 Jan 31 2017 agent
drwxr-x--- 2 oracrs dba 4096 Jan 31 2017 admin
drwxr-x--- 2 root dba 4096 Jan 31 2017 acfsreplroot
drwxr-xr-x 3 root root 4096 Jan 31 2017 acfs
drwxr-x--- 2 oracrs dba 4096 Jan 31 2017 mdnsd
drwxr-x--- 2 oracrs dba 4096 Jan 31 2017 evmd
drwxrwxr-t 5 oracrs dba 4096 Feb 10 2017 racg
drwxr-x--- 2 root dba 4096 Mar 20 2017 crflogd
drwxr-x--- 2 root dba 4096 Jul 20 21:31 crsd
drwxr-x--- 2 root dba 4096 Jul 21 11:26 ohasd
drwxr-x--- 2 oracrs dba 4096 Jul 21 11:26 gpnpd
drwxr-x--- 2 oracrs dba 4096 Jul 22 19:26 cssd
drwxrwxrwt 2 oracrs dba 12288 Jul 23 18:15 client
drwxr-x--- 2 root dba 4096 Jul 23 22:24 ctssd
drwxr-x--- 2 root dba 4096 Jul 24 03:50 crfmond
drwxr-x--- 2 oracrs dba 4096 Jul 24 07:12 gipcd
-rw-rw-r-- 1 oracrs dba 3244917 Jul 24 10:58 alertNode1.log
[oracrs@Node1port1018ovl]$ pwd
/u02/oracle/11.2.0.4/grid/log/Node1



1) Cluster logs ---> $ORACLE_BASE/diag/crs/<HOSTNAME>/crs/trace/


Can you collect ALL logs manually from the below location?. Kindly zip and upload it.

++ /u02/oracle/PRD/diag/crs/Node1/crs/trace/
++ OS log

Collect CRS logs from other nodes as well.


OS logs provided was from 1-May where as issue datea was on 19-April around 2:20

Please upload the OS logs for 19-April , AS discussed you have issue in TFA install/usage timely you can collect the below ZIP and upload from EACH node

1) Cluster logs ---> $ORACLE_BASE/diag/crs/<HOSTNAME>/crs/trace/

lsinventory from GRID and RDBMS instances

2 ) RDBMS traces
--------------
${ORACLE_BASE}/diag/rdbms/$DBNAME/${ORACLE_SID}/trace and ${ORACLE_BASE}/diag/rdbms/$DBNAME/${ORACLE_SID}/trace

3) ASM traces
------------
${ORACLE_BASE}/diag/asm/+asm/+ASMn/trace and ${ORACLE_BASE}/diag/asm/+asm/+ASMn/trace

4) OS logs of 19 April

AIX /bin/errpt -a > /tmp/error_$hostname.log Command needs to be run as root upload logfile generated in /tmp/

No comments:

Post a Comment