LINUX AND DBD-Oracle - Instant Client(Archived)

Are there any plans to include the header files necessary to complie the Perl Moduld DBD-Oracle? 

We are currently investigating the capability. 

Outstanding... It is kind of a pain to install Oracle in order to compile one perl app.

Any news about this?
I need a working DBD::Oracle under RedHat Enterprise Linux 3.0 and was thinking I don't have to install xwindows and the oracle client using the graphical installer when using the instant client...WRONG ;-( 

My understanding is work is progressing. (Toliver is on
vacation so I don't have an official update)
What files/directory structure in the SDK will help you
build DBD? I've been working with the OCI team to make sure
PHP can be built easily with the SDK but haven't looked at
DBD myself.
-- CJ 

I don't know the exact filenames.
The packages I select when installing the client are:
- Oracle Call Interfaces (this is what is needed for compiling DBD::Oracle)
- SQL*Plus
- Oracle Network Utilities 

I just compiled DBD::Oracle 1.15.
This is the interesting part of the output:
Found /u01/app/oracle/product/10.1.0/client_1/rdbms/demo/
Using /u01/app/oracle/product/10.1.0/client_1/rdbms/demo/
Reading /u01/app/oracle/product/10.1.0/client_1/rdbms/demo/
Reading /u01/app/oracle/product/10.1.0/client_1/rdbms/lib/ 

-- CJ 

Any news CJ? 

We will be releasing an SDK for Instant Client sometime after the release of (next patchset). Please watch the official Instant Client website for official updates.

Dear Toliver,
When did we expect to have this patch? I, and I presume a lot of people, are waiting on it to deploy DBD-Oracle perl module.
Best regards.


Oracle 11g JAccelerator (NCOMP) intermedia image accelerator

With Multimedia in 11g, do we still need to install the companions CD (I think it's called examples now), or is this natively included in the 11g installation?
A new feature in Oracle JVM is a just-in-time (JIT) compiler for the Oracle JVM environment. A just-in-time (JIT) compiler is a program that converts Java bytecodes into machine language instructions at runtime. With JIT, there is no need to pre-build libraries and ship them on the Oracle kit. JIT is available on most platforms for which NCOMP was available in previous versions. Therefore, there is no longer a need to install the Oracle Multimedia Image Accelerator, and it is not available on platforms that support JIT.
For the one or two platforms for which NCOMP is still provided because JIT is not yet available, the NCOMP libraries should not be on the Examples media because that is available for OTN download only. If you want information about a specific platform, let me know what it is and I'll find the specifics.
you can use the command
show parameter java_jit_enabled;
to learn if the JIT compiler is enabled in your database. 
Hi Sue,
Thanks for your reply. We're running Solaris 10 with SPARC64 VI, so if you have any details about that specific version I'd appreciate it.
Thanks again,
My expectation would be that the Solaris port would have JIT enabled.
Have you tried the show parameter java_jit_enabled command? 
Hi -
Thanks again for the reply. I'm actually building the system now and will install Oracle 11g in a few weeks, but wanted the know ahead of time if I needed to plan on adding in the Companion CD install after the DB Server and before the Database creation, or if it wasn't necessary to do that step. so can't really run that show parameter command yet.
It was a bit unclear also in 10g and I ended up missing that step during the initial 10g install, had to go back and install the Companion CD, reply patches and suffer the downtime for it. Wanted to avoid that again if possible. I'll try poking around some Solaris forums also and see if anyone can shed light on it too. I'll post back here if I find something.
Thanks again;

Installing and using instant client - windows32 c++

I have a question...
I have been trying to figure out for a few days now how to install this OCCI instant client. I set my path variable to my client installlation directory, but the question is how do i actually use the library/driver files in the client through gnu c++ compiler? Can anyone please help me out here? 
What's your client version , Oracle version? You might want to check this link out. 
Most recent oracle and client, version 11 i believe 
Thank you for providing me with that but i have been to many sites and for some reason i still cannot understand how and which libraries to link with gcc for the instant client 
Here is another white paper on this for 11g and it might be helpful to you. You can always find good stuff in oracle documentation 
A lot of that stuff is for the old OCI which you have to have oracle server installed. I thought the whole point of the OCCI client was to connect to a remote server with out having a full installation. If anyone has got this wot work can you please guide me through the process. I have the gcc compiler, which files do i link? What should do?

Where do I find the necessary libs to compile php with oracle suppor

I have a fedora system with apache 1.3 and need to compile php with oracle 8i support.
In my older system (a redhat 7.3) I've managed to compile php with a trick. I've installed oracle in another machine, tar.gz the necessary libs directory and uncompressed in my server /u01.
I was wondering if (and where) I can find a developer version that installs only the necessary files in order to compile php.
At the moment I think you'll have to experiment again.
Everytime I have contact with the right Oracle people I push for an
SDK we can use to build PHP. I hope it happens soon.
In 10g there will be an "Instant Client" (see the announcement on so at least getting the
libraries will become trivial.
-- CJ 
So do you recommend install the database in a separate server and tar the libs/includes necessary ?
What is the oracle/php/linux distro that you are using ?
I am going for a oracle 9/php 4.3.4/fedora.
So do you recommend install the database in a separate server and
tar the libs/includes necessary ?I'm going to refrain from commenting this. I don't know how you
intend to use it, and I don't know much about Fedora.
What is the oracle/php/linux distro that you are using ?At the moment I'm using RH AS 3, a recent 4.3 snapshot, Oracle 9.2 and
a pre-release 10g.
Good luck,
-- CJ
As a followup on the OCI Instant Client, the libraries are downloadable
separately from the full Oracle Client install at:
-- CJ

Client Libraries for 9i

I have looked about everywhere for the Oracle Client Libraries (9i) for Linux. But I just can't seem to find them. Is there somewhere I can download them and compile them on my system?
I would have taken the instantclient, but unfortunatly I can't compile php with that (expects version 9).
Thanks in advance,
You are correct the Instant Client cannot be used to compile PHP. The
Instant Client does not yet have required headers, and the PHP
configuration files will need to be updated when the Instant Client
SDK is released.
Oracle 9 and 10 client software is downloadable from OTN. Go to the
DB product center from the OTN home page and select downloads. See
for the install options to choose.
Recent releases of PHP 4 and 5 compile with Oracle 10g.
This would be my preferred choice when connecting to a
remote release 9 or 10 DB server.
-- CJ 
Thanks for your answer. Do I really need to download all 3 disks just for the client? I already downloaded the first disk and tried to install it, but I don't have an X server installed. Is there a way to install the client on the command line?
Thanks again,
Basic 10g comes on one disk.
Re command-line install there is the concept of response files.
Check the doc or ask on the Installation forum. I've never tried it.
-- CJ

Where is the guide for Apache2/php5/10g/Linux install?
is now sadly outdated considering that the stable releases on all products are now:
Apache -> 2.0.52
Php -> 5.0.2
Oracle ->
I am looking to run namely these software versions on a Linux (Fedora Core and/or Debian) system, but can't find any worthwhile documentation anywhere (oracle, google etc.).
First of all I would like to know if it is even possible to run Apache 2.0.52/Php 5.0.2 with oracle-instantclient-basic-
I know that with Oracle 9i you had to install the whole 300MB client install to get things to work easy, but that time has surely passed?(!)
I am running oracle 10g on a seperate installment, and would like to connect to it with Apache 2 and Php 5. What is the best way to do this?
I don't want to sound rude, and I do not expect a full installation guide, but if somebody could tell me how to do this I would appreciate it. The apache part is easy, the tricky part is the --with-oci8 php part combined with the instantclient (installed correctly and added in
--with-oci8=/usr/lib/oracle/ does not even remotly work. Whats the trick, if any?
Anders Berg
You are correct, it did not work for me either with the instant client on FC2. I had to install the full client, with administrative utilities and then it worked.
The Oracle Instant Client does not include header files. It
can't be used by itself to compile a PHP client for Oracle. (Though
it works well with the pre-built PHP binaries on Windows)
The Instant Client on OTN will include an SDK with headers.
It is "real close now" I believe. A PHP configuration patch will be
required but until I get my hands on the final SDK I don't want to
release anything.
Rob Clevenger has been asked to update his installation notes for
Oracle 10g. And once the IC SDK is out, I will also put together some
notes about building with it.
-- CJ 
Is the headerfiles you are refering to the same header files that can be found on this page?
I know this is probably not the headerfiles that are the IC, but they sure have a name that resembles what we/you are talking about...
Anders Berg 
Yes the ociheaders.tar available there can be used to compile the extension. They are 9i public headers, which should be fine. The php configure script looks for these headers in <ORACLE_HOME>/rdbms/demo (--with-oci8=<ORACLE_HOME>). So place these files appropriately. You can then use the instant client libraries to build and run mod_php. You may have to tweak some paths in the makefile before building, though.
I wrote a guide in Chinese (FC3 + Oracle 10g + Apache 2.0 + PHP 5):
However ,you can use the command history as your reference 
I have been working on this issues for a few days now. I was able to get Apache 2.0.52, PHP 5.0.2 and Oracle 10g Client(Administrator option) to work. Here's my compile
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/OraHome_1
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
./configure with-apxs2=/apache/bin/apxs with-oci8=$ORACLE_HOME --enable-sigchild
However, when I compile using '--with-xsl' option (I isolated the problem with this option), I cannot get a database connection. There's no error with the compile. Can anyone help me? Thanks in advance
Here's my actual command
./configure with-apxs2=/apache/bin/apxs with-oci8=$ORACLE_HOME enable-sigchild enable-track-vars enable-sockets enable-wddx with-curl with-mysql with-gd with-gettext with-ldap with-xsl enable-soap enable-discard-path --enable-exif                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
#rpm -qa | gerp xsl
what's information you get ?