stacktrace and error log

Posted on 2012-09-01
Last Modified: 2012-09-16
how will you  check error log in stack trace..

In 11g what  is the location..
Question by:tomvv
    LVL 23

    Expert Comment

    - in sqlplus, run the following, it will display the location of trace files:
    show parameter background_dump_dest
    LVL 76

    Accepted Solution

    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:

    Author Closing Comment


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Oracle Cursor 5 50
    display data from previous rows 5 57
    Update table using multiple table qualifications 12 30
    Number Format 1 31
    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now