From exu@nnng.com Fri, 23 Feb 2001 06:32:26 -0800 From: exu@nnng.com Date: Fri, 23 Feb 2001 06:32:26 -0800 Subject: Re: Import (urgent) Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@fatcity.com Sajid Iqbal on 02/23/2001 05:45:21 AM Message - From: Sajid Iqbal on 02/23/2001 11:45 AM GMT To: Multiple recipients of list ORACLE-L 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@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@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@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@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).