DBD::Oracle installation on unix

Posted on 2005-07-05 18:33:14-07 by praveen

Hi , I am having some problems installing the DBD::Oracle installation on unix. This is what I get when i run perl Makefile.PL -v

Configuring DBD::Oracle ... >>> Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /home/oracle/ora9_client DEFINE _SQLPLUS_RELEASE = "902000500" (CHAR) Oracle version 9.2.0.5 (9.2) Found /home/oracle/ora9_client/precomp/demo/proc/demo_proc.mk Using /home/oracle/ora9_client/precomp/demo/proc/demo_proc.mk Reading /home/oracle/ora9_client/precomp/demo/proc/demo_proc.mk Reading /home/oracle/ora9_client/precomp/lib/env_precomp.mk Warning: I will now try to guess how to build and link DBD::Oracle for you. This kind of guess work is very error prone and Oracle-version sensitive. It is possible that it won't be supported in future versions of DBD::Oracle. *PLEASE* notify dbi-users about exactly _why_ you had to build it this way. Found header files in rdbms/demo. ********************************************************* I can't find the header files I need in your Oracle installation. You probably need to install some more Oracle components. I'll keep going, but the compile will probably fail. See README.clients for more information. ********************************************************* Checking for functioning wait.ph System: perl5.008007 sunos nydoesd2-cmc 5.8 generic_108528-16 sun4u sparc sunw,ultra-4 Compiler: gcc -O -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 Linker: /usr/ccs/bin/ld Sysliblist: -lnsl -lsocket -lgen -ldl Oracle makefiles would have used these definitions but we override them: CC: cc CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\ $(SHARED_CFLAG) $(USRFLAGS) [$(GFLAG) -xO3 $(CDEBUG) -Xa $(PROFILE) -xstrconst -dalign -xF $(XS) $(MR) -xildoff -err +tags=yes -v -xarch=v9 -xchip=ultra3 -W2,-AKNR_S -Wd,-xsafe=unboundsym -Wc,-Qiselect-funcalign=32 - +xcode=abs44 -Wc,-Qgsched-trace_late=1 -Wc,-Qgsched-T5 -xalias_level=weak -D_REENTRANT -DSS_64BIT_S +ERVER -DBIT64 -DMACHINE64 -K PIC -DPRECOMP -I. -I/home/oracle/ora9_client/precomp/public -I/home/o +racle/ora9_client/rdbms/public -I/home/oracle/ora9_client/rdbms/demo -I/home/oracle/ora9_client/pl +sql/public -I/home/oracle/ora9_client/network/public -DSLMXMX_ENABLE -DSLTS_ENABLE -D_SVID_GETTOD +-D_REENTRANT $(LPFLAGS) $(USRFLAGS)] build: $(DEMO_PROC_BUILD_SHARED_64) [ cc -xarch=v9 $(LFLAGS) -o $(EXE) $(OBJS) -L$(LIBHOME) -lclntsh -lnbeq9 -lnhost9 -lnus9 + -lnldap9 -lldapclnt9 -lnsslb9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9 -lntns9 $(EXPDLIBS) $(E +XOSLIBS) -lnsl -lsocket -lgen -ldl -R/home/oracle/ora9_client/lib -laio $(THREADLIBS) -lposix4 $(L +LIBKSTAT) -lm $(USRLIBS) -lthread] LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) [-o $@ -L/home/oracle/ora9_client/precomp/lib/ -L$(LIBHOME)] Linking with -L/home/oracle/ora9_client/lib -lclntsh [from $(LIBCLNTSH)] Warning: If you have problems you may need to rebuild perl with threading enabled. LD_RUN_PATH=/home/oracle/ora9_client/lib32 Using DBD::Oracle 1.16. Using DBD::Oracle 1.16. Using DBI 1.48 (for perl 5.008007 on sun4-solaris) installed in /apps/xttools/lib/perl5/site_perl/5 +.8.7/sun4-solaris/auto/DBI/ Writing Makefile for DBD::Oracle *** If you have problems... read all the log printed above, and the README and README.help files. (Of course, you have read README by now anyway, haven't you?)

I think my oracle client installation doesnt have the needed files. But still not sure about that. If this is the case can anyone tell me what are the files i need exactly to get the DBD installed . Thanks Praveen

Direct Responses: 801 | 913 | Write a response

Posted on 2005-07-28 08:18:00-07 by yenji in response to 698

Re: DBD::Oracle installation on unix

Anyone received responce to this problem i am also having same prob. pls. help

Direct Responses: 897 | Write a response

Posted on 2005-08-16 14:23:09-07 by severus in response to 801

Re: DBD::Oracle installation on unix

I'm also stuck at the same point.

I've tried installing the Oracle 9i client in all of the available configurations, including going into custom and then selecting everything, but whatever I do the complaint about missing headers is the same.

Can anyone please shed some light on this?

NB I'm running this on SUSE Linux Enterprise Server 9, with the latest Perl and DBI successfully installed. Oracle client version is 9.2.0.1

Direct Responses: Write a response

Posted on 2005-08-18 20:09:40-07 by bill in response to 698

Re: DBD::Oracle installation on unix

It seems Oracle Call Interface files are missing in 9.2.0/rdbms/demo directory. Have you found out how to install DBD successfully?

Direct Responses: 925 | Write a response

Posted on 2005-08-23 15:12:29-07 by severus in response to 913

Re: DBD::Oracle installation on unix

> Have you found out how to install DBD successfully?

Not yet, am now tearing my hair out about this :-(

Surely someone has managed to get Oracle::DBD working with the Oracle 9.2.0 client on Linux? If they have, I 'd love to know how.....

Direct Responses: 926 | Write a response

Posted on 2005-08-24 02:55:31-07 by lhamolatso in response to 925

Re: DBD::Oracle installation on unix

I've read through your postings, but there is not nearly enough information to debug your problem. The original post only shows expected results, not errors. I just tried installing on a RedHat Linux AS v3 system that has Oracle 9.2 to see if there were any difficulties.

First, did you install Oracle 9.2 correctly. You need more than Oracle client. There is no need to create a database, but you need more than a runtime software tree.

Second, are you on Unix or Linux? What version exactly?

Third, it would be a good idea to export a few environment variables:

export ORACLE_HOME=/usr/oracle (or whereever you put it)

export LD_ASSUME_KERNEL=2.4.1 (don't ask me why, but it can make a difference)

Fourth, install DBI-1.48 from CPAN. You are required to have one DBI installed before installing a DBD. It is done in the usual way, see the README.

Five, install DBD-Oracle-1.16 from CPAN. Before running "make test", you need to:

export ORACLE_USERID="scott/tiger"

Good Luck!

Direct Responses: 928 | Write a response

Posted on 2005-08-24 13:32:10-07 by severus in response to 926

Re: DBD::Oracle installation on unix

Thanks for the help!

I had real trouble trying to work out exactly what Oracle components I needed in order to get DBD::Oracle installed. However, after a few dozen Googles I eventually came across:

http://cpanratings.perl.org/dist/DBD-Oracle

From there I discovered that what I had to do after installing the Oracle client was grab this file from Disk2 of the installation media:

stage/Components/oracle.rdbms.oci/9.2.0.4.0/1/DataFiles/public.1.1.jar

Then a "mkdir public" in $ORACLE_HOME/rdbms, cd into public. cp the jar file into public and jar xvf it.

After that, and setting ORACLE_HOME, ORACLE_SID and ORACLE_USERID correctly as you suggested, lo and behold DBD::Oracle fianlly installed :-)

Direct Responses: 1170 | Write a response

Posted on 2005-10-15 04:49:07-07 by johnnyboy in response to 928

Re: DBD::Oracle installation on unix

A simpler way to do this might just be to re-run runInstaller from your Disk 1 staging area.

Then minimally pick 9.2.0.4 Client, then Administrator (Runtime did not provide pro*c libraries).

Choose Custom, and note that by default OCI - Oracle Call Interface -is not installed.

Installed OCI to get the appropriate .h files, and then the make for DBD-Oracle with 9.2.0.4 worked fine.

Direct Responses: 8091 | Write a response

Posted on 2008-06-16 18:10:48-07 by hdd in response to 1170

Re: DBD::Oracle installation on unix

I have
1. Linux 2.6.5-7.282-bigsmp UTC 2006 i686 i686 i386 GNU/Linux

2. Perl version 5.8.3

3. while running perl Makefile.PL getting the error

Checking for functioning wait.ph
Scalar found where operator expected at (eval 209) line 1, near "'int' $__val"
(Missing operator before $__val?)

4. i am trying to install DBD::Oracle but getting the following error while make.
In file included from Oracle.xs:1:
Oracle.h:37:17: oci.h: No such file or directory
Oracle.h:39:20: ocidfn.h: No such file or directory
Oracle.h:40:18: orid.h: No such file or directory
Oracle.h:41:17: ori.h: No such file or directory
In file included from Oracle.h:53,
from Oracle.xs:1:
dbdimp.h:15: error: parse error before "OCIEnv"
dbdimp.h:15: warning: no semicolon at end of struct or union
dbdimp.h:22: error: parse error before '}' token
dbdimp.h:36: error: parse error before "OCIEnv"
dbdimp.h:36: warning: no semicolon at end of struct or union
dbdimp.h:37: warning: type defaults to `int' in declaration of `errhp'
...
...
...
Oracle.xsi:21: error: invalid application of `sizeof' to an incomplete type
Oracle.xsi:22: error: invalid application of `sizeof' to an incomplete type
Oracle.xsi:23: error: invalid application of `sizeof' to an incomplete type
make: *** [Oracle.o] Error 1

5. if some one can tell me how to install. i may be following wrong steps for installing DBD::Oracle.

6. i have already installed Oracle Administrator Client 9.2.0.4

7. ORACLE_BASE, ORACLE_HOME and LD_LIBRARY_PATH already set.

your suggestion are welcome

Thanks in advance for the support.

Direct Responses: 8222 | 9719 | Write a response

Posted on 2008-07-02 15:54:21-07 by byterock in response to 8091

Re: DBD::Oracle installation on unix

Please use perl.dbi.users forum this one sees very little traffic. As for you problem I would install the newer Oracle instant client rather than the reather old and unsupported 9.2.0.4 client

Direct Responses: Write a response

Posted on 2009-01-13 15:07:19-08 by pato69loco in response to 8091

Re: DBD::Oracle installation on unix

You need to change the Makefile and add to the INC = string an -I with the path to the instance client's sdk include directory. I also had to add to the LD_RUN_PATH = string the path to the instance client's sdk lib directory. This solved most of the problems I have, by if you look at the thread I entered today I have run into other problems. But they could be problems just installing on cygwin (win NT). Regards.

Direct Responses: Write a response

Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.