Answer from metalink:

Note:104868.1
Type:  PROBLEM
Status:  PUBLISHED
 Content Type:  TEXT/PLAIN
Creation Date:  07-APR-2000
Last Revision Date:  29-JUN-2000
Language:  USAENG


Problem Description:
====================

While attempting to perform a full database import you receive the following
errors:

    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)
              o/s error code 2

    IMP-0: Import terminated unsuccessfully


Solution Description:
=====================

Verify that all of the packages are valid before exporting your data.

If you cannot compile the package to make it valid, the package will need to
be dropped before performing the export.


Explanation:
============

This is due to [BUG:1033830].  The import attempt should instead just give
warnings such as:

    PLS-201 identifier '%s' must be declared

All packages must be valid before exporting.


References:
===========

[BUG:1033830]


Additional Search Words:
========================

IMP-3 ORA-3113 IMP-21
.




Please respond to [EMAIL PROTECTED]


Sajid Iqbal <[EMAIL PROTECTED]> on 02/23/2001 05:45:21 AM

                                                                                
  Message - From: Sajid Iqbal <[EMAIL PROTECTED]> on 02/23/2001 11:45 AM 
 GMT                                                                            
                                                                                



                                                              
                                                              
                                                              
 To:      Multiple recipients of list ORACLE-L                
          <[EMAIL PROTECTED]>                              
                                                              
 cc:      (bcc: Eveleen Xu/NNIB/NNNG)                         
                                                              
                                                              
                                                              
 Subject: Import (urgent)                                     
                                                              






Hello All

I am getting this error when doing a full import.

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

IMP-00021: operating system error - error code (dec 9, hex 0x9)

On Oracle 8.0.5 on Solaris 2.6

TIA

--
Sajid Iqbal
Database Team Leader




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sajid Iqbal
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Reply via email to