Re: Import (urgent)

From: <exu_at_nnng.com>
Date: Fri, 23 Feb 2001 06:32:26 -0800
Message-ID: <F001.002BBAFE.20010223062051@fatcity.com>

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 ORACLE-L_at_fatcity.com

Sajid Iqbal <siqbal_at_vianetworks.co.uk> on 02/23/2001 05:45:21 AM

Message - From: Sajid Iqbal <siqbal_at_vianetworks.co.uk> on 02/23/2001 11:45 AM

 GMT                                                                            
                                                                                



                                                              
                                                              
                                                              
 To:      Multiple recipients of list ORACLE-L                
          <ORACLE-L_at_fatcity.com>                              
                                                              
 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: siqbal_at_vianetworks.co.uk

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: ListGuru_at_fatcity.com (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: exu_at_nnng.com

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: ListGuru_at_fatcity.com (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).

Received on Fri Feb 23 2001 - 08:32:26 CST