Page 1 of 1

oracle database

PostPosted: 08. July 2011 16:32
by 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

Re: oracle database

PostPosted: 08. July 2011 18:26
by 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... :shock:

8)

Re: oracle database

PostPosted: 08. July 2011 19:44
by 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?

Re: oracle database

PostPosted: 08. July 2011 21:25
by 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...

Re: oracle database

PostPosted: 01. November 2011 20:50
by 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

Re: oracle database

PostPosted: 02. November 2011 19:25
by 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
8)

Re: oracle database

PostPosted: 04. November 2011 19:53
by 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