-
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
-
Did they used to get posted?
Check the space you have left on that disk.
-
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
On the other hand, you have different fingers.
-
Has Anybody stopped generation of trace files by changing SQL_TRACE parameter?
Is SQL_TRACE still TRUE
check
SQL> show parameter sql_trace
Sameer
-
Thanks.
It had been set to false:
SQL> show parameter sql_trace;
NAME TYPE VALUE
------------------------------------ ------- --------------------
sql_trace boolean FALSE
I appreciate your help.
On the other hand, you have different fingers.
-
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?
-
-
Did that when I changed init.ora. Did not seem to help.
On the other hand, you have different fingers.
-
What about
SQL>show parameter oracle_trace_enable
Sameer
-
That parameter is already enabled. Is there somewhere I can get a list of parameters relating to trace?
On the other hand, you have different fingers.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|