Home » Infrastructure » Other Operating Systems » EXP-00030 from MVS exp
EXP-00030 from MVS exp [message #233343] Wed, 25 April 2007 14:48 Go to next message
DN8747
Messages: 1
Registered: April 2007
Junior Member
I'm trying to set up a job that will do an exp from MVS. I tried to use the example script through the script section of the site http://orafaq.com/scripts/mvs/export.txt

When I run the job, I'm consistently getting the following error:
Export: Release 9.2.0.4.21 - Production on Wed Apr 25 13:59:01 2007

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


Username:
EXP-00030: Unexpected End-Of-File encountered while reading input
EXP-00000: Export terminated unsuccessfully
:-) .STEPS01 .SYSERR 9

Yes, the client version on our complex is a bit old, and changing it is out of my control. We're trying to connect to an AIX based 10g instance through the process.

I've tried pretty much everything I can think of, switching member based parfiles to inline in the JCL, switching from tape to disk for the out file, changing the DCB for the out file, removing all members I could, etc.. The version I'm currently working with looks like the following:

//DN8747OC JOB (1MDB,CPSC,03,5),'ORACLE EXP',
// SCHENV=HA00,NOTIFY=&SYSUID
//***************************************************************
//JOBLIB DD DSN=SUPT.ORACLE.SERVER.CMDLOAD,DISP=SHR
// DD DSN=SUPT.ORACLE.SERVER.MESG,DISP=SHR
//***************************************************************
//STEPS01 EXEC PGM=EXP
//SYSMDUMP DD SYSOUT=*
//SYSOUT DD SYSOUT=*,DCB=(LRECL=132,BLKSIZE=1320,RECFM=VB)
//SYSERR DD SYSOUT=*,DCB=(LRECL=132,BLKSIZE=1320,RECFM=VB)
//ORAPRINT DD SYSOUT=*
//ARCDATA DD DSN=DN8747.ORA.EXPTST.A070425,
// UNIT=3590TAPE,VOL=(,RETAIN,,99),
// DCB=(PSDSCB,RECFM=FB,BLKSIZE=32760),
// DISP=(NEW,CATLG,DELETE),
// RETPD=2000
//TNSNAMES DD DSN=MDNCNSA.CNTLLIB(TNSNAMES),DISP=SHR
//PARFILE DD DSN=DN8747.ORACLE.TEST.CNTLCARD(MDNCNPF),DISP=SHR
// DD DSN=DN8747.ORACLE.TEST.SQL(MDNCNDEP),DISP=SHR


Where arcdata is the tape file I'm trying to write out to from the exp.
MDNCNPF contains the following:
USERID=userid/password@tnsname
MDNCNDEP contains the following:
FILE=/DD/ARCDATA
CONSISTENT=Y
DIRECT=Y
BUFFER=9999999
COMPRESS=Y
ROWS=Y
CONSTRAINTS=Y
GRANTS=Y
INDEXES=Y
TRIGGERS=Y
TABLES=(STATE_NAME_LOOKUP)

The TNSNAMES member works with the SQLPlus and Loader jobs we have using it. I've tried moving the parfile info to be inline, like the example had (below), but no luck. Any ideas where the problem may be coming in?

//PARFILE DD *
USERID=USERNAME/PASSWORD
FILE=/DD/EXPORT
CONSISTENT=Y
DIRECT=Y
BUFFER=9999999
RECORD=N

Re: EXP-00030 from MVS exp [message #289505 is a reply to message #233343] Sat, 22 December 2007 22:19 Go to previous message
0551373
Messages: 6
Registered: December 2007
Junior Member
Q. is the Flash Recovery Area Enabled. if so you may not be able to write to tape. Check with the Oracle Admin.
Previous Topic: Trouble shooting Oracle database on VMS
Next Topic: Migration of data from RMS files on OpenVMS to Oracle Database
Goto Forum:
  


Current Time: Wed Oct 01 15:29:02 CDT 2014

Total time taken to generate the page: 0.24783 seconds