Re: database wouldn't register with the listener after ORA-600

The job of registering with and updating the listener is handled by PMON. PMON also does cleanup of failed transactions. The database can only run 1 PMON process so I guess it was too busy doing the cleanup.
Hemant

At 02:33 AM Saturday, Michael McMullen wrote:
>9.2.0.4
>Solaris 8
>
>We got a ORA-00600: internal error code, arguments: [6856] at 10:15
>a.m as a table was being loaded by insert into select * from; I
>believe the undo tablespace filled up first.
>Two minutes after that the database was no longer registered with
>listener. It wouldn't register until rollback was completed. I'm
>logging a tar but anyone ever seen anything like this?
>
>Thanks
>Mike

Hemant K Chitale
http://web.singnet.com.sg/~hkchital
and
http://hemantoracledba.blogspot.com

--
http://www.freelists.org/webpage/oracle-l