I have written a shell script which compiles & installs perl from source using GNU gcc on Solaris 9. This script also builds the latest DBI and DBD::Oracle, and is known to work just fine with oracle 8 & 9. The version numbers of software mentioned above are very recent (e.g., perl 5.8.2, gcc 3.3.2, DBI 1.40, etc.). I didn't bother trying to use the default perl included with Solaris 9 because I wanted to customize some other things. Also I am using the 32 bit versions of oracle (both 8 & 9).
I'd be surprised if this script didn't work "as is" on Solaris 8. If anyone is interested just drop me an email and I can pass the script along. Eric. On Fri, Jan 23, 2004 at 09:13:17AM -0700, Krempasky, Mark wrote: > I've not been able to successfully compile DBD-Oracle-1.14 with our current > setup on hugo. > Solaris 8, perl 5.005_03, DBI-1.35 and various types of "cc, ld and make" > Regardless of which brand of "cc, ld and make" I use I pretty much see the > same results > compiling DBD-Oracle-1.14 against 64bit and 32bit Oracle9 libraries with our > version of perl. The below error is a common issue of old perl vrs 64bit > Oracle9 libs during the make. > note that the LD_LIBRARY_PATH is not referenced during the compile, it's the > LD_RUN_PATH generated by the "perl Makefile.PL" > > LD_RUN_PATH="/app/oracle9/lib:/app/oracle9/rdbms/lib" cc -o > blib/arch/auto/DBD/Oracle/Oracle.so -G Oracle.o dbdimp.o oci7.o oci8.o > -L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o build > -L/app/oracle9/rdbms/lib/ -L/app/oracle9/lib/ -lclntsh -lnbeq9 -lnhost9 > -lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnnis9 -lnoname9 -lntcp9 -lntcps9 > -lnsslb9 -lntcp9 -lntns9 -lnsl -lsocket -lgen -ldl -R/app/oracle9/lib -laio > -lposix4 -lkstat -lm -lthread > ld: fatal: file /app/oracle9/lib//libclntsh.so: wrong ELF class: ELFCLASS64 > ld: fatal: File processing errors. No output written to build > *** Error code 1 > make: Fatal error: Command failed for target > `blib/arch/auto/DBD/Oracle/Oracle.so' > > So the work around to the 64bit lib error is to modify the Makefile and > change every instance of "/app/oracle9/lib to /app/oracle9/lib32" so make > compiles against the 32bit oracle9 libs. > > After making the changes and running make the > `blib/arch/auto/DBD/Oracle/Oracle.so' is still not created in the DBD source > dir and the make bombs out. > > LD_RUN_PATH="/app/oracle9/lib32:/app/oracle9/rdbms/lib" cc -o > blib/arch/auto/DBD/Oracle/Oracle.so -G Oracle.o dbdimp.o oci7.o oci8.o > -L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o build > -L/app/oracle9/rdbms/lib/ -L/app/oracle9/lib32/ -lclntsh -lnbeq9 -lnhost9 > -lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnnis9 -lnoname9 -lntcp9 -lntcps9 > -lnsslb9 -lntcp9 -lntns9 -lnsl -lsocket -lgen -ldl -R/app/oracle9/lib32 > -laio -lposix4 -lkstat -lm -lthread > chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so > chmod: WARNING: can't access blib/arch/auto/DBD/Oracle/Oracle.so > *** Error code 1 > make: Fatal error: Command failed for target > `blib/arch/auto/DBD/Oracle/Oracle.so' > > I'm pretty well stumped, the only thing I can think of to try next is find > another development system with Oracle9, perl 5.6.0 or newer, "gnu gcc, make > and ld" and start from scratch. > But I'm definitely up for any input on trying to get this to work in our > current environment. > > Mark. > > -----Original Message----- > From: Potenza, Joe > Sent: Friday, January 23, 2004 8:19 AM > To: 'Tim Bunce'; Potenza, Joe; Krempasky, Mark > Cc: '[EMAIL PROTECTED]' > Subject: RE: DBD-Oracle-1.14 and Oracle 9i > > > I apologize for the lack of detail at this time. One of my co-workers was > attempting the compile and did some searching on google. I mainly wanted to > find out if DBD-Oracle-1.14 would work with Oracle9i before pursuing the > issue any further. > > Mark K., > > Can you reply to this email with detail on the compilation errors you were > getting. Thanks. > > Joe Potenza > > -----Original Message----- > From: Tim Bunce [mailto:[EMAIL PROTECTED] > Sent: Friday, January 23, 2004 2:48 AM > To: Potenza, Joe > Cc: '[EMAIL PROTECTED]' > Subject: Re: DBD-Oracle-1.14 and Oracle 9i > > On Thu, Jan 22, 2004 at 05:21:02PM -0700, Potenza, Joe wrote: > > Has anyone been able to compile DBD-Oracle-1.14 with Oracle9i under > > Solaris8? > > Have you been able to use google to find out? > > Tim. >
