mysexybluefeet
July 18th, 2014, 03:06 AM
Hey Guys,
I'm a bit stuck on my troubleshooting. I've installed oracle and php and apache using http://gunbladeiv.blogspot.com.au/2011/11/ubuntu-apache-php-oracle-with-oci8.html and I can get php and oracle working correctly but when I try to run it via apache it doesn't connect to the database. I have a script doing the f
$conn = oci_connect('user','passsword','host');
if (!$conn) {
echo "conn not established";
}
if ($conn) {
echo "conn established";
}
and if I run it via php, the connection is established. But when I visit it via localhost/script.php, I get connection is not established. Any ideas? I've restarted apache after every change. I have run php_info with the following:
php_info()
oci8
OCI8 Support => enabled
OCI8 DTrace Support => disabled
OCI8 Version => 2.0.8
Revision => $Id: f04114d4d67cff
I feel it could be the environment that I've set for ORACLE_HOME - what file/files/folder should I specifically be pointing to (as in where i installed the skd and basic oracle packages, in its /lib etc)
I have noticed when I restarted oracle i get this:
Shutting down Oracle Database 11g Express Edition instance.
Stopping Oracle Net Listener.
Starting Oracle Net Listener.
Starting Oracle Database 11g Express Edition instance.
Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Oracle Express Database using /u01/app/oracle/product/11.2.0/xe/bin/sqlplus.
I'm a bit stuck on where to go from here. Any help is greatly appreciated.
I'm a bit stuck on my troubleshooting. I've installed oracle and php and apache using http://gunbladeiv.blogspot.com.au/2011/11/ubuntu-apache-php-oracle-with-oci8.html and I can get php and oracle working correctly but when I try to run it via apache it doesn't connect to the database. I have a script doing the f
$conn = oci_connect('user','passsword','host');
if (!$conn) {
echo "conn not established";
}
if ($conn) {
echo "conn established";
}
and if I run it via php, the connection is established. But when I visit it via localhost/script.php, I get connection is not established. Any ideas? I've restarted apache after every change. I have run php_info with the following:
php_info()
oci8
OCI8 Support => enabled
OCI8 DTrace Support => disabled
OCI8 Version => 2.0.8
Revision => $Id: f04114d4d67cff
I feel it could be the environment that I've set for ORACLE_HOME - what file/files/folder should I specifically be pointing to (as in where i installed the skd and basic oracle packages, in its /lib etc)
I have noticed when I restarted oracle i get this:
Shutting down Oracle Database 11g Express Edition instance.
Stopping Oracle Net Listener.
Starting Oracle Net Listener.
Starting Oracle Database 11g Express Edition instance.
Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Oracle Express Database using /u01/app/oracle/product/11.2.0/xe/bin/sqlplus.
I'm a bit stuck on where to go from here. Any help is greatly appreciated.