Where/How to Check Alert Log File in Oracle 12c?

advertisements

_____________________________________________________________________________________________________________________

Prior versions as a DBA we used 

to check the alert logs in background_dump_dest directory. But in 11g onwards the alert log file location is changed to different location mentioned below. The second option is adrci which is the easiest way to access the alert log files for the databases which are running on the box.

Location is : $ORACLE_BASE/diag/ rdbms/SID/SID/trace 

/home/oracle[prodx01]> adrci

ADRCI: Release 12.1.0.2.0 - Production on Wed Jun 24 00:07:59 2015

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

ADR base = "/apps2/oracle"

adrci> show alert

Choose the home from which to view the alert log:

1: diag/tnslsnr/proddb01/listener_proddb01

2: diag/rdbms/PRODDB01/PRODDB01

Q: to quit

_____________________________________________________________________________________________________________________

Live Traffic Feed

A visitor from New york viewed 'Fix runInstaller [INS-32042] The Installer has det' 39 mins ago

A visitor from California viewed 'Fix runInstaller [INS-32042] The Installer has det' 44 mins ago

A visitor from Jarfalla municipality viewed 'Data Pump IMPDP REMAP_SCHEMA Parameter Syntax and ' 1 hr 25 mins ago

A visitor from Asuncion viewed 'Data Pump Impdp show=y Replaced with SQLFILE Optio' 1 hr 54 mins ago

A visitor from Pune viewed 'Data Pump Impdp TRANSFORM option SEGMENT_ATTRIBUTE' 2 hrs 11 mins ago

Real-time | Get Script | More Info