Re: ORA-01041: internal error. HOSTDEF extension does not exist

I recently got this when re-creating/re-orging a database. I had run some scripts
to include catproc etc., and then ran a script to delete the old datafiles. By accident, I had deleted a temp.dbf that I had previously assigned to be SYSTEM's
sort area. When I did an import, I got the hostdef pretty quick. I wasn't sure
what was going on until I shutdown/started up, and saw that there was a datafile
missing. This isn't to say that you should bounce your database, it's only to say that
I have an inkling this could mean a missing datafile, that you wouldn't necessarily notice
until you brought the database back up.

• Dc.

Mark Patterson wrote:

> Hi,
>
> For the last hour or so I've been consistently getting the following
> error returned from my Oracle database (Version 8.1.5) -
> "ORA-01041: internal error. HOSTDEF extension does not exist"
>
> On close examination I find I'm getting the
> "ORA-03113: end-of-file on communication channel"
> error. I think, though I'm not 100% sure, this is preceding the above
> error.
>
> Also, on examination of the alert log I found the following error...
> ORA-00600: internal error code, arguments: [12333], [0], [0], [100], [],
> [], [],[]
>
> Unfortunately I do not have 24/7 support so am unable to follow the
> documantation instructions which goes something like "...contact Oracle
> support...".
>
> Does anybody have any ideas or pointers?
>
> Thanks
>
> Mark Patterson.
Received on Sun Jun 27 1999 - 21:05:19 CEST