Disclaimer

Tuesday 21 December 2021

Oracle 19c RAC - Alert log file location

 [grid@rac1.samik.com trace]$ . oraenv
ORACLE_SID = [+ASM1] ?
The Oracle base remains unchanged with value /applications/oracle/g19.3.0/gridbase




[grid@rac1.samik.com trace]$ adrci

ADRCI: Release 19.0.0.0.0 - Production on Tue Dec 21 13:24:32 2021

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/applications/oracle/g19.3.0/gridbase" 
 

adrci>
adrci> show alert

Choose the home from which to view the alert log:

1: diag/kfod/rac1.samik.com/kfod
2: diag/clients/user_grid/host_3869097132_110
3: diag/clients/user_root/host_3869097132_110
4: diag/crs/rac1.samik.com/crs
5: diag/tnslsnr/rac1.samik.com/listener_scan3
6: diag/tnslsnr/rac1.samik.com/listener
7: diag/tnslsnr/rac1.samik.com/asmnet1lsnr_asm
8: diag/tnslsnr/rac1.samik.com/listener_scan2
9: diag/tnslsnr/rac1.samik.com/listener_scan1
10: diag/asm/+asm/+ASM2
11: diag/asmcmd/user_grid/rac1.samik.com
12: diag/asmcmd/user_oracle/rac1.samik.com
13: diag/asmcmd/user_root/rac1.samik.com
Q: to quit 
 
 
[grid@rac1.samik.com crs]$ cd -
/applications/oracle/g19.3.0/gridbase/diag/crs/rac1.samik.com/crs/trace

[grid@rac1.samik.com trace]$ ls -lrt *alert*

-rw-rw----. 1 grid oinstall 306636 Dec 20 15:47 alert.log 




No comments:

Post a Comment

100 Oracle DBA Interview Questions and Answers

  Here are 100 tricky interview questions tailored for a Senior Oracle DBA role. These questions span a wide range of topics, including perf...