Apache Friends Support Forum

I am trying to connect to an Oracle database from a Linux server using XAMPP. The server is remote.

I have tried every possible tuorial online and get a myriad of errors. I have tried instant client, full client, etc. with no luck.

Does anyone have clear instructions on how to get this working?

Any assistance would be greatly appreciated!

MANY THANKS!

Jason

I am using PHP to connect.

Hi Guys

I am getting this error while trying to configure oci8 for my lampp installation. Can someone please help?

Code: Select all

[root@ lampp]# ./lampp oci8
Please enter the path to your Oracle or Instant Client installation:
[/opt/oracle] /app/oracle/product/10.2/db
installing symlink...
patching php.ini...
OCI8 add-on activation likely successful.

<b>Warning</b>: PHP Startup: Unable to load dynamic library '/opt/lampp/lib/php/extensions/no-debug-non-zts-20090626/php_oci8.dll' - /opt/lampp/lib/php/extensions/no-debug-non-zts-20090626/php_oci8.dll: cannot open shared object file: No such file or directory in <b>Unknown</b> on line <b>0</b><br />
[root@qa-batchsked lampp]#


Error Message:
============

Warning: PHP Startup: Unable to load dynamic library '/opt/lampp/lib/php/extensions/no-debug-non-zts-20090626/php_oci8.dll' - /opt/lampp/lib/php/extensions/no-debug-non-zts-20090626/php_oci8.dll: cannot open shared object file: No such file or directory in Unknown on line 0

Hi friends!

I had the same problem. However, I solved it comment the line ";extension=php_oci8.dll" in the file php.ini and run the command /opt/lampp/lampp oci8 . But I could not connect to Oracle.

I need help please all the procedure for install the oracle client and configure the xampp its ok, but still i get the next error: Fatal error: Call to undefined function oci_connect() in /opt/lampp/htdocs/cnxoracle/index.php on line 4

This is the code:

<?php
PutEnv("ORACLE_HOME=/opt/lampp/lib");
PutEnv("TNS_ADMIN=/opt/lampp/lib");
$c1 = oci_connect("user", "pass", "TNSNAME");
if(!$c1){
echo "Failed';
}else{
echo "Successful";
}
?>

thanks for your help.