Perl DBI & Perl DBD for Oracle

[John McDen]

Hello Experts,

Have anybody experience with installing PERL DBI and PERL DBD for Oracle.

Any help is appreciated.

[John McDen]

Thanks Manoj,

I have perl 5.6.1 already installed just need to install DBI and DBD and was not sure where to start the installation.. now I know ...If I have problems I will surely contact you ..

John

[John McDen]

Just one question in one of the documents the Prerequisites included TK800.015 do I need to install it seperatly or it is already included in Perl?

If not from where can I download it ?

[MANOJ SRIVASTAVA]

Hi John

I dont think it is nedded seperatley , download the tar version of DBD and DBI and that is all what is required.


Manoj Srivastava

[John McDen]

I think I need to install TK because it give an erro when I try to do "perl orac_dba.pl" for DBI

Error : Can't locate Tk.pm .....

But when I try to install TK
it gives me the following error...

perl is installed in /opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi okay
PPM for perl5.006001
Test Compiling config/signedchar.c
Test Compiling config/unsigned.c
Test Compiling config/Ksprintf.c
Test Compiling -DSPRINTF_RETURN_CHAR config/Ksprintf.c
Test Compiling config/tod.c
Test Compiling -DTIMEOFDAY_TZ config/tod.c
Test Compiling -DTIMEOFDAY_NO_TZ config/tod.c
Test Compiling -DTIMEOFDAY_DOTS config/tod.c
Problem gettimeofday()
Using -L/usr/lib/X11R6 to find /usr/lib/X11R6/libX11.3
Cannot find X include files via /include
Cannot find X include files anywhere at ./myConfig line 312.
Compilation failed in require at Makefile.PL line 17.
BEGIN failed--compilation aborted at Makefile.PL line 19.

I tried all the 3 options available.. but no luck.

Thanks in adavance

[H.Merijn Brand (procura]

Perl/Tk is absolutely not *needed* for DBI/DBD to work as expected with Oracle.

Perl/Tk is a GUI add-on to perl, which is used for some /extras/ and is absolutely worthwhile to install.

Go to CPAN http://hpux.tn.tudelft.nl/hppd/hpux/Misc/bzip2-1.0.2/ and fetch Tk-800.024.tar.gz

# gzip -d < Tk-800.024.tar.gz | tar xvf -
# cd Tk-800.024
# perl Makefile.PL
# make
# make test
# make install

[John McDen]

Hi Procura,

I get the error when I do perl Makefile.PL, mentioned in my previous message.

How do I resolve the errror?

Thanks

[H.Merijn Brand (procura]

Hmmm, do you /have/ X11 installed? I mean, the development environment?

a5:/wrk 107 > find /usr/include -name X.h
/usr/include/X11/X.h
/usr/include/X11R6/X11/X.h
a5:/wrk 108 >

(Tk need more than these, but at least you now see if there is /some/ X11 devel env)

a5:/wrk 109 > swlist -l bundle -l product | grep X11
B3901BA.X11MotifDevKit B.11.00.01 HP-UX Developer's Toolkit - X11, Motif, and Imake
HPUXEng64RT.X11 B.11.00 HP-UX X Window Software
a5:/wrk 110 >

[H.Merijn Brand (procura]

And more specific

Using -L/usr/lib/X11R6 to find /usr/lib/X11R6/libX11.3
Cannot find X include files via /include

Since when are include files installed on /include? This should be /usr/include. Hmmm, to - temporary - make Tk able to find these in /include you can make a symlink

# cd /
# ln -s usr/include include

don't forget to remove it afterwards.

Cannot find X include files anywhere at ./myConfig line 312.
Compilation failed in require at Makefile.PL line 17.
BEGIN failed--compilation aborted at Makefile.PL line 19.

[MANOJ SRIVASTAVA]

Hi John

I think this will take you back to reinstallation of perl itself , where in you ahve to specify -I/usr/include before the substituions , can you attach perl -V o/p so that I can look at the env you used to install perl. I am attaching perl -V from my system where in it suceeded in installing DBD and DBI.

Also when u untar DBI file please do read readme.hpux .

Manoj Srivastava

[John McDen]

Procura,

When I ran the command swlist -l bundle -l product | grep X11
This is the result I got so I guess it's not Devl ver.

HPUXEng64RT.X11 B.11.00 HP-UX X Window Software
XSWGR1100.PHSS_15840 1.0 X11 64 bit runtime cumulative patch

[H.Merijn Brand (procura]

/Can/ you install the devkit? It might be that even if you can install the include files from whoever is willing to tgz them to you, you'll still miss some links and libs

[John McDen]

Hello

I got the binary from

http://www.perltk.org/binaries/index.htm

where should I install this I have no clue??

I really appreciate your help (all of them)

[H.Merijn Brand (procura]

:)))) Did you get the version from H.M.Brand? (shhh that's me)

I can't remember where it's root is, but I expect it tyo go like:


# cd /opt/lib/perl5
# gzip -d < 800.022-HPUX-11.00-hppa2.0.tar.gz | tar xvf -

The .tar.gz will install in the subfolder 'site_perl' from the current location, so just check if there is a subfolder site_perl where you are going to extract (There /should/ be one already)

That's all there is to it :)
Hope it fits with your perl port, because it's a version built with HP C-ANSI-

[H.Merijn Brand (procura]

And BTW I think I earn /some/ points in this thread. I have to catch up with Clemens :)

N/A

[John McDen]

Any idea why I am getting this error when trying to install Perl DBI

Can't locate loadable object for module Tk::Event in @INC (@INC contains: /opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi /opt/perl/lib/
5.6.1 /opt/perl/lib/site_perl/5.6.1/PA-RISC1.1-thread-multi /opt/perl/lib/site_perl/5.6.1 /opt/perl/lib/site_perl .) at /opt/perl/li
b/site_perl/5.6.1/PA-RISC1.1-thread-multi/Tk.pm line 13
Compilation failed in require at /opt/perl/lib/site_perl/5.6.1/PA-RISC1.1-thread-multi/Tk.pm line 13.
BEGIN failed--compilation aborted at /opt/perl/lib/site_perl/5.6.1/PA-RISC1.1-thread-multi/Tk.pm line 13.
Compilation failed in require at orac_dba.pl line 39.
BEGIN failed--compilation aborted at orac_dba.pl line 39.

Thanks for your help

[H.Merijn Brand (procura]

Just finished uploading http://www.xs4all.nl/~procura/800.024-HPUX-11.00-hppa1.1-gcc.tgz which should fit to the perl as shipped with HP

# cd /opt/perl
# gzip -d < /tmp/800.024-HPUX-11.00-hppa1.1-gcc.tgz | tar xf -

rebuilt both perl-5.6.1 and Tk with gcc-3.0.4/32 on 11.00

Done.