Hi Steve,

if you use OciPLogon to connect to ORA, bad luck.
Replace with OCiLogon and your problesm are gone.
Of course, *always* remember to ocilogoff() your open connections.
In my experience OCIPLogon is broken. It never closes open connections
to ora, instead it waits for them to timeout, even if ocilogoff has been
called, not a very smart thing...
other than that, I have not encountered any problems with SSL or non-SSL
connections.
Yes, the number of open connections is affected by the ora control file.
I think the default is 50, which should be enough for most applications.
To change it, you have to restart ora (at least).

Good Luck,
-Stathis.

Steve Farmer wrote:
> 
> hi Brian,
> 
> I'm curious to know whether or not you are using persistent
> connections from Oracle.
> 
> And do your problems disappear if you restart the Oracle db?
> 
> We are having some problems with to many sessions being created with
> persistent connections and we think there are a couple of parameters
> ..
> 
> 1) no of connections allowed in apache. (this could explain why SSL
> id different to NON-SSL connections)
> 
> 2) no of sessions an oracle user is allowed to create.
> 
> 3) How many connections we provide in the oracle listener connection pool.
> 
> Regards
> Steve Farmer
> 
> At 1:41 PM -0600 9/3/01, Brian.J.Mauter wrote:
> >Hello,
> >
> >I am running an Apache 1.3.19 server with mod_ssl, PHP 4.0.4pl1, and
> >Oracle 8.1.6.
> >
> >Oracle is only installed so that we could compile PHP --with-oci8.  When I
> >originally got everything going, it worked well.
> >
> >After about two weeks, PHP works fine, Apache works fine, but when I try
> >to logon to the Oracle database (via TCP), I get an ORA-03106 error on the
> >OCISessionBegin statement.  I can write another php page logging into the
> >database and everything seems to work fine.
> >
> >If I go to another server setup exactly the same as the first, the same
> >script will work just fine.  After about two weeks, the script runs great
> >via https, but not plain http.  It's really fast with https.
> >
> >You're welcome to see what I'm talking about with:
> >
> >FIRST:
> >http://cbhp.ua.edu/~bmauter/oracle.php?query=select+*+from+meal
> >
> >SECOND:
> >http://airwest.cba.ua.edu/~bmauter/oracle.php?query=select+*+from+meal
> >
> >THIRD:
> >https://airwest.cba.ua.edu/~bmauter/oracle.php?query=select+*+from+meal
> >
> >If anyone has had similar problems, please let me know.  I have no idea
> >what is going on.
> >
> >Thanks in advance,
> >
> >Brian Mauter
> >
> >
> >--
> >PHP Database Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> --
> ---------------------------------------------------
> "Minds are like parachutes, they work best when open"
> Support free speech; visit http://www.efa.org.au/
> 
> Heads Together Systems Pty Ltd http://www.hts.com.au
> Email: [EMAIL PROTECTED]     Tel: 612 9982 6767     Fax: 612 9981 3081
> 
> --
> PHP Database Mailing List (http://www.php.net/)
> 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 (http://www.php.net/)
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