With DD (DDV) as (SELECT VALUE DDV FROM V$parameter WHERE NAME='diagnostic_dest'), find the Alert Log Location in recent versions of Oracle 11g onwards Set heading off pages 0 trimspool on lines 120 feedback off echo off Here's a SQL script I wrote to find the alert log on Linux for 11g and 12c databases It is an ongoing mystery why this is made difficult to find. $ORACLE_BASE/diag/rdbms/DB_NAME/SID/trace is still useful to find the alert logĬore_dump_dest = /u01/app/oracle/diag/rdbms/repo/REPO/cdump and then cd. several different ways to get what you need.ġ2c (12.1.0.2) answer : Background_dump_dest no longer useful as they have changed what that parameter is doing
![oracle 10g vs 11g oracle 10g vs 11g](https://www.designsmag.com/wp-content/uploads/2015/02/oracle-6.png)
This is difficult to view as it is a binary file so let's look at 'strings spfileREPO.ora' to get what we want. PS to find DB_NAME and ORACLE_BASE we may need to look at the spfile If the database is Up we can ask it where it is writing the alert Log However it breaks down into two basic cases you don't have access to the file location - being a database user is no guarantee of being able to access the alert log file location (even being DBA may not be sufficient ! - depends on the sandbox the sysadmins have you in) There are multiple alert logs - in a RAC database for example there are several alert logs, one for each instanceģ. So this post will try and establish some ways that you can find the alert log.ġ: The database is down - if it is down, then obviously Oracle cannot tell you what the location is as SQLPLUS is down.Ģ. To cope with the backlash of complaints of people who didn't want to read an XML formatted alert log, Oracle continue to write the traditional form of the log as well simultaneously.
![oracle 10g vs 11g oracle 10g vs 11g](https://i.ytimg.com/vi/6hacOAYf09g/hqdefault.jpg)
We won't go into the detail of the ADR here except to note that this is where the alert log hangs out in recent versions of Oracle. In 11g this was changed to an XML formatted file, with the advent of the ADR which is a first stab at automating the management of the large quantity of detailed trace file that Oracle manages.
#Oracle 10g vs 11g how to#
In times gone by this was a nice text formatted file that most Oracle DBAs knew how to read. The Oracle Alert log tells us what major events have happened to the Oracle database. In this short post I'll try and see if we can provide a sensible way of establishing the location of the alert log for an oracle database, one that works for 9i, 10g, and 11g.