What's the exact error you get when you try to connect to oracle and what command are you using to connect?

Does a phpinfo() script show the Oracle env vars correctly under the
"Environment" section?


Luis Moran Ochoa wrote:

These are the exact details...

/usr/oracle permissions 750 owner oracle.oinstall
apache belongs to oinstall.

script permissions in /etc/init.d/apache --> 755

ORACLE_SID=OWEB ; export ORACLE_SID; ORACLE_HOME=/usr/oracle/product; export ORACLE_HOME;
TNS_ADMIN=/usr/oracle/product/network/admin; export TNS_ADMIN;
ORACLE_BASE=/usr/oracle; export ORACLE_BASE;
ORA_NLS33=/usr/oracle/product/ocommon/nls/admin/data; export ORA_NLS33;
ORA_NLS=/usr/oracle/product/ocommon/nls/admin/data; export ORA_NLS;
NLS_LANG=spanish_spain.we8dec; export NLS_LANG;
TNS_ADMIN=/usr/oracle/product/network/admin; export TNS_ADMIN;
CLASSPATH=:/usr/local/jre:/usr/oracle/product/jdbc/lib/classes111.zip: export CLASSPATH;

case "$1" in start) /opt/apache/bin/apachectl startssl ;; stop) /opt/apache/bin/apachectl stop ;; esac

But the problem is the next:

When I login as root (on a console or an xterm) and run that script (/etc/init.d/apache start) everything works

So I've created a link from /etc/rc5.d/S99apache to /etc/init.d/apache for starting it during boot process......

But when I reboot the system and apache is started on boot (oracle is launche thru S20oracle), it start. If you request a php page or other
kind of webpage it works fine, until you request a php page that connects to oracle.... Then the instance that is serving that request dies,
raise an error that says something like "Couldn't connect to database" and no more php+oracle pages can be requested... But php and apache
still works.....

If I stop apache and launch it again from console using /etc/init.d/apache start.... It works again and works fine, all connections are successfull.....

User apache belongs to oinstall group and have read and execution access to all the oracle directories.

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to