oracle 9 apahce 2 connection / php

shakim · 11-03-2003, 11:59 AM

I am using php 4.3.2, apache 2, oracle 9i, and everything is running on linux Suse. I created a connection to oracle using php and the connection wizard in dreamweaver mx. I got the connection to work using php-adodb server model. But I am getting a weird problem. After I get the connection to create successfully, and create a recordset, after a few minutes the connection fails. It seems that apache hangs up the connection or something. I have to go into apache 2.0 and restart it. Them it comes back again. And the same thing happens again. Any thoughts.

adam_uk · 11-03-2003, 01:50 PM

have you checked to see what your system resources are doing?

what spec is the server?

shakim · 11-03-2003, 01:56 PM

Everything is on a linux machine. Suse. Is there anything in particular I need to look for? I have enough storage, cpu power. What else is there?

adam_uk · 11-04-2003, 12:50 PM

you say you have enough

but have to checked to see wether the cpu is getting killed

also check your apache/oricle configuration and see if there are any time out errors or something.

i cant be much more help because ive never used oracle so all i can say is double check your apache/oracle and even php configuration

11-03-2003, 11:59 AM	THREAD STARTER #1 (permalink)
shakim New Member Join Date: May 2003 Posts: 19	oracle 9 apahce 2 connection / php I am using php 4.3.2, apache 2, oracle 9i, and everything is running on linux Suse. I created a connection to oracle using php and the connection wizard in dreamweaver mx. I got the connection to work using php-adodb server model. But I am getting a weird problem. After I get the connection to create successfully, and create a recordset, after a few minutes the connection fails. It seems that apache hangs up the connection or something. I have to go into apache 2.0 and restart it. Them it comes back again. And the same thing happens again. Any thoughts. __________________ "Knowledge Speaks and Wisdom Listens"

11-03-2003, 01:56 PM	THREAD STARTER #3 (permalink)
shakim New Member Join Date: May 2003 Posts: 19	Everything is on a linux machine. Suse. Is there anything in particular I need to look for? I have enough storage, cpu power. What else is there? __________________ "Knowledge Speaks and Wisdom Listens"

11-03-2003, 01:50 PM	#2 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,187	have you checked to see what your system resources are doing? what spec is the server?

11-04-2003, 12:50 PM	#4 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,187	you say you have enough but have to checked to see wether the cpu is getting killed also check your apache/oricle configuration and see if there are any time out errors or something. i cant be much more help because ive never used oracle so all i can say is double check your apache/oracle and even php configuration

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)