Home » RDBMS Server » Server Utilities » EXP-00030: Unexpected End-Of-File encountered while reading input
EXP-00030: Unexpected End-Of-File encountered while reading input [message #380449] Sun, 11 January 2009 23:50 Go to next message
g.srinuapps@gmail.com
Messages: 10
Registered: January 2009
Location: Hyderabad
Junior Member
while i am taking export dump i got this error.
===================================================================
EXP-00030: Unexpected End-Of-File encountered while reading input
. . exporting table              GL_JE_LINES_RECONerror closing export file
EXP-00002: error in writing to export file
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully
===================================================================


oracle version = 10g (10.2.0.3)

sheduled job in crontab:

# Daily Export from Monday to Saturday
00 2 * * 1-6 sh -c "/u01/applprod/scripts/exp_full_db_prdn.sh" > "/u01/applprod/scripts/logs/exp_full_db_prdn.log"

exp userid="sys/sysmanager as sysdba"
 file=(/u05/export_bkup/exp_full_db_prdn01.dmp,/u05/export_bkup/exp_full_db_prdn02.dmp,/u05/export_bkup/exp_full_db_prdn03.dmp,/u05/ex port_bkup/exp_full_db_prdn04.dmp,/u05/export_bkup/exp_full_db_prdn05.dmp,/u05/export_bkup/exp_full_db_prdn06.dmp,/u05/export_bkup/exp _full_db_prdn07.dmp,/u05/export_bkup/exp_full_db_prdn08.dmp,/u05/export_bkup/exp_full_db_prdn09.dmp,/u05/export_bkup/exp_full_db_prdn 10.dmp,/u05/export_bkup/exp_full_db_prdn11.dmp,/u05/export_bkup/exp_full_db_prdn12.dmp,/u05/export_bkup/exp_full_db_prdn13.dmp,/u05/e xport_bkup/exp_full_db_prdn14.dmp,/u05/export_bkup/exp_full_db_prdn15.dmp)
compress=y
log=/u01/applprod/scripts/logs/exp_full_db_PRDN.log
filesize=2000000000
full=y.


can someone advise me to resolve this issue.

Thanks in Advance,
Sreenivas.




Re: EXP-00030: Unexpected End-Of-File encountered while reading input [message #380469 is a reply to message #380449] Mon, 12 January 2009 00:44 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
You probably ran out of disk space.
Re: EXP-00030: Unexpected End-Of-File encountered while reading input [message #380477 is a reply to message #380449] Mon, 12 January 2009 00:51 Go to previous messageGo to next message
g.srinuapps@gmail.com
Messages: 10
Registered: January 2009
Location: Hyderabad
Junior Member
we are having enough space in our disc:

df -k .
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/cciss/c1d1p1 161268208 30041040 123035228 20% /u05

Please let me know how to over come this error.

Thanks in Advance,
Sreenivas
Re: EXP-00030: Unexpected End-Of-File encountered while reading input [message #380489 is a reply to message #380477] Mon, 12 January 2009 01:12 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Try to run the exp command interactively to see if it expects input:

$ oerr exp 30
00030, 00000, "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.

Re: EXP-00030: Unexpected End-Of-File encountered while reading input [message #380490 is a reply to message #380489] Mon, 12 January 2009 01:19 Go to previous messageGo to next message
g.srinuapps@gmail.com
Messages: 10
Registered: January 2009
Location: Hyderabad
Junior Member
you are asking me to run the export command manually ins ted of scheduling it in crontab.
Re: EXP-00030: Unexpected End-Of-File encountered while reading input [message #380494 is a reply to message #380490] Mon, 12 January 2009 01:25 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Yes.

PS: The newlines and dot at the end of your exp command looks very suspect.
Re: EXP-00030: Unexpected End-Of-File encountered while reading input [message #380566 is a reply to message #380449] Mon, 12 January 2009 06:08 Go to previous messageGo to next message
g.srinuapps@gmail.com
Messages: 10
Registered: January 2009
Location: Hyderabad
Junior Member
Executed the Export command manually but completed with warnings

userid="sys/sysmanager as sysdba"
 file=/u02/appldrch/export_bkup/exp_full_db_drch01.dmp,/u02/appldrch/export_bkup/exp_full_db_drch02.dmp,/u02/appldrch/export_bkup/exp_ full_db_drch03.dmp,/u02/appldrch/export_bkup/exp_full_db_drch04.dmp,/u02/appldrch/export_bkup/exp_full_db_drch05.dmp,/u02/appldrch/ex port_bkup/exp_full_db_drch06.dmp,/u02/appldrch/export_bkup/exp_full_db_drch07.dmp,/u02/appldrch/export_bkup/exp_full_db_drch08.dmp,/u 02/appldrch/export_bkup/exp_full_db_drch09.dmp,/u02/appldrch/export_bkup/exp_full_db_drch10.dmp,/u02/appldrch/export_bkup/exp_full_db _drch11.dmp,/u02/appldrch/export_bkup/exp_full_db_drch12.dmp,/u02/appldrch/export_bkup/exp_full_db_drch13.dmp,/u02/appldrch/export_bk up/exp_full_db_drch14.dmp,/u02/appldrch/export_bkup/exp_full_db_drch15.dmp)
compress=y
log=/u01/appldrch/logs/exp_full_db_DRCH.log
filesize=2000000000
full=y


Export terminated successfully with warnings.

Thanks&Regards,
Sreenivas

[Updated on: Mon, 12 January 2009 11:31] by Moderator

Report message to a moderator

Re: EXP-00030: Unexpected End-Of-File encountered while reading input [message #380608 is a reply to message #380566] Mon, 12 January 2009 11:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Check the logfile for specific warnings.
And Compress=Y in export is bad (It has nothing to do with this issue though).
Re: EXP-00030: Unexpected End-Of-File encountered while reading input [message #380646 is a reply to message #380608] Mon, 12 January 2009 19:04 Go to previous messageGo to next message
g.srinuapps@gmail.com
Messages: 10
Registered: January 2009
Location: Hyderabad
Junior Member
I added the 16th dump file to the parfile:

actually we are using our crontab:

# Daily Export from Monday to Saturday
00 2 * * 1-6 sh -c "/u01/applprod/scripts/exp_full_db_prdn.sh" > "/u01/applprod/scripts/logs/exp_full_db_prdn.log"

exp_full_db_prdn.sh:

# Delete the old export dump files from /u05/export_bkup folder
rm -rf /u05/export_bkup/*.dmp

. ./prdndb/10.2.0/PRDN_appsprod.env
exp parfile=/u01/applprod/scripts/exp_full_db_prdn.par

exp_full_db_prdn.par:

userid="sys/sysmanager as sysdba" 
 file=/u05/export_bkup/exp_full_db_prdn01.dmp,/u05/export_bkup/exp_full_db_prdn02.dmp,/u05/export_bkup/exp_full_db_prdn03.dmp,/u05/exp ort_bkup/exp_full_db_prdn04.dmp,/u05/export_bkup/exp_full_db_prdn05.dmp,/u05/export_bkup/exp_full_db_prdn06.dmp,/u05/export_bkup/exp_ full_db_prdn07.dmp,/u05/export_bkup/exp_full_db_prdn08.dmp,/u05/export_bkup/exp_full_db_prdn09.dmp,/u05/export_bkup/exp_full_db_prdn1 0.dmp,/u05/export_bkup/exp_full_db_prdn11.dmp,/u05/export_bkup/exp_full_db_prdn12.dmp,/u05/export_bkup/exp_full_db_prdn13.dmp,/u05/ex port_bkup/exp_full_db_prdn14.dmp,/u05/export_bkup/exp_full_db_prdn15.dmp,/u05/export_bkup/exp_full_db_prdn16.dmp)
compress=y
log=/u01/applprod/scripts/logs/exp_full_db_PRDN.log
filesize=2000000000
full=y



to day i got new error like:

EXP-00030: Unexpected End-Of-File encountered while reading input
EXP-00056: ORACLE error 1403 encountered
ORA-01403: no data founderror closing export file
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully


please provide a solution it's related to PROD Instance.

Thanks in Advance,
Sreenivas.

[Updated on: Mon, 12 January 2009 22:34] by Moderator

Report message to a moderator

Re: EXP-00030: Unexpected End-Of-File encountered while reading input [message #380659 is a reply to message #380646] Mon, 12 January 2009 23:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Either you add more files
or
Increase the filesize parameter (unless you are restricted by OS/2g limit).

PS: Format your posts. If you are using the same parameter file as posted here, it will Error. It contains unwanted ')'.
Re: EXP-00030: Unexpected End-Of-File encountered while reading input [message #380662 is a reply to message #380659] Mon, 12 January 2009 23:15 Go to previous messageGo to next message
g.srinuapps@gmail.com
Messages: 10
Registered: January 2009
Location: Hyderabad
Junior Member
my par file is:

userid="sys/sysmanager as sysdba"
file=(/u05/export_bkup/exp_full_db_prdn01.dmp,/u05/export_bkup/exp_full_db_prdn02.dmp,/u05/export_bkup/exp_full_db_prdn03.dmp,/u05/ex port_bkup/exp_full_db_prdn04.dmp,/u05/export_bkup/exp_full_db_prdn05.dmp,/u05/export_bkup/exp_full_db_prdn06.dmp,/u05/export_bkup/exp _full_db_prdn07.dmp,/u05/export_bkup/exp_full_db_prdn08.dmp,/u05/export_bkup/exp_full_db_prdn09.dmp,/u05/export_bkup/exp_full_db_prdn 10.dmp,/u05/export_bkup/exp_full_db_prdn11.dmp,/u05/export_bkup/exp_full_db_prdn12.dmp,/u05/export_bkup/exp_full_db_prdn13.dmp,/u05/e xport_bkup/exp_full_db_prdn14.dmp,/u05/export_bkup/exp_full_db_prdn15.dmp,/u05/export_bkup/exp_full_db_prdn16.dmp)
compress=y
log=/u01/applprod/scripts/logs/exp_full_db_PRDN.log
filesize=2000000000
full=y

before there are 15 files only yesterday i added 16th file but still i am facing the error as mentioned in previous reply.

Pleade advise.
Re: EXP-00030: Unexpected End-Of-File encountered while reading input [message #380781 is a reply to message #380662] Tue, 13 January 2009 05:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
May be you had more than 2gb in a day.
Re: EXP-00030: Unexpected End-Of-File encountered while reading input [message #381592 is a reply to message #380781] Sun, 18 January 2009 21:43 Go to previous messageGo to next message
g.srinuapps@gmail.com
Messages: 10
Registered: January 2009
Location: Hyderabad
Junior Member
To Day also i got the error:
================================================================
EXP-00030:Unexpected End-Of-File encountered while reading input
. . exporting table GL_JE_LINES_RECONerror closing export file
EXP-00002: error in writing to export file
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully
================================================================

Please let me know how to rectify this error.

Thanks&Regards,
Sreenivas.
Re: EXP-00030: Unexpected End-Of-File encountered while reading input [message #381597 is a reply to message #380449] Sun, 18 January 2009 22:13 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.

What is Operating System name & version?

In some cases (either OS or s/w utility) have line length limitations.

Perhaps the number or total length of file names exceeds some limit?

WHY is filesize restricted to filesize=2000000000?
Re: EXP-00030: Unexpected End-Of-File encountered while reading input [message #381601 is a reply to message #381597] Sun, 18 January 2009 22:27 Go to previous messageGo to next message
g.srinuapps@gmail.com
Messages: 10
Registered: January 2009
Location: Hyderabad
Junior Member
Linux Operating system please find the output of Uname -a:

$uname -a
Linux appsprod.olamnet.com 2.6.9-67.0.1.0.1.ELsmp #1 SMP Wed Dec 19 18:59:23 EST 2007 i686 i686 i386 GNU/Linux.


version:4.0.

Thanks&Regards,
Sreenivas.
Re: EXP-00030: Unexpected End-Of-File encountered while reading input [message #381611 is a reply to message #381601] Mon, 19 January 2009 00:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Seems you are getting error when exporting GL_JE_LINES_RECON table.
Keep a close tab on it. It might be growing fast.
Other possibility is that you have messed with DUAL table.
Either you have truncated it or one of the schemas has a local copy of it.
You can test it by exporting in user mode instead of full database.
Re: EXP-00030: Unexpected End-Of-File encountered while reading input [message #381679 is a reply to message #381611] Mon, 19 January 2009 03:43 Go to previous messageGo to next message
g.srinuapps@gmail.com
Messages: 10
Registered: January 2009
Location: Hyderabad
Junior Member
Please let me know the syntax for the export at user level

Thanks in Advance,
Sreenivas.
Re: EXP-00030: Unexpected End-Of-File encountered while reading input [message #381681 is a reply to message #381679] Mon, 19 January 2009 03:52 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
exp help=y
Utilities book.

Regards
Michel
Previous Topic: SQL*Loader: Loading fixed-length file to table with VARRAY
Next Topic: exp compress
Goto Forum:
  


Current Time: Sun Dec 11 04:18:36 CST 2016

Total time taken to generate the page: 0.06288 seconds