8 Replies Latest reply on Apr 6, 2011 2:11 PM by Arsalan Dehghanisariyarghan

    ORA-2396

    Karan Kukreja
      Hi all ,

      Hope everyone had a good weekend.. :)



      I got this alert in my alert mail :

      opidcl aborting process unknown ospid (14605_1) due to error ORA-2396


      and the trace file had the following details:

      *********************************************************************
      TNS-00505: Operation timed out
      nt secondary err code: 145
      nt OS err code: 0
      Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xxx.xxx.xx)(PORT=xxxx))
      opidcl aborting process unknown ospid (14605_1) due to error ORA-2396
      Wed Dec 23 10:10:22 2009


      ***********************************************************************

      Does it mean a user tried to connect and was unable to connect because ORA-2396 , which comes when "exceeded maximum idle time, please connect again"

      - from http://ora-02396.ora-code.com/


      and in the above error, what does this mean : opidcl aborting process unknown ospid (14605_1)
        • 1. Re: ORA-2396
          CKPT
          I think you have the answer :)

          Error: ORA 2396
          Text: exceeded max Idle Time, please connect again
          -------------------------------------------------------------------------------
          Cause: A user has exceeded the maximum time allowed to remain idle.
          Action: The user must reconnect to the database.

          reconnect database again.
          or you can change in the profile "IDLE_TIME" resource

          post
          select resource_name,limit from dba_profiles where resource_name='IDLE_TIME';
          check http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_2007.htm

          Edited by: CKPT on Nov 15, 2010 11:37 AM
          1 person found this helpful
          • 2. Re: ORA-2396
            Karan Kukreja
            Hi CKPT. thanks for immediate response.

            Could you please elaborate on this : "opidcl aborting process unknown ospid (14605_1)"

            what is exactly opidcl ?

            what it seems to me is :

            <something> is aborting process <unknown> with ospid (14605_1)

            what is that something ? as in opidcl , what is it ? and what is <unknown> here ?



            thanks..

            i know its a little confusing question .. :( :O
            • 3. Re: ORA-2396
              Chinar
              what is that something ? as in opidcl , what is it ? and what is <unknown> here ?
              This is a function which called when session disappear.
              1 person found this helpful
              • 4. Re: ORA-2396
                CKPT
                Hi,

                I forgot to ask what the DB Versio, can you post

                and any errors followed with ORA-2396 is so please post
                aborting process unknown ospid
                it may be with so many incidents may be due to PMON or any internal errors...
                • 5. Re: ORA-2396
                  Karan Kukreja
                  @ Chinar : Thanks :)


                  @ CKPT : database version 11.1.0.7

                  and yeah i will post the entire part of the trace file where the error started and where it ended.



                  ***********************************************************************

                  Fatal NI connect error 12170.

                  VERSION INFORMATION:
                  TNS for Solaris: Version 11.1.0.7.0 - Production
                  Oracle Bequeath NT Protocol Adapter for Solaris: Version 11.1.0.7.0 - Production
                  TCP/IP NT Protocol Adapter for Solaris: Version 11.1.0.7.0 - Production
                  Time: 12-NOV-2010 10:53:07
                  Tracing not turned on.
                  Tns error struct:
                  ns main err code: 12535

                  TNS-12535: TNS:operation timed out
                  ns secondary err code: 12560
                  nt main err code: 505

                  TNS-00505: Operation timed out
                  nt secondary err code: 145
                  nt OS err code: 0
                  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xxx.xxx.xxx)(PORT=xxxx))
                  opidcl aborting process unknown ospid (23231_1) due to error ORA-2396
                  Fri Nov 12 21:33:12 2010
                  Starting background process CJQ0
                  < startup continues from here >

                  ______________________________________________
                  I also observed that this error is not new in the alertfile.. this has been coming since the last 1 year.. Since now i have moved into project , i thought may be i could resolve this.
                  it doesn come very often though..
                  • 6. Re: ORA-2396
                    CKPT
                    Read Tom article


                    http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5671284058977

                    Thanks
                    1 person found this helpful
                    • 7. opidcl aborting process unknown ospid (629_1) due to error ORA-2396
                      Karan Kukreja
                      Hi CKPT ,

                      How are you ?

                      I am on oracle 11G SPARC machine .

                      I checked the link you have mentioned. It simply says that the network connection is breaking down and this process is cleaning it. Also , it speaks that we need to alter the profile.

                      I checked in my database , but the profile that is being used for all the schemas is either set to unlimited or to 120 minutes.

                      So what could be the reason ?

                      The error in the alert log is:
                      opidcl aborting process unknown ospid (629_1) due to error ORA-2396
                      Also , can you please tell me the severity of such an error. ? How severe is this error ?


                      Regards
                      Kk

                      Edited by: Kk on Apr 6, 2011 4:47 AM