Wednesday, May 9, 2012

Oracle Import Errors With ORA-03113, ORA-03114

When trying to import to a newly created database, Oracle import outputs with the following 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
To correct this error, run the following scripts using the sys account:
$ORACLE_HOME/rdbms/admin/dbmsread.sql
$ORACLE_HOME/rdbms/admin/prvtread.plb

Posted by at

1 comment:

  1. lateefDecember 19, 2012 at 3:11 PM

    I did this solution but I have the seam error!
    "R" NUMBER, "CARBOL_GROS_MAS" NUMBER(18, 2), "CARBOL_GOOD1" VARCHAR2(35), "C"
    "ARBOL_DEP_COD" VARCHAR2(5), "CARBOL_DEST_COD" VARCHAR2(5)) PCTFREE 10 PCTU"
    "SED 40 INITRANS 1 MAXTRANS 255 LOGGING
    STORAGE(INITIAL 2147483646 NEXT 1274"
    "150912 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 50 FREELISTS 1 FREELI"
    "ST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "ASYCUDA_DATA_TRA""
    IMP-00003: ORACLE error 3113 encountered
    ORA-03113: end-of-file on communication channel
    IMP-00000: Import terminated unsuccessfully

    ReplyDelete

Subscribe to: Post Comments (Atom)