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

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
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

_____________________________________________________________________________________________________________________

A visitor from Chennai viewed 'How to Find out / Check SGA and PGA size of Oracle' 16 mins ago
A visitor from Chengdu viewed 'Steps to Enable fast_start failover (automatic) in' 26 mins ago
A visitor from Singapore viewed 'How to check the pending transaction in your oracl' 29 mins ago
A visitor from Wada viewed 'How to Configure Tablespace / Monitoring Alert Ema' 39 mins ago
A visitor from Seongdong-gu viewed 'Data Pump EXPDP IMPDP EXCLUDE and INCLUDE Options ' 1 hr 59 mins ago

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-25 All Rights Reserved | Site Map | Contact | Disclaimer