Turning ON the Trace file

[Former Member]

Hi Team,

Could you pls let me know how exactly we can turn on the following trace file..

Trace File(Background Process)

Dir:oracle/<SID>/saptrace/background/.

Regds,

Satyanarayana..

[Former Member · Accepted solution]

Hi,

You need to se the parameter in ini<SID>.ora parameter file

under $ORACLE_HOME/dbs folder.

Please find the patameter vaules to be set to turn the trace file for background process.

background_dump_dest = /oracle/MT4/saptrace/background

user_dump_dest = /oracle/MT4/saptrace/usertrace

core_dump_dest = /oracle/MT4/saptrace/background

log_archive_dest = /oracle/MT4/saparch/MT4arch

log_archive_format = %t_%s

AUTOMATICLY STARTED BACKGROUND PROCESSES

log_archive_start = true

Regards

Deepu

Edited by: Deepu Rajendrababu on Jun 13, 2008 11:22 AM

[Former Member · Accepted solution]

Hi,

How can we know whethere its already turned ON or not..

As you said that if we can find the paths mentioned u mean to say that it is turned ON..

And also do we need to check any other necessary files..

Regds,

Satyanarayana N.

[Former Member · Accepted solution]

rdisp/TRACE

With this parameter you can set the trace level for developer traces dev_*. The following values are permitted:

Whole number (between 0 and 3)

0: No trace

1: Error messages written to the trace file.

2: Full trace. The trace entries are dependent on the SAP program traced.

3: Like 2 , but data blocks are also traced.

[former_member185954 · Accepted solution]

Hello,

In the SAPGUI, login into the required system and start transaction DB03.

Then click on Active parameters button.

If you find the trace parameter explained earlier active then trace is active else its not active !

Regards,

Siddhesh

[Former Member · Accepted solution]

Hi Team,

Let me make it clear..

Pls let me know how to turn on the logs of oracle processes like Archiever,PMON AND SMON Logs..

Regds,

Satyanarayana N.

[former_member185954 · Accepted solution]

Hello,

>> Let me make it clear..

Would appreciate if you are a bit polite.

Anyways moving on with the problem.

If you start sqlplus with ora<sid> and execute the command: SHOW PARAMETERS TRACE

SQL> SHOW PARAMETERS TRACE 

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_trace                    integer     0
oracle_trace_collection_name         string
oracle_trace_collection_path         string      ?/otrace/admin/cdf
oracle_trace_collection_size         integer     5242880
oracle_trace_enable                  boolean     FALSE
oracle_trace_facility_name           string      oracled
oracle_trace_facility_path           string      ?/otrace/admin/fdf
sql_trace                            boolean     FALSE
trace_enabled                        boolean     TRUE
tracefile_identifier                 string

You should get the above output, on information about how to set these parameters.

Check this link:

http://download.oracle.com/docs/cd/A91202_01/901_doc/server.901/a87503/o_trace.htm#3016

Regards,

Siddhesh

[Former Member · Accepted solution]

Thank you siddesh..

The info you provided was very useful..to my question..

And would like to know for turning on Oracle-Trace_enable will turn both the foreground and background processes which reside in oracle/sid/saptrace/usertrace

Is there any diff parameter for turning on foreground and background processes..

Regds,

Satyanarayana N.

[former_member185954 · Accepted solution]

Hello,

Use these parameters:

BACKGROUND_DUMP_DEST

Path for alert log and background trace files

CORE_DUMP_DEST

Path under which core files are stored

USER_DUMP_DEST

Path for trace files of Oracle shadow processes

BACKGROUND_DUMP_DEST set to /saptrace/background

CORE_DUMP_DEST set to /saptrace/background

USER_DUMP_DEST set to /saptrace/usertrace

Regards,

Siddhesh

[Former Member · Accepted solution]

Thanks siddesh,

But when I check in init.ora file the parameter are set accordingly as you said but I have a query.. , the # symbol is it a comment or entry because we have this symbol for most of the parameters and also would like to know when we set this parameter what trace files we need to see as background and user trace files..

1. oracle_trace_enable = TRUE

init<sid>.ora destination parameters..

1. PATHS / DESTINATIONS / TRACES

1. /oracle/ANA/saptrace/background: trace files of the background

2. processes

3. /oracle/ANA/saptrace/usertrace: trace files of the user processes..

Pls provide me any additional info..

Regds,

Satyanarayana N.

[former_member185954 · Accepted solution]

Hello,

The hash (#) symbol is for comments anything that is written after the hash (#) symbol is treated as comment and hence the parameter definition you have shown is inactive.

to activate the parameter remove the hash (#) symbol and the line should look like this:

oracle_trace_enable = TRUE

All this can be easily found in WWW.GOOGLE.COM , appreciate if you can put some own efforts into this too.

Regards,

Siddhesh