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.

Share and contribute or get technical support and help at My Digital Life Forums.

Related Articles

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

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.