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

Thread: ORA- 03113 : end of file on communication channel in oracle817

  1. #1
    Join Date
    Oct 2000
    Posts
    57

    This morning onwards i am getting ORA- 03113 : end of file on communication channel in oracle 817 . I looked on to metalink , they suggest the following recommandations

    1. Remove prespawn from lsitener file.

    2. Remove (PROGRAM=****) line from the SID_DESC .

    My listener file already has these two .

    What else shall i look on to .

    thanks in advance
    thomas.




  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    IF that application is taking to the MTS and your server is in the shared mode then it is possible to see this problem. Once way to get out of this problem is to create an tnsname.ora that would have SERVER=DEDICATED and then point your application to talk to that service. Also you minght want to check your iostat and figure out the network congesstion. Some times it would be because there is not enough sort area. For every thing try the first option.

    Good luck
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Oct 2000
    Posts
    57

    Thanks for the info,

    Here MTS is not configured , recently we put following in parameter file . I think this entry may be the cause .

    NAME TYPE VALUE
    ------------------------------------ ------- ------------------------------
    event string 3113 trace name errorstack


    around 40 % is the iowait for this server .

    thanks





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