Error while exporting [message #232107] |
Thu, 19 April 2007 08:05 |
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 |
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 #583044 is a reply to message #583030] |
Thu, 25 April 2013 02:40 |
|
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 #583054 is a reply to message #583052] |
Thu, 25 April 2013 03:57 |
ThomasG
Messages: 3212 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?
|
|
|
|