DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: testing base-on Oracle 8i problem

  1. #1
    Join Date
    Mar 2001
    Posts
    1

    Unhappy

    Hi,

    I tested my project on Oracle 8i on Windows 2000 Server (Build No. 2195). When I checked log files, I found the error information:
    com.ibm.vap.common.VapReadFailureException:_Cannot_read_from_the_database 500 -
    and
    java.lang.RuntimeException:+Connection+failed+with+driver:+oracle.jdbc.driver.OracleDriverreason:+ORA-00020:+maximum+number+of+processes+(59)+exceeded
    302 -
    I checked my machine class path, the 'classes111.zip', 'sqlj\lib\traslator.zip' and 'jdk1.1.8' etc. all are put in.

    I don't kwon what is wrong for me.

    Who can help me?

    Regards,

    Daniel

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I would start looking at your processes parameter in the init.ora file because of the ORA-00020:+maximum+number+of+processes+(59)+exceeded message...
    Jeff Hunter

  3. #3
    Join Date
    Feb 2001
    Posts
    163
    jdbc,

    One thing I would look for is the way your code is being executed. I have seen similar errors in the following situations and they may or may not apply to you. This has nothing to do with your JDBC or JAVA class paths etc.

    1. Processes are exceeded so, check the processes value in the init.ora and fix it.

    2. Check the java code and make sure that developers are releasing the connections they use to run their queries. If not, the connections stay open and any new query used by another session will open more processes.

    Also,

    There was a known bug with Compaq hardware. Check the following note on metalink. Insight manager on Compaq is known to be causing some issues.

    Note: 2123796.6 ORA-00020 - MAXIMUM # OF PROCESSES EXCEEDED ON COMPAQ SERVER

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width