2 Replies Latest reply: Jan 12, 2006 12:43 AM by 452152 RSS

    ORA-12520

    452152
      ORA-12520 TNS:Listener count not find available handler for requested type of server
      I am getting this error while running Oracle 10g in tomcat. For few hours server runs without any problems, but after wards, this error is thrown and nothing works thereafter.
      Pls help!
        • 1. Re: ORA-12520
          107036
          I have the same error, in a local connection to the Database with sqlplus, I've had the ERROR: ORA-00020 maximum number of processes exceeded.

          I've to restart de database, raise the PROCESSES parameter in init.ora

          Additionally lower the connection pooling in tomcat and investigate if your connections to DB are hanging up due to locks or other reasons...

          Hope it will help.
          Agusti
          • 2. Re: ORA-12520
            452152
            Hi,

            Thanks for the info. The problem is solved.

            Regards,
            Vinoth V