Sunday, September 12, 2010

Oracle Database Import Error 3113/3114

Error:
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
This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.

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

Solution:
1. Login as sys in the SQLPLUS and run the following sqls

@$ORACLE_HOME/rdbms/admin/dbmsread.sql
@$ORACLE_HOME/rdbms/admin/prvtread.plb

2. Redo the import.

Friday, February 20, 2009

ORA-07445

ORA-07445
ORA-07445: Exception encountered: core dump [string] [string] [string] [string] [string] [string]
Cause: An OS exception occurred which should result in the creation of a core file. This is an internal error.
Action: Contact your customer support representative.




Tags: ,,,,