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
LK is a technology writer for Tech Journey with background of system and network administrator. He has be documenting his experiences in digital and technology world for over 15 years.Connect with LK through Tech Journey on Facebook, Twitter or Google+.
