OraFAQ Forum: Server Utilities » EXP-00030: Unexpected End-Of-File encountered while reading input

Home » RDBMS Server » Server Utilities » EXP-00030: Unexpected End-Of-File encountered while reading input

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

EXP-00030: Unexpected End-Of-File encountered while reading input [message #380449]

Sun, 11 January 2009 23:50

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.

Report message to a moderator

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

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

You probably ran out of disk space.

Report message to a moderator

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

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

Report message to a moderator

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

Frank Naude
Messages: 4579
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.

Report message to a moderator

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

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.

Report message to a moderator

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

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Yes.

PS: The newlines and dot at the end of your exp command looks very suspect.

Report message to a moderator

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

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

Mahesh Rajendran
Messages: 10707
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).

Report message to a moderator

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

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

Mahesh Rajendran
Messages: 10707
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 ')'.

Report message to a moderator

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

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.

Report message to a moderator

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

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

May be you had more than 2gb in a day.

Report message to a moderator

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

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.

Report message to a moderator

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

BlackSwan
Messages: 26766
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?

Report message to a moderator

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

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.

Report message to a moderator

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

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

exp help=y
Utilities book.

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 27 22:54:37 CDT 2024