DBD::Oracle installation on unix

Posted on Tue Jul 5 21:33:14 2005 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 Tue Aug 16 17:23:09 2005 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

Write a response

Posted on Tue Aug 23 18:12:29 2005 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 Wed Aug 24 16:32:10 2005 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 Mon Jun 16 21:10:48 2008 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 | Write a response