DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: ORA-03113: end-of-file on communication channel when trying to insert rows!

  1. #1
    Join Date
    Sep 2001
    Location
    Mexico
    Posts
    93

    Unhappy ORA-03113: end-of-file on communication channel when trying to insert rows!

    Hi everybody,

    I'm disconnected from oracle when I'm trying to insert rows to a specific table. I'm using Oracle 9iR2 on Windows XP.

    This is an example that what is happening:

    SQL> connect myuser/pass@myservice

    Connected.
    SQL> select * from sustancia_tempo;

    ID_ACTIVO ID_SUSTANCIA ID_ESTMATERIA ID_UNIDMEDIDA CANTIDAD NUM_ONU K_FUG_FE K_NUM_FUGA K_INSTA
    ---------- ------------ ------------- ------------- ---------- ---------- -------- ---------- ------
    4 2 2 2 23 11 10/03/98 104 GBTJSAPR 221 2
    4 2 2 2 12 22 10/03/98 104 GBTJSAPR 221 3
    4 1 1 1 0 222222 10/03/98 104 GBTJSAPR 221 1
    4 2 2 2 23 23 10/03/98 104 GBTJSAPR 221 4

    SQL> delete from sustancia_tempo;

    4 rows deleted.

    SQL> INSERT INTO SUSTANCIA_TEMPO ( id_activo, k_fug_fecha, k_num_fuga, k_instalacion, k_distrito
    , cantidad, id_estmateria, id_sustancia, id_unidmedida, num_onu )
    2 VALUES ( 1, to_date ('01-01-2003', 'dd-mm-yyyy'), 1, '1', '1', 10, 1, 1, 1, 'xx' )
    3 /
    INSERT INTO SUSTANCIA_TEMPO ( id_activo, k_fug_fecha, k_num_fuga, k_instalacion, k_distrito, can
    *
    ERROR at line 1:
    ORA-03113: end-of-file on communication channel


    Any help to solve this question will be very appreciated.
    Thanks in advance.

    Regards.

  2. #2
    Join Date
    Apr 2003
    Location
    South Carolina
    Posts
    148
    Have you looked into the Alert and User Dump logs to see what they
    tell you ???

  3. #3
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97

    Lightbulb

    This table have some relationship / constraint by DBLINK ?
    Last edited by marcio.68; 07-22-2003 at 02:24 PM.
    Márcio de Souza Almeida
    DBA Oracle / SQLServer / PostgreSQL
    Rua Cupa, 139 Apto 85 A
    Penha - São Paulo - SP
    03640-000 - Brasil
    http://www.directory.com.br

  4. #4
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422

    Re: ORA-03113: end-of-file on communication channel when trying to insert rows!

    Originally posted by Turin
    ORA-03113: end-of-file on communication channel
    this usually means that you have ora-600 or ora-7445 in your alert log and user dump.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by marcio.68
    This table have some relationship / constraint by DBLINK ?
    No such thing exists. You can't have RI constraint/relationship defined on the table that is accessed through DB link. Unless you coded that integrity constraint yourself wit a trigger(s), but then this is not what is usualy understand as referential integrity (declarative RI).
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Sep 2001
    Location
    Mexico
    Posts
    93
    The table doesn't have any constraint/primary key.

    I found a trigger on the table is the problem. So I changed the code encapsulling all of it (trigger + insert ) in a store procedure and it runs ok, but I don't know what is the problem with the trigger.

    This is the code inside the trigger (before insert trigger):


    SELECT COUNT(*)+1
    INTO :NEW.ID_CONSEC
    FROM SUSTANCIA_TEMPO;

    Regards.
    Last edited by Turin; 07-22-2003 at 06:24 PM.

  7. #7
    Join Date
    Jul 2003
    Posts
    59
    You should look into Oracle sequences to provide you with a one-up counter unique ID. The count(*) method (whether in a stored proc or in a trigger itself) is going to get slower and slower as the table grows.
    Tom Best

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width