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.
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
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