Home » Infrastructure » Windows » Data Import error message
Data Import error message [message #100661] Mon, 07 April 2003 02:35
Neil Bennett
Messages: 5
Registered: March 2003
Junior Member
I am trying to complete a data import onto a database server running on NT4.0(Service Pack 6a). This is being done with the following 3 scripts;
Script One:

REM
REM Create database instance RATO
REM
REM Neil Bennett February 2003

SET ORACLE_SID=RATO

oradim80 -delete -sid RATO

oradim80 -new -sid RATO -startmode auto -intpwd RATO -maxusers 100 -pfile v:RATOinitRATO.ora

svrmgr30 @v:RATOSQL_create_RATO.sql
svrmgr30 @v:RATORATO_deftsp.sql
svrmgr30 @v:RATORATO_rollback.sql
svrmgr30 @v:RATORATO_ddpls.sql
svrmgr30 @v:RATORATO_user.sql

Script Two:

REM
REM Copy LATO to RATO
REM
REM Neil Bennett February 2003

@echo off
cd v:RATO
set oracle_sid=RATO
svrmgr30 @v:RATOshutRATO.sql

REM When first run there will be errors because these files do not exist.
del v:RATOrato_lob.ora
del v:RATOrato_data.ora
del v:RATOrato_index.ora
del v:RATOrato_reports.ora
del v:RATOrato_temp.ora
del v:RATOrato_rollback.ora
del v:RATOrato_log_g1.ora
del v:RATOrato_log_g2.ora
del v:RATOrato_ctl_001.ora
del v:RATOrato_ctl_002.ora
del v:RATOrato_system.ora

set oracle_sid=RATO
cmd_create_rato.cmd

REM The Oracle Import file was created in the modified BACKUP.
set oracle_sid=RATO
imp80 system/manager@RATO full=Y file=v:RATOfull_rato_exp.dmp log=v:RATORATO_imp.log

REM Initially I needed to shut the RATO instance and then restart but
REM these line are superfluous now.

rem set oracle_sid=RATO
rem svrmgr30 @v:RATOshutRATO.sql
rem set oracle_sid=RATO
rem svrmgr30 @v:RATObginRATO.sql

Script Three:

REM
REM Import LATO to RATO
REM
REM Neil Bennett February 2003

@echo off
set oracle_sid=RATO
imp80 system/manager@rato full=Y file=v:ratofull_lato_exp.dmp log=v:RATORATO_imp.log

The first two scripts appear to run OK and I have been able to connnect to the instance in SQL*Plus via an MS-DOS window.

However, the third scripts returns the following error messages;

IMP-00003: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00021: operating system error - error code (dec 2, hex 0x2)
IMP-00000: Import terminated unsuccessfully

IMP-00021: operating system error - error code (dec 2, hex 0x2)

I have run the scripts a few times and, on one occasion, received an NT error message advising that I required more virtual memory. I increased this to 50Mb, against the max of 72Mb.

Please can anyone advise on the meaning of these messages (I'm still looking on the Internet)and what needs to be done to overcome them and complete the dataload.

Thanks
Previous Topic: Re: ODBC error on Windows 95
Next Topic: Re: ASP problem for Oracle9i on windows2000
Goto Forum:
  


Current Time: Thu Mar 28 12:38:33 CDT 2024