[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Problems with trace file size

Posted on 2009-05-13
8
Medium Priority
?
660 Views
Last Modified: 2013-12-19
I'm on a client now in a very strange situation...
a couple of days ago, the client told me that oracle was consuming a lot of disk space, until the server hd came totally full... so the oracle stops working. The TI guy was deleting other old files that hasn't relevance for oracle, just to release disk space, just to keep oracle working... so I could arrive here few minutes ago.
On trace, just have one simple line, that set to a trace file...

Mon May 11 13:35:43 2009
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_1436.trc:
ORA-00600: internal error code, arguments: [17281], [600], [0x15CA4B70], [], [], [], [], []
ORA-00600: internal error code, arguments: [17402], [0x93D0904], [], [], [], [], [], []

I went to that, to see what kind of error happened. This file had 90gb and was growing up very fast... There was other in BDUMP, same size, same growing up.
So I tried to delete both.. and cannot do it, because oracle was sending more and more information do them...
Then I tried to stop oracle service and delete it... cannot to... "The computer cannot stop the local service on a remote computer (something like that)"
So I restart the server, deleted the files, and wait for a new file to open it and see the error.
Now oracle works very fine. No more big trace files on both directories... and no more message error on alter... just the alter database open
Someone could know what happened here?
I'm affraid that after I leave the client the same problem occurs again...
0
Comment
Question by:Thiago_corporative
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 

Author Comment

by:Thiago_corporative
ID: 24376277
Just one more thing...

I cannot open the trace files to... a message like it's not to possible to delete the file' appears
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24376441
This is certainly an Oracle bug, as there is no justification for 90GB trace file.

There are patches for similar bugs in Metalink, have you tried there? There is one regarding LOB segment management for 9.2.0.8

If not that one, report to support anyway, it is a bug.

0
 
LVL 40

Accepted Solution

by:
mrjoltcola earned 2000 total points
ID: 24376446
Bug 5396550 for 9.2.0.8
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
LVL 15

Expert Comment

by:Franck Pachot
ID: 24376466
Hi,
You should contact support for ORA-00600 errors.
But if you can't provide the trace files, don't expect too much...
Regards,
Franck.
0
 
LVL 48

Expert Comment

by:schwertner
ID: 24377864
There is an old problem with Linux/Unix.
Dropped files do not release the space before restarting the OS.
It is discussed here (from my Notes):

Problem: After moving the Oracle data file the disk space is not freed


http://www.experts-exchange.com/Database/Oracle/Q_23544226.html#a21956114


http://www.unix.com/filesystems-disks-memory/48678-mv-files-still-use-space-not-freed.html

fuser will show open files that have been deleted on a given file system. Until that process is stopped the space will not be freed. Before messing with files make sure no process has it open with fuser.

http://www.ibm.com/developerworks/aix/library/au-lsof.html

Finding open files with lsof


CONCLUSSION: Nothing is perfect, Unix/Linux also!
Let us drink a beer and be happy that we are alive!


0
 

Author Comment

by:Thiago_corporative
ID: 24377999
but the customer server uses windows
0
 
LVL 48

Expert Comment

by:schwertner
ID: 24378122
Then it seems mrjoltcola hits the nail on the head!
0
 
LVL 48

Expert Comment

by:schwertner
ID: 24382610
In both cases it seems there are Oracle processes that prevent the files deletion.
In Windows (like in Unix) you will not be allowed to drop a file if there is working
process with the file. Thats the explanation.
To get more info in Windows:
http://windowsxp.mvps.org/processlock.htm
http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

649 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