Re: Has anyone seen this ORACLE crash?

I've seen exactly the same happen on earlier Oracle releases on NT3.51. Bringing the db down and rebooting the server (cold reboot) was the only cure.

In the end (because we were very short of time) we moved the db over to UNIX (AIX) and it's worked faultlessly ever since. Having said all that, many people around here run Oracle on NT with success, so it seems like a error with your system only.

The things to check are:

• Oracle installation (was it done correctly?). Ditto NT.
• Drivers on NT (are some of those causing the crashes?)
• State of tune of your db. Is it OK. Ditto NT.
• Check the Oracle logs.
• Call Oracle Tech Support.

I'd also suggest maybe trying to copy your db to a clean test system (as PC servers are quite cheap) and trying it their. That would at least eliminate (or otherwise) the hardware.

Steve Phelan.

NNOOR wrote in message <6devgu$sij_at_examiner.concentric.net>...
>
>Oracle WGS 7.3.3, WinNT 4 with SP3.
>Pentium 200 Pro + 512MB RAM
>
>There are two instances running against this Oracle DB. This
>morning something causes one instance's users to disappear.
>Following are the symptoms.
>
>The only ID that would work was the INTERNAL.
>The password defined for SYS and SYSTEM would not work.
>All of the other 25 users were as if they never existed.
>*AND* a SELECT * FROM ALL_USERS returned *ONLY these couple
>of users as well.
>We had to restart the machine to get every thing back to normal.
>It was a close call!!!
>
>Can anyone help us understand this crash? Thanks.
>
>Regards,
>Nasir (nnoor_at_cris.com)
Received on Tue Mar 03 1998 - 00:00:00 CST