Results 1 to 9 of 9

Thread: Oracle Help (65GB file!!!)

  1. #1
    Senior Member ajbrun's Avatar
    Join Date
    Apr 2004
    Location
    York, England
    Posts
    4,840
    Thanks
    4
    Thanked
    25 times in 13 posts

    Exclamation Oracle Help (65GB file!!!)

    A few days ago, I was surprised to see my hard drive getting full as windows said it was below the 15% recommended space to defrag it. It turns out that it was right .

    After a bit of searching through my PC, I found that my oracle folder was using the most space by a long way. I followed the large folder sizes until I came here:

    C:\oracle\ora92\Apache\Apache\logs

    In that folder, there are 4 files, each with no file extension:

    access_log - 6KB
    ssl_engine_log - 14KB
    ssl_request_log - 0KB
    error_log - 68,352,056KB (65.1GB)

    Is it safe to delete the error_log file? I'm assuming it is since it's only an error log, but I thought I'd best ask first just incase since it has to be permanently deleted.

    I've tried opening the file in both notepad and wordpad, but both (unsuprisingly) says it's too big. I'm therefore assuming (but can't prove as I can't open the file) that it's the same error over and over again that it's recording, and that the file will constantly grow. Does anyone know of a way to open the file to look at it before deletion, or should I just delete it anyway?

    Thanks .

    EDIT - I just checked it again, and the file in question seems to have grown by another KB.
    Last edited by ajbrun; 06-11-2005 at 03:46 PM.

  2. #2
    Shunned from CS:S Trippledence's Avatar
    Join Date
    Feb 2005
    Location
    Exeter Uni/Truro Cornwall
    Posts
    1,848
    Thanks
    0
    Thanked
    1 time in 1 post
    I love that. You know when you where asking what you should put on your new HD, how about that. Hehe

    Just delete it. Whats the worse that can happen?

  3. #3
    Senior Member
    Join Date
    Apr 2005
    Location
    Bournemouth, Dorset
    Posts
    1,631
    Thanks
    13
    Thanked
    2 times in 2 posts
    Its only an error log - it will recreate the error log file if any other errors turn up!

    You must of left Orcale running on your computer for ages! and you must of noticed your hard drive constantly doing stuff.

    65gb hehe

    delete......

  4. #4
    smtkr
    Guest
    If the error log is that large, doesn't that signal some other underlying problem? It takes a long time to accumulate that many error messages in a normal environment.

  5. #5
    Senior Member Nemeliza's Avatar
    Join Date
    Jul 2003
    Posts
    1,719
    Thanks
    1
    Thanked
    5 times in 5 posts
    65GB of errors LOL

    What are you trying to use oracle for...and more importantly, does it work?

    As for the error log, open it. i would love to see what windows would say to a 65GB txt file!

    Otherwise just delete it.

  6. #6
    Senior Member ajbrun's Avatar
    Join Date
    Apr 2004
    Location
    York, England
    Posts
    4,840
    Thanks
    4
    Thanked
    25 times in 13 posts
    Like I said, I tried opening it, but notepad said it was too big, and wordpad gave some sort of an error. I also tried openoffice, but that took too long thinking about it, so I didn't bother.

    It's now been deleted.

    My plan now is too see if it comes back, if/when it does, see what the error is and try and fix it.

    I'm using oracle for uni.

  7. #7
    Sublime HEXUS.net
    Join Date
    Jul 2003
    Location
    The Void.. Floating
    Posts
    11,819
    Thanks
    213
    Thanked
    233 times in 160 posts
    • Stoo's system
      • Motherboard:
      • Mac Pro
      • CPU:
      • 2*Xeon 5450 @ 2.8GHz, 12MB Cache
      • Memory:
      • 32GB 1600MHz FBDIMM
      • Storage:
      • ~ 2.5TB + 4TB external array
      • Graphics card(s):
      • ATI Radeon HD 4870
      • Case:
      • Mac Pro
      • Operating System:
      • OS X 10.7
      • Monitor(s):
      • 24" Samsung 244T Black
      • Internet:
      • Zen Max Pro
    it won't open it, it'll say that it's too big and to use something else..

    If it did open it, it'd try to cache it all to ram, and I don't think anyone on here has a system with even a 10th of that

    best to use something like editplus, or even a hex editor, with a "read from disk" mode
    Last edited by Stoo; 06-11-2005 at 08:07 PM.
    (\__/)
    (='.'=)
    (")_(")

  8. #8
    smtkr
    Guest
    yeah, I have a program called ultraedit that can open files that large (as far as I know--I've never actually found a file over 3 MB)

  9. #9
    Agent of the System ikonia's Avatar
    Join Date
    May 2004
    Location
    South West UK (Bath)
    Posts
    3,736
    Thanks
    39
    Thanked
    75 times in 56 posts
    its actually nothing to do with Oracle database, its a web server component of Oracle. Oracle comes bundled with a hacked version of apache that can be used for web interaction.
    shut the web component down, delete the logs as they are just access logs and you'll be fine.
    It is Inevitable.....


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 63
    Last Post: 14-11-2011, 09:17 AM
  2. Batch file & copy query
    By Fatboy in forum Help! Quick Relief From Tech Headaches
    Replies: 4
    Last Post: 25-04-2005, 03:42 PM
  3. Nero or Burner ?
    By Foxile in forum Help! Quick Relief From Tech Headaches
    Replies: 30
    Last Post: 04-04-2005, 07:31 AM
  4. How do you backup?
    By Howard in forum PC Hardware and Components
    Replies: 48
    Last Post: 05-01-2005, 09:05 AM
  5. Manage downloaded webpages file and folder
    By Zathras in forum Software
    Replies: 0
    Last Post: 17-09-2003, 05:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •