Re: Oracle Instance Terminated

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<9ncu4use2tsd4b4t5fgcge0qeq54dkdula_at_4ax.com>...
> On 23 Jan 2002 13:42:22 -0800, djohnson_dataspace_at_yahoo.com (Dave)
> wrote:
>
> >I am working on an NT 4.0 box with SP6 running 2 instances on Oracle
> >8i. The Oracle instances running on this box have been running
> >without incident for 6 months. Now the instances are forcefully
> >terminating after a minute or so. The (instance)ALRT.log file is
> >saying that PMON is terminating the instance due to a 474 error,
> >instance terminated by PMON pid = 64.
> >
> >Nothing has been installed or changed on the box. The event viewer is
> >only reporting when the instance is started and when it is forced to
> >terminate. The NT operating system has plenty of memory and free disk
> >space and is maintained regularly. There are only 2 instances running
> >on the server are a gig a piece.
> >
> >Any help sorting out this problem would be most appreciated.
> >
> >Thanks.
>
>
> Please find the meaning of error 474 in the Oracle Server Messages
> doc, and don't try to coerce anyone in this group to look it up for
> you.
>
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

Thankx a--hole.

You think I didn't check? Why don't you do something important instead of wasting peoples time on the newsserver. That is since you know sooo much more than anyone else. The message is useless.. and leads no-where. I did what it said. The other trace files are not indicating anything. No error messages, nothing. Do us all a favor.. if you are not going to help go back to being a push-button DBA.

ORA-00474 SMON process terminated with error

Cause: The System Monitor process terminated abnormally.

Action: Check the accompanying messages, if any, and the background process trace file. Correct the problem mentioned in the messages. Then shut down and restart the instance. If the trace file mentions any other background process messages, check the trace file for the mentioned process until the root message is found. Received on Thu Jan 24 2002 - 14:28:38 CST