sorry forgot to mention that there are alter system kill session sql during that time when the client process dies . SQL> select sql_text from v$sqlarea where sql_text like 'alter system%' ; ALTER SYSTEM kill SESSION '627,188' ALTER SYSTEM kill SESSION '620,1950' On Dec 17, 2007 4:59 PM, Prasad <p4cldba@xxxxxxxxx> wrote: > Hi Krish, > > Oracle support took a while to get back to me on this . and there research > is that the current 9.2 client is affected by the below bugs . > > Bug.4952119 (90) SQLNET.OUTBOUND_CONNECT_TIMEOUT NOT CAN CELLED AFTER > CONNECTION ESTABLISHMENT: > Bug 4933023. Bequeath connections fail if SQLNET.OUTBOUND_CONNECT_TIMEOUTis > set > and these bugs are Fixd in 10.2.0.3. > > and they want me to upgrade it to 10.2.0.3 . I will update my findings . > > thanks > -Prasad > > > > On Dec 13, 2007 11:11 PM, <krish.hariharan@xxxxxxxxxxxx > wrote: > > > Didn't solve the mystery but eliminated a couple of paths since I was > > curious about the error. If you have resource limit set and profile with > > idle time, or your server process was killed, you get a different error than > > the ORA-28. It then appears that only a kill session tends to yield this > > error. > > > > > > > > I am curious, however, about the timing of the message and the error > > stack. These errors are not reported until the client tries to act again. > > Would that still maintain information about the circumstances that caused > > the disconnect? > > > > > > > > -Krish > > > > > > > > Not sure if you had already checked the sql area and su log > > > > > > > > SQL> select sql_text from v$sqlarea where sql_text like 'alter system%' > > ; > > > > > > > > SQL_TEXT > > > > > > -------------------------------------------------------------------------------- > > > > alter system kill session '28,29909' > > > > alter system set resource_limit = true > > > > > > > > > > > > IDLE Time > > > > --------------- > > > > SQL> select to_char(sysdate, 'DD-MON-YYYY:HH24:MI:SS') cdate from dual ; > > > > select to_char(sysdate, 'DD-MON-YYYY:HH24:MI:SS') cdate from dual > > > > * > > > > ERROR at line 1: > > > > ORA-02396: exceeded maximum idle time, please connect again > > > > > > > > Kill Session > > > > ------------------ > > > > SQL> select to_char(sysdate, 'DD-MON-YYYY:HH24:MI:SS') cdate from dual ; > > > > select to_char(sysdate, 'DD-MON-YYYY:HH24:MI:SS') cdate from dual > > > > * > > > > ERROR at line 1: > > > > ORA-00028: your session has been killed > > > > > > > > Server process killed > > > > -------------------------------- > > > > SQL> select sysdate from dual ; > > > > select sysdate from dual > > > > * > > > > ERROR at line 1: > > > > ORA-03113: end-of-file on communication channel > > > >