Results 1 to 7 of 7

Thread: Server crash

  1. #1
    Join Date
    Oct 2003
    Posts
    37

    Unanswered: Server crash

    Hi All

    We're running Oracle 9i release 2 (using reports 6i as the client) on a Windows 2000 advanced server (with all critical patches), the oracle databases are on a nas filer (which the windows server sees as additional disks),
    however I have a problem - when I do anything with oracle .dmp files (from the import / export utility) the server crashes.

    Its not very consistent - for example I took an export of our production database, imported into our test instance and it was okay, this morning I went to import it into our development instance and the server crashed!

    Has anyone else experienced any similar problems?

    Regards

    Keith

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    Any errors in the alert log?
    What is in the trace files?

  3. #3
    Join Date
    Oct 2003
    Posts
    37
    Hi Skywriter

    No errors reported in the alert log - archive log is on, so the database just reported that it recovered from the crash and created a trace file.

    The trace file says

    Redo thread mounted by this instance: 1
    Oracle process number: 12
    Windows thread id: 2476, image: ORACLE.EXE
    *** SESSION ID11.1) 2004-04-02 09:55:56.000
    Thread checkpoint rba:0x000058.00000002.0010 scn:0x0000.0082404c
    On-disk rba:0x000058.00021585.0000 scn:0x0000.0083817f
    Use incremental checkpoint cache-low RBA
    Thread 1 recovery from rba:0x000058.000211a5.0000 scn:0x0000.00000000


    I've also looked at the windows event viewer - which is just reporting that the Oracle databases were terminated suddenly lol


    Keith

  4. #4
    Join Date
    Jan 2004
    Posts
    370
    If no errors or assciated trace files then the problem isn't within the database.
    Like the event viewer says, something is pulling the carpet from under oracle, and it doesn't get a chance to raise an exception.

    the oracle databases are on a nas filer (which the windows server sees as additional disks)
    Is this a supported configuration?

  5. #5
    Join Date
    Oct 2003
    Posts
    37
    Hi Skywriter

    Thanks for your replies, I'm thinking that we may have a memory problem - the server has 4gig of ram but the instances are using a fair bit of it, the .dmp file is nearly a gig in size and I think the effort of doing anything with it is just too much.

    With regards to the NAS and whether it is a supported configuration - Netapps are an Oracle partner and our application suppliers are happy with the set up.


    Regards

    Keith

  6. #6
    Join Date
    Sep 2003
    Location
    Columbia, MD USA
    Posts
    95
    I would agree that the NetApp filers should be fine... the thing that caguht my attention was the statement that your instances were using up almost all of the memory... you need to have a good amount of headroom, especially on a Windows machine, for connections, sort areas, server memory space, processes, etc... I would probably try and reduce the memory consumption of the instances and leave at least 1GB free to start...

    1GB is not really that large of a dump file, so I wouldn't think that's the problem...

    does the server blue screen? or just reboot? is there anything in the windows event logs?

    you could have driver issues or just general hardware problems also, like bad memory, power supply, etc...
    drew
    ------------------
    http://wjtechnologies.com

  7. #7
    Join Date
    Oct 2003
    Posts
    37
    Hi Drew

    Thanks for the reply, the server just blue screens and reports a PCI bus to host problem.

    We initially had the problem moving the databases from the server to the nas (and we did all kinds of tests on the hardware - thinking that there must be a problem), but when we moved the data in smaller chunks the problem only seemed to occur with an old .dmp file - which we assumed must have become corrupt and therefore deleted it.

    Then there was the incident which led to my posting on this forum - so I started to think that windows was having a problem with Oracle .dmp files lol I was worried that somehow corrupt .dmp files were being created and causing the server to crash.

    It was only after this that I started looking for alternative and more realistic solutions and realised that an awful lot of memory was being used up the windows task manager is reporting that the memory usage is 4362824 / 5598684 and the the server is dedicated to our oracle application.

    We have three oracle instances running on the server and I suspect that when the application guys installed oracle etc they have allocated almost all the available memory to the Oracle instances (though i'm not sure why they didn't check with us before doing it).

    Regards

    Keith

Posting Permissions

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