| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
