oracle oDBC ORA-03113 end of file on communication channel
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: oracle oDBC ORA-03113 end of file on communication channel

  1. #1
    Join Date
    May 2006
    Posts
    51

    oracle oDBC ORA-03113 end of file on communication channel

    we are getting oDBC ORA-03113 end of file on communication channel after upgrading database from 9.2.0.6 to 9.2.0.7 version.
    Any quick fix would be appreciated

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    more information would be apreciated too

  3. #3
    Join Date
    May 2006
    Posts
    51
    This is happening when we do update a user, remove a user, update password. Any clue dave.

    These are the messages in alert log

    Errors in file /u01/app/oracle/admin/IPRD/udump/iprd_ora_209178.trc:
    ORA-00313: open failed for members of log group 1 of thread 1
    ORA-00312: online log 1 thread 1: '/redo02/oradata/IPRD/redo1b.log'
    ORA-27037: unable to obtain file status
    Last edited by vision; 11-07-2006 at 05:01 PM.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    does the file exist

  5. #5
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Is database opened?
    The fragment of the alert.log you posted woudl most probably leave the database just mounted.
    I suspect the part of the aletr.log you posted is completely unrelated to the ora-3113 (please note, the part of the alert.log you posted contains ORA-00313 NOT ora-03113)

    Ora-3113 is most oftenly caused by unexpected crash of the dedicated server process. Of cource if the database crashes, that would be the result too.
    You'll need to find the trace file generated by the ora-3113 and it will probably contain the query which breaks the server.

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