Re: Building DBD::Oracle on Solaris and 9i 64-bit

From: Big Chuck <ccarson_at_echeeba.com>
Date: Wed, 11 Jun 2003 13:01:48 -0700
Message-ID: <3EE78AAC.4010303@echeeba.com>

Andy Hassall wrote:
> On Wed, 11 Jun 2003 10:57:55 -0700, Big Chuck <ccarson_at_echeeba.com> wrote:
>
>

>>I cannot get DBD::Oracle to build on Solaris 8 64-bit using Oracle 
>>9.2.0.3 64-bit.
>>
>>I know to change all the $ORACLE_HOME/lib to $ORACLE_HOME/lib32 and 
>>$ORACLE_HOME/rdbms/lib to $ORACLE_HOME/rdbms/lib32. Id id that and now I 
>>get this error when building:
>>
>>LD_RUN_PATH="/u01/app/oracle/product/9.2.0.1/lib32:/u01/app/oracle/product/9.2.0.1//rdbms/lib32" 
>>gcc -B/usr/ccs/bin/  -G -L/usr/local/lib Oracle.o dbdimp.o oci7.o oci8.o 
>>-L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib -o build 
>>-L/u01/app/oracle/product/9.2.0.1//rdbms/lib32/ 
>>-L/u01/app/oracle/product/9.2.0.1/lib32/   -lclntsh -lnbeq9 -lnhost9 
>>-lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnnis9 -lnoname9 -lntcp9 -lntcps9 
>>-lnsslb9 -lntcp9 -lntns9 -lnsl -lsocket -lgen -ldl 
>>-R/u01/app/oracle/product/9.2.0.1/lib32 -laio -lposix4 -lkstat -lm 
>>-lthread -o blib/arch/auto/DBD/Oracle/Oracle.so
>>ld: warning: option -o appears more than once, first setting taken
>>chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
>>chmod: WARNING: can't access blib/arch/auto/DBD/Oracle/Oracle.so
>>make: *** [blib/arch/auto/DBD/Oracle/Oracle.so] Error 1
>>
>>Any ideas?

>
>
> Which version - 1.14? Some option/link changed in the Makefile at 1.13 or 1.14
> that broke the build on Solaris, giving that error - there's been some messages
> and at least one patch on the dbi-users mailing list about this so hopefully
> the next version should build cleanly.
>
> 1.12 builds OK, so a workaround that I've used is to get DBD-Oracle 1.12,
> generate the Makefile (perl Makefile.PL etc.), do the changes to 'lib32' and
> then copy that Makefile into 1.14's directory. Change the versions in the
> Makefile from 1.12 to 1.14 - 1.14 will compile with that Makefile, and works
> without problems here.
>
> --
> Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
> Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

Thanks a bunch, that worked great. However a few tests did fail. Do I need to be worried about these:

db-0203:~/.cpan/build/DBD-Oracle-1.14 #make test PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/base.......ok

t/cursor.....ok

t/general....ok

t/long.......ok

t/meta.......ok

t/ph_type....ok 11/19 expected 'trailing' but got 'trailing ' for VARCHAR2
t/ph_type....FAILED test 12

Failed 1/19 tests, 94.74% okay
t/plsql......ok

t/reauth.....skipped

all skipped: no reason given
t/select.....ok

Failed Test Stat Wstat Total Fail Failed List of Failed

t/ph_type.t 19 1 5.26% 12 1 test skipped.
Failed 1/9 test scripts, 88.89% okay. 1/3464 subtests failed, 99.97% okay. make: *** [test_dynamic] Error 29

Thanks,
Chuck Received on Wed Jun 11 2003 - 15:01:48 CDT