oracle database

[torpedo91]

Good day all

i am trying to connect to an orale database . i uncommented : php_oci8.dll ,php_pdo_oci.dll in the php.ini . However when i restart xampp i am getting this error. is there anything else i need to do to connect to the oracle database.

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

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

[JonB]

where to start?

OK - the part (wherever you found it) about uncommenting the DLL's applies to Windows servers.

AFAIK Linux uses the .so concept (shatred objects)

More AFAIK -

AFAIK 2 -

XAMPP does not have built-in support for Oracle - period, none of the versions do.

http://www.apachefriends.org/en/xampp-linux.html

You 'should' be able to connect via ODBC, or the Oracle Instant client, however.

More AFAIK -

You should use those tricky search engines things, Like Google 'Oracle on XAMPP'

http://www.apachefriends.org/en/faq-xam ... .html#oci8

That's specific to Oracle 8.

next Google trick -

XAMPP oracle 10g

You will need to get the Oracle Instant Client, it seems

And how did I start this search???, with the Search Forum box


Good Luck, and remember Google is your next best friend after your mangy mutt...

[torpedo91]

i tried this command found on the xampp site : /opt/lampp/lampp oci8

and this is what it produced.

installing symlink...
patching php.ini...
OCI8 add-on activation likely successful.
XAMPP: Stopping Apache with SSL...

Warning: PHP Startup: Unable to load dynamic library '/opt/lampp/lib/php/extensions/no-debug-non-zts-20090626/oci8.so' - libclntsh.so.10.1: wrong ELF class: ELFCLASS64 in Unknown on line 0

Warning: PHP Startup: Unable to load dynamic library '/opt/lampp/lib/php/extensions/no-debug-non-zts-20090626/oci8.so' - libclntsh.so.10.1: wrong ELF class: ELFCLASS64 in Unknown on line 0
XAMPP: Starting Apache with SSL (and PHP5)...

What do the 2 warnings indicate?

[JonB]

a GUESS only -

Are you on 64 bit server????

If so check if the 32 bit libraries are installed.

Good Luck

(my two Linux severs are currently toast, so I have no way of checking)

it was warning, so it may be things are actually working...

[perrohunter]

I have the same scenario, and even though I get the same warning the phpinfo() doesn't display the oci8 extension as being installed, I have tried so many ways to get the instalclient for oracle 11g to work that I've run out of ideas.

I pointed /opt/lampp/lampp oci8 to my oracle DB home and it copied all the files to /opt/lampp/lib/instaclient but with no luck, I only see the working when I execute the php binary from lampp/bin

For what I read the way the oci8 extension is installed is just fine, what could we be doing wrong?

CHeers

[JonB]

I "think" you can only have one Oracle client installed. Therefore, if you wanted to use the Oracle supplied 'Instant Client', you would have to disable the OCI 8 client that is included with XAMPP.

Good Luck

[temaqueja]

Temp and fast way:

setenforce 0
seen at FAQ: http://www.apachefriends.org/en/faq-xampp-linux.html#sel

The good way:

1. catch error log:
tail -f /var/log/audit/audit.log | tee oracle.log
cat oracle.log
2. add exception:
audit2allow -M oracle < oracle.log
semodule -i oracle.pp
3. restart:
./lampp stop
./lampp start