Trace Files Not Being Generated

[rlowe]

Trace files have stopped being generated on my database server. (bdump, cdump, udump, etc...). The parameters are set in init.ora:

background_dump_dest = /u08/OraHome1/admin/ORCL/bdump
core_dump_dest = /u08/OraHome1/admin/ORCL/cdump
user_dump_dest = /u08/OraHome1/admin/ORCL/udump

Parameters are recognized in v$parameter:

SVRMGR> select name, value from v$parameter where name like '%dump%';
NAME VALUE
-------------------------- ---------------
shadow_core_dump partial
background_core_dump partial
background_dump_dest /u08/OraHome1/admin/ORCL/bdump
user_dump_dest /u08/OraHome1/admin/ORCL/udump
core_dump_dest /u08/OraHome1/admin/ORCL/cdump

OS: Solaris 8
DB: Oracle 8.1.5

Oracle has proper permissions to /u08/... and everything below it. ANY IDEAS?

Thanks,
R

[jgmagnus]

Did they used to get posted?

Check the space you have left on that disk.

[rlowe]

Yes, they used to get generated... I wish I knew what happened immediately before it stopped, but I do not.

There is plenty of space left on the device:
/dev/dsk/c5t2d0s0 17404618 950730 16279842 6% /u08

[Sameer]

Has Anybody stopped generation of trace files by changing SQL_TRACE parameter?

Is SQL_TRACE still TRUE

check

SQL> show parameter sql_trace

Sameer

[rlowe]

Thanks.

It had been set to false:

SQL> show parameter sql_trace;

NAME TYPE VALUE
------------------------------------ ------- --------------------
sql_trace boolean FALSE

I appreciate your help.

[rlowe]

I changed init.ora to include:

sql_trace = true

However, this has not enabled trace files (or at least they are not being generated). Is there anything else I can look for/check?

[jgmagnus]

Bounce the DB.

[rlowe]

Did that when I changed init.ora. Did not seem to help.

[Sameer]

What about

SQL>show parameter oracle_trace_enable

Sameer

[rlowe]

That parameter is already enabled. Is there somewhere I can get a list of parameters relating to trace?