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.