Unix Technical Forum

Oracle export error

This is a discussion on Oracle export error within the Oracle Database forums, part of the Database Server Software category; --> Hi When I am doing a full export of database. I am getting the below error. EXP-00008: ORACLE error ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-25-2008, 02:56 AM
oradba
 
Posts: n/a
Default Oracle export error

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/mess...sageID=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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-25-2008, 02:56 AM
Mladen Gogala
 
Posts: n/a
Default Re: Oracle export error

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-25-2008, 02:56 AM
bdbafh@gmail.com
 
Posts: n/a
Default Re: Oracle export error

Not a mention of oracle database server version or client version.

I'll spend my time elsewhere.

-bdbafh

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:05 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com