Oracle Database Import Error 3113/3114

When trying to import the Oracle export dump into Oracle database, the following errors occur:

IMP-00003: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00003: ORACLE error 3114 encountered
ORA-03114: not connected to ORACLE

The errors occur on Oracle database installed in Windows machine too. Actually the problem can occurs in any platform of Oracle database. It usually happens when try to import into new database.

The problem occurs because imp utiliy encounters error out when trying to execute some commands.

The solution to solve the problem is as following:

Login as sys in the SQLPLUS and run the following sqls

$OH/rdbms/admin/dbmsread.sql
$OH/rdbms/admin/prvtread.plb

After executing the above sql scripts, retry the import. The error should disappears.

Related Articles

• IMP-00016 Required Character Set Conversion Not Supported Error when Import to Oracle Database
• Oracle EXP-00091 Error When Export Database
• IMP-00013 Oracle Import Error
• Create, Add or Split Oracle Database Partition Fails with ORA-14080 Error
• Oracle Database Link
• Change Oracle Database User Password
• How Drop Tablespace and Recover Oracle Database When Accidentally Delete Datafile
• How to Remove and Drop Datafiles from Tablespace in Oracle Database
• View and Retrieve Oracle Database Link Details
• Oracle ORA-01658 Unable to Create INITIAL Extent for Segment in Tablespace Error

This entry was posted on Thursday, December 15th, 2005 at 11:40 am and is filed under Databases. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.