Skip to content

Root Fan

Linux & Oracle DBA Blog

  • Home
  • Contact
  • About
  • Index

Tag: alert

Posted on July 13, 2020November 1, 2020

How to Find Alert Log File Location in Oracle

In newer versions of Oracle Database it is not obvious where is the location of the alert file to investigate any potential issues.

The best way to find the Oracle alert file location is to use this query

select * 
from v$diag_info 
where NAME = 'Diag Trace';

Unmissable Posts

  • How to Change Processes Parameter in Oracle 19c RAC
  • How to Fix Oracle RAC Resource Unknown State
  • How to Find Alert Log File Location in Oracle
  • How to Change AWR Retention Period in Oracle Database
  • How to Upgrade PHP on Ubuntu

Recent Posts

  • How to Delete a Datafile in Oracle
  • How to Upgrade PHP on Ubuntu
  • How to Change Processes Parameter in Oracle 19c RAC
  • How to Kill a Session in Oracle RAC Database
  • How to Change AWR Retention Period in Oracle Database

Categories

  • Apache
  • Firewall
  • Linux
  • Oracle
  • Postfix
  • Security
  • Ubuntu

Unmissable Posts

  • How to Change Processes Parameter in Oracle 19c RAC
  • How to Fix Oracle RAC Resource Unknown State
  • How to Find Alert Log File Location in Oracle
  • How to Change AWR Retention Period in Oracle Database
  • How to Upgrade PHP on Ubuntu

Categories

  • Apache
  • Firewall
  • Linux
  • Oracle
  • Postfix
  • Security
  • Ubuntu
  • Facebook
  • Twitter
  • Email
Privacy Policy Proudly powered by WordPress