This is only a guess but for Windows 2000, is there a file in your oracle
directory called initxxxxxxxx.ora?  The x's would be the instance name.  You
might have a maximum number of users defined in that file which is limiting
your persistent connections.  Check license max users (license_max_users)
and license max sessions (license_max_sessions).  You can also set license
session warning (license_sessions_warning) which will give you a warning
message when the number of connections is reached before a failure message
is generated.  If you dont' have this file, then check your oracle.reg file.

In actuality, Oracle should not crash when it hits the max users.  It should
only return an error message.  You might want to open up a problem report
with Oracle or search their site for possible fixes.

I haven't dealt with Windows 2000.  My experience is with Solaris so I'm not
sure if the setup is the same.  I assume it is.

Good luck!

-----Original Message-----
From: Ventsyslav Vassilev <[EMAIL PROTECTED]>
Date: Friday, July 20, 2001 3:55 AM
Subject: [PHP-DB] Persistent connection: Yes or Not?

>Recently i have faced the following issue:
>I have a site running Apache 1.3.19 under Windows 2000 pro/PHP
>After a little load Apache crashes with ORA-00020 error - maximum number of
>Ora connections exceeded. This problem seems to be faced very often by
>people. Limit in ora.reg is 50, but the other told me that even value of
>does not resolve the issue.
>After i started  to use OCILogon() function instead of OCIPLogon() the
>problem was solved and the site speed is not affected in any way.
>But is this the correct way or...?
>Ventsyslav Vassilev
>Comel Soft Multimedia
>Sofia, Bulgaria
>ICQ UIN: 11199819
>PHP Database Mailing List (
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to