anyone succeed with gcc 4.2/perl 5.8.8/DBD 1.19 on 11i V1?

[Richard T. Malafa]

Totally making me crazy with the constant error of:
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.sl
gcc +b "/ora01/app/oracle/product/10.2/lib:/lib/pa20_64" -shared -static-libgcc -fPIC -L/lib/pa20_64 Oracle.o dbdimp.o oci8.o -o blib/arch/auto/DBD/Oracle/Oracle.sl \
-L/ora01/app/oracle/product/10.2/lib -lclntsh -lrt -lpthread -lnsl \

gcc: +b: No such file or directory
gcc: /ora01/app/oracle/product/10.2/lib:/lib/pa20_64: No such file or directory
*** Error exit code 1


everything is there.. tried various combinations of paths. etc etc.
Full file attached of everything..

[Dennis Handly]

The option +b is a linker option. Change to:
-Wl,+b,/ora01/app/oracle/product/10.2/lib:/usr/lib/pa20_64

(Note there is no such thing as /lib, so use /usr/lib.)

[Richard T. Malafa]

Dennis,
Must have crossed in mail yesterday. Got notice from Merijn to change to -Wl,+b in the Makefile.PL and that got rid of the +b error very nicely...
Now it's a plain old..
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.sl
gcc -Wl,+b "/ora01/app/oracle/product/10.2/lib:/lib/pa20_64" -shared -static-libgcc -fPIC -L/lib/pa20_64 Oracle.o dbdimp.o oci8.o -o blib/arch/auto/DBD/Oracle/Oracle.sl \
-L/ora01/app/oracle/product/10.2/lib -lclntsh -lrt -lpthread -lnsl \

gcc: /ora01/app/oracle/product/10.2/lib:/lib/pa20_64: No such file or directory
*** Error exit code 1

Stop.
root@wsmisdb1>
Searching how it can possibly be /lib/pa20_64 since yesterday with no luck so far. I didn't put that in the path anywhere that I can see
Attaching the entire run as run3.doc.

[Richard T. Malafa]

Correction: There is a lib/pa20_64. Don't know why it's not picking up the other library. Maybe it can't handle three reference at a time??

[Dennis Handly · Accepted solution]

>-Wl,+b in the Makefile.PL and that got rid of the +b error very nicely...

No, you did it incorrectly. You need to use:
-Wl,+b,/ora01/app/oracle/product/10.2/lib:/lib/pa20_64

The comma is the separator not whitespace.
It fails with aCC/cc except it is only a warning and since the gods smiled on you, it just randomly works.
$ cc -Wl,+b /ora01/app/oracle/product/10.2/lib:/lib/pa20_64
cc: warning 1913: `/ora01/app/oracle/product/10.2/lib:/lib/pa20_64' does not exist or cannot be read

>There is a lib/pa20_64.

No there isn't, it's an illusion. Use /usr/lib/pa20_64.

[Richard T. Malafa]

Dennis,
Ok, You were right. I accept the slap gladly. I run all the way down with the make file. In Makefile.PL I changed it to
elsif ($os eq 'hpux') {
$m =~ s/LD_RUN_PATH=(\S+)\s+(\S+)/$2 -Wl,+b,$1/;
I'd give you more than 10 pts for the help if I could in addition to the 8 pts I already gave you from the first answer...
perl Makefile.PL -l runs good and
make then ends up with
Extracted ora_explain from ora_explain.PL with variable substitutions.
cp ora_explain blib/script/ora_explain
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/ora_explain
Set up gcc environment - 4.2.0
Manifying blib/man1/ora_explain.1
Manifying blib/man3/DBD::Oracle.3
Manifying blib/man3/DBD::Oraperl.3
root@wsmisdb1>

Thank You
Rich
Whew!

[Richard T. Malafa]

Had to go to a meeting.. Will let you know after I run the 'make test'
Rich

[H.Merijn Brand (procura]

Still need one? Are you sure?

I have bad experiences with gcc-4.x 64bit with regard to perl on HP-UX 11.xx on PA-RISC. gcc-3.4.6 is very much more stable.

A precompiled 5.8.8 is on my site 1) for that, including DBI-1.50 or 1.53.

Why DBI-1.19? If you'd asked for 1.46, I could understand, as some incompatabilities were intordoced in 1.47 and 1.48, but those were easy to work around (Tim wrongly introduced quotes in the return values of the tables () call).

1) http://mirrors.develooper.com/hpux/#Perl

Enjoy, Have FUN! H.Merijn

[Richard T. Malafa]

Merijn,
That was DBD 1.19. My mistake if I wrote it any other way. Java 5.8.8 came from HP with DBI 1.50 installed. I did take a quick stab at upgrading the DBI but ran into _Jv_RegisterClasses errors. I have to solve this problem since I see it coming up with other perl modules like ftp::foreign..
Sent you the entire clipping where i made it to the "make test" step.
This whole thing is nothing but a struggle to get done. Yes, I seen the nicely done packages on your site. But I have to use gcc 4.2 since it works with a lot of the new Oracle applications and installation. It works great installing Oracle DBs and applications.
Boy, Thank You..