Home » RDBMS Server » Server Utilities » Error while exporting
Error while exporting [message #232107] Thu, 19 April 2007 08:05 Go to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
Hello sir


We have enable script to the run export on daily basis
last 3 days the export log thru the following below error

EXP-00030: Unexpected End-Of-File encountered while reading input
EXP-00056: ORACLE error 24909 encountered
ORA-24909: call in progress. Current operation cancelled
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00000: Export terminated unsuccessfully


According to the export log ,it seems the export run properly for 50% datas,i dont know what can i do for this error

Futher details:

ur server OS--> Linux 3.2(redhat linux)
oracle version--> 9.2.0.7.0(last patch has been updated (i think before 4 months))

plz help me what can i do


Advanced Thanx.
Re: Error while exporting [message #232157 is a reply to message #232107] Thu, 19 April 2007 12:01 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
In exp command,
Add more files (FILE parameter)
or increase each file size(FILESIZE parameter).
you data might have increased recently in the database.it need more space to accomodate
Re: Error while exporting [message #232183 is a reply to message #232157] Thu, 19 April 2007 14:06 Go to previous messageGo to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
Really thanks a lot sir
Re: Error while exporting [message #583018 is a reply to message #232183] Wed, 24 April 2013 20:58 Go to previous messageGo to next message
maxwellzone
Messages: 5
Registered: April 2013
Junior Member
I got the same error, and does it valid to add more file or increase file size?

EXP-00030: Unexpected End-Of-File encountered while reading input
EXP-00056: ORACLE error 24909 encountered
ORA-24909: call in progress. Current operation cancelled
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00000: Export terminated unsuccessfully

Re: Error while exporting [message #583019 is a reply to message #583018] Wed, 24 April 2013 21:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I got the same error, and does it valid to add more file or increase file size?
what is the downside to do so?
What is any alternative?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Re: Error while exporting [message #583020 is a reply to message #583019] Wed, 24 April 2013 21:53 Go to previous messageGo to next message
maxwellzone
Messages: 5
Registered: April 2013
Junior Member
Sorry, sir

my os is:SunOS 5.10 Generic_142900-03
oracle is:9.2.0.8.0

And I got error EXP-00030 two days when I export data, I don`t know how to solve it.
Now I try the gkrishn`s suggestion to add more dmp files, I hope this work.

My error message is

EXP-00030: Unexpected End-Of-File encountered while reading input
EXP-00056: ORACLE error 24909 encountered
ORA-24909: call in progress. Current operation cancelled
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00000: Export terminated unsuccessfully
Re: Error while exporting [message #583030 is a reply to message #583020] Thu, 25 April 2013 00:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
EXP-00030: Unexpected End-Of-File encountered while reading input
 *Cause:  Encountered an End-Of-File while reading the user input.
 *Action: If input to export is being redirected, check the file for errors.


Copy and paste ALL what you did and got.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

Regards
Michel
Re: Error while exporting [message #583044 is a reply to message #583030] Thu, 25 April 2013 02:40 Go to previous messageGo to next message
maxwellzone
Messages: 5
Registered: April 2013
Junior Member
Sir, I used this command in cron to export data
#############
$ORACLE_HOME/bin/exp account/password direct=y buffer=102400000 file="$dir_path$file_name"_1.dmp,"$dir_path$file_name"_2.dmp,"$dir_path$file_name"_3.dmp,"$dir_path$file_name"_4.dmp,"$dir_path$file_name "_5.dmp filesize=2000M OWNER=oracle log=$dir_path$file_name.log
#############


And the full error message
#############
Table Table_Name will be exported in conventional path.
. . exporting table Table_Name
Export file: expdat.dmp >
EXP-00030: Unexpected End-Of-File encountered while reading input
EXP-00056: ORACLE error 24909 encountered
ORA-24909: call in progress. Current operation cancelled
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00000: Export terminated unsuccessfully
#############


Now I change command to this, and wait next schedule to run.
#############
$ORACLE_HOME/bin/exp account/password direct=y buffer=102400000 file="$dir_path$file_name"_1.dmp,"$dir_path$file_name"_2.dmp,"$dir_path$file_name"_3.dmp,"$dir_path$file_name"_4.dmp,"$dir_path$file_name "_5.dmp,"$dir_path$file_name"_6.dmp,"$dir_path$file_name"_7.dmp,"$dir_path$file_name"_8.dmp,"$dir_path$file_name"_9.dmp,"$dir_path$file_name "_10.dmp," filesize=2000M OWNER=oracle log=$dir_path$file_name.log
#############
Re: Error while exporting [message #583047 is a reply to message #583044] Thu, 25 April 2013 03:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The export log header also helps in most cases.

1/ Are you sure your OS supports file of 2000M?
2/ Are you sure you have space enough in your file system?

Regards
Michel
Re: Error while exporting [message #583050 is a reply to message #583047] Thu, 25 April 2013 03:30 Go to previous messageGo to next message
maxwellzone
Messages: 5
Registered: April 2013
Junior Member
Sir,

This command had run years, so I sure OS support file of 2000M.
And I export data to nfs system, the space still has 400GB.

This is export log header
#################
Export: Release 9.2.0.8.0 - Production on Thu Apr 25 01:00:17 2013

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.8.0 - Production Export done in UTF8 character set and UTF8 NCHAR character set . exporting pre-schema procedural objects and actions . exporting foreign function library names for user oracle . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user oracle About to export oracle's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
################
Re: Error while exporting [message #583052 is a reply to message #583050] Thu, 25 April 2013 03:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
And I export data to nfs system, the space still has 400GB.


Maybe a problem with nfs at this time.
Does this happen every time now?
Or maybe 10 files is no more sufficient.

Regards
Michel
Re: Error while exporting [message #583054 is a reply to message #583052] Thu, 25 April 2013 03:57 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
One thing I would check first:

- What files are in the export directory right now? If there are 10 Files with 2000MB right now, then the 10 files aren't enough.
- Can the Oracle user write into that directory?
Re: Error while exporting [message #583104 is a reply to message #583054] Thu, 25 April 2013 20:19 Go to previous message
maxwellzone
Messages: 5
Registered: April 2013
Junior Member
Sir, after increase export files, I got successful export today.
So, I think this method is work.
Previous Topic: Too many errors while importing full db export
Next Topic: Databaseimport error
Goto Forum:
  


Current Time: Fri Mar 29 02:46:08 CDT 2024