stacktrace and error log

how will you  check error log in stack trace..

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

From the docs on background_dump_dest:

http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams020.htm#REFRN10008

Note:
 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:
http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams078.htm#REFRN10280

The structure of the directory specified by DIAGNOSTIC_DEST is as follows:
 <diagnostic_dest>/diag/rdbms/<dbname>/<instname>
0
 
OP_ZaharinCommented:
- in sqlplus, run the following, it will display the location of trace files:
show parameter background_dump_dest
0
 
tomvvAuthor Commented:
understood
0
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.