oracle database

Problems with the Linux version of XAMPP, questions, comments, and anything related.

oracle database

Postby torpedo91 » 08. July 2011 16:32

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
torpedo91
 
Posts: 2
Joined: 08. July 2011 16:21

Re: oracle database

Postby JonB » 08. July 2011 18:26

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)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: oracle database

Postby torpedo91 » 08. July 2011 19:44

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?
torpedo91
 
Posts: 2
Joined: 08. July 2011 16:21

Re: oracle database

Postby JonB » 08. July 2011 21:25

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...
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: oracle database

Postby perrohunter » 01. November 2011 20:50

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
perrohunter
 
Posts: 1
Joined: 01. November 2011 20:46
Operating System: Oracle Linux 5

Re: oracle database

Postby JonB » 02. November 2011 19:25

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)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: oracle database

Postby temaqueja » 04. November 2011 19:53

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
temaqueja
 
Posts: 1
Joined: 04. November 2011 17:48
Operating System: CentOS


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 11 guests