2 Replies Latest reply on Jan 12, 2006 6:43 AM by 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
          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.
          • 2. Re: ORA-12520

            Thanks for the info. The problem is solved.

            Vinoth V