Urgent Ora-03113, Ora-03114
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Urgent Ora-03113, Ora-03114

  1. #1
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249

    Urgent Ora-03113, Ora-03114

    We have connected our one site through radio frequency link.


    Now some times not always client lost the connection with Oracle
    server with ORA-03113 or ORA-03114.

    In our Local area network we are not facing this problem.

    The error log is also not generated. Not in UDUMP or BDUMP

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    ORA-03113 end-of-file on communication channel

    Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8 two-task software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.

  3. #3
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Is there any solution for that?

    Because after error if client connect throgh other session it works
    fine.

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    My guess is intermittant network problems - i.e. the quality of the radio link. Can this be monitored? Can it be correlated with the errors?

  5. #5
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Thanks for your reply

    Before some days i have changed my database server. Old server was running with 100 MBPS and new server run with 1 GBPS adapter.

    I am facing this problem since i have changed my server.

    The error was not encounter in old server.


    I have just restore the cold backup from my old server.

  6. #6
    Join Date
    Apr 2003
    Posts
    353
    Any previous database was there in the new system?

    Any upgrade done..?
    (If so not running catpatch.sql caused the same error once for us.)

    If first one is the case, start your db using pfile,
    and try.

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