Re: Oracle error

In article <2n3div$35h_at_bwc.bwc.org> farzin_at_saturn.bwc.org (Farzin Shakibanejad) writes:

> -- While running a stored procedure via a twotask (sqlnet v1)
> -- on Oracle v7.0.15.4 / Sun Platform, SunOs 4.1.3, the
> -- following error is produced.
>
> ORA-1041: internal error. hostdef extension doesn't exist.
>
> -- the following is the explanation I can get using "oerr"
>
> % oerr ora 1041
> 01041, 00000, "internal error. hostdef extension doesn't exist"
> // *Cause: Pointer to hstdef extension in hstdef is null.
> // *Action: Report as a bug
> %
>
> -- This error occurs after an oracle error number
> -- 3113: end-of-file on communication channel.
>
> -- I can not see any reason why it should detect an
> -- "end-of-file on communication channel." neither can I see
> -- why oracle errors 1041 is given.
> -- if you have seen this or know what it is, please reply.

ORA-03113 in a client server environment means that the back end process on the server terminates prematurely, possibly due to a segmentation violation, bus error, or the like. To pinpoint the source of the problem, you can either look at the trace file or execute the store procedure directly on the server machine using sqlplus. Since the back end process is actually spawned by the front end process in the single machine environment (thus bypassing SQL*Net), the terminating signal will be catched by the front end process and will be properly reported.

Good luck.

--
 Alvin W. Law .............................................. Oracle Corporation
 Senior Applications Engineer ..................... 300 Oracle Parkway, Floor 6
 Manufacturing Applications .......................... Redwood Shores, CA 94065
 Email: alaw_at_oracle.com ........... Voice: 1.415.506.3390 . Fax: 1.415.506.7299

ORA-03113: end-of-file on communication channel