stacktrace and error log

how will you  check error log in stack trace..

In 11g what  is the location..
Who is Participating?
slightwv (䄆 Netminder) Commented:
Starting in 11g the parameter is DIAGNOSTIC_DEST.

From the docs on background_dump_dest:

 This parameter is ignored by the new diagnosability infrastructure introduced in Oracle Database 11g Release 1 (11.1), which places trace and core files in a location controlled by the DIAGNOSTIC_DEST initialization parameter.

The docs in diagnostic_dest:

The structure of the directory specified by DIAGNOSTIC_DEST is as follows:
- in sqlplus, run the following, it will display the location of trace files:
show parameter background_dump_dest
tomvvAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.