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]
