Prev: truncate /*+append*/
Next: Using Python with Oracle Cursors
From: oradba on 9 Mar 2006 07:57
Hi



When I am doing a full export of database. I am getting the below
error.



EXP-00008: ORACLE error 3113 encountered

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

EXP-00008: ORACLE error 1041 encountered

ORA-01041: internal error. hostdef extension doesn't exist

EXP-00000: Export terminated unsuccessfully



I had gone through oracle forum website
(http://forums.oracle.com/forums/message.jspa?messageID=1178529) which
had suggested to run the below scripts.



1)catrepr.sql (Removes Replication related objects)



2)catrep.sql (Creates Replication related objects)



3)utlrp.sql (Recompile Invalid PL/SQL modules).



I ran the above scripts ,But the last scripts utlrp.sql hangs in the
middle.

Then later if we run the full database export again ...we are geting
below error.

EXP-00056: ORACLE error 21560 encountered
OCI-21560: argument 7 is null, invalid, or out of range
EXP-00056: ORACLE error 21560 encountered
OCI-21560: argument 7 is null, invalid, or out of range
EXP-00000: Export terminated unsuccessfully

From: Mladen Gogala on 9 Mar 2006 08:44
On Thu, 09 Mar 2006 04:57:53 -0800, oradba wrote:

> Hi
>
>
>
> When I am doing a full export of database. I am getting the below
> error.
>
>
>
> EXP-00008: ORACLE error 3113 encountered
>
> ORA-03113: end-of-file on communication channel

You have, of course, looked into alert log? You can skip all those
pesky ORA-7445 and ORA-0600 errors, they're utterly unimportant
and mostly irrelevant.You should concentrate only on 3113. Don't
even go near Metalink, it might explain you a thing or two about 3113.
What kind of "oradba" are you?

--
http://www.mgogala.com

From: bdbafh on 9 Mar 2006 10:58
Not a mention of oracle database server version or client version.

I'll spend my time elsewhere.

-bdbafh

 | 
Pages: 1
Prev: truncate /*+append*/
Next: Using Python with Oracle Cursors