Solved

Problems with trace file size

Posted on 2009-05-13
8
647 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
  • 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 500 total points
ID: 24376446
Bug 5396550 for 9.2.0.8
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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 47

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 47

Expert Comment

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

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Encryption Decryption in Oracle 12 117
Getting TNS:Connect timeout occurred while opening the application 5 76
SQL Query 34 97
clob to char in oracle 3 34
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

815 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now