cancel
Showing results for 
Search instead for 
Did you mean: 

Perl DBI & Perl DBD for Oracle

SOLVED
Go to solution
John McDen
Regular Advisor

Perl DBI & Perl DBD for Oracle

Hello Experts,

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

Any help is appreciated.

New to HP
17 REPLIES
MANOJ SRIVASTAVA
Honored Contributor
Solution

Re: Perl DBI & Perl DBD for Oracle

 
John McDen
Regular Advisor

Re: Perl DBI & Perl DBD for Oracle

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
New to HP
John McDen
Regular Advisor

Re: Perl DBI & Perl DBD for Oracle

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 ?
New to HP
MANOJ SRIVASTAVA
Honored Contributor

Re: Perl DBI & Perl DBD for Oracle

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
Regular Advisor

Re: Perl DBI & Perl DBD for Oracle

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
New to HP
H.Merijn Brand (procura
Honored Contributor

Re: Perl DBI & Perl DBD for Oracle

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
Enjoy, Have FUN! H.Merijn
John McDen
Regular Advisor

Re: Perl DBI & Perl DBD for Oracle

Hi Procura,

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

How do I resolve the errror?

Thanks
New to HP
H.Merijn Brand (procura
Honored Contributor

Re: Perl DBI & Perl DBD for Oracle

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 >
Enjoy, Have FUN! H.Merijn
H.Merijn Brand (procura
Honored Contributor

Re: Perl DBI & Perl DBD for Oracle

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.
Enjoy, Have FUN! H.Merijn
MANOJ SRIVASTAVA
Honored Contributor

Re: Perl DBI & Perl DBD for Oracle

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
Regular Advisor

Re: Perl DBI & Perl DBD for Oracle

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
New to HP
H.Merijn Brand (procura
Honored Contributor

Re: Perl DBI & Perl DBD for Oracle

/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
Enjoy, Have FUN! H.Merijn
John McDen
Regular Advisor

Re: Perl DBI & Perl DBD for Oracle

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)

New to HP
H.Merijn Brand (procura
Honored Contributor

Re: Perl DBI & Perl DBD for Oracle

:)))) 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-
Enjoy, Have FUN! H.Merijn
H.Merijn Brand (procura
Honored Contributor

Re: Perl DBI & Perl DBD for Oracle

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

N/A
Enjoy, Have FUN! H.Merijn
John McDen
Regular Advisor

Re: Perl DBI & Perl DBD for Oracle

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
New to HP
H.Merijn Brand (procura
Honored Contributor

Re: Perl DBI & Perl DBD for Oracle

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.
Enjoy, Have FUN! H.Merijn