topic Re: Perl DBI & Perl DBD for Oracle in Operating System - HP-UX

Perl DBI & Perl DBD for Oracle

John McDen — Wed, 17 Apr 2002 16:26:17 GMT

Hello Experts,

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

Any help is appreciated.

Re: Perl DBI & Perl DBD for Oracle

MANOJ SRIVASTAVA — Wed, 17 Apr 2002 16:47:23 GMT

Re: Perl DBI & Perl DBD for Oracle

John McDen — Wed, 17 Apr 2002 16:55:23 GMT

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

Re: Perl DBI & Perl DBD for Oracle

John McDen — Wed, 17 Apr 2002 17:04:12 GMT

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 ?

Re: Perl DBI & Perl DBD for Oracle

MANOJ SRIVASTAVA — Wed, 17 Apr 2002 17:41:16 GMT

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

Re: Perl DBI & Perl DBD for Oracle

John McDen — Wed, 17 Apr 2002 18:13:21 GMT

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

Re: Perl DBI & Perl DBD for Oracle

H.Merijn Brand (procura — Thu, 18 Apr 2002 04:43:06 GMT

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

Re: Perl DBI & Perl DBD for Oracle

John McDen — Thu, 18 Apr 2002 11:45:17 GMT

Hi Procura,

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

How do I resolve the errror?

Thanks

Re: Perl DBI & Perl DBD for Oracle

H.Merijn Brand (procura — Thu, 18 Apr 2002 15:33:15 GMT

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 >

Re: Perl DBI & Perl DBD for Oracle

H.Merijn Brand (procura — Thu, 18 Apr 2002 15:36:48 GMT

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.

Re: Perl DBI & Perl DBD for Oracle

MANOJ SRIVASTAVA — Thu, 18 Apr 2002 15:53:23 GMT

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

Re: Perl DBI & Perl DBD for Oracle

John McDen — Thu, 18 Apr 2002 16:18:39 GMT

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

Re: Perl DBI & Perl DBD for Oracle

H.Merijn Brand (procura — Thu, 18 Apr 2002 16:29:58 GMT

/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

Re: Perl DBI & Perl DBD for Oracle

John McDen — Thu, 18 Apr 2002 16:37:24 GMT

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)

Re: Perl DBI & Perl DBD for Oracle

H.Merijn Brand (procura — Thu, 18 Apr 2002 16:45:01 GMT

:)))) 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-

Re: Perl DBI & Perl DBD for Oracle

H.Merijn Brand (procura — Thu, 18 Apr 2002 16:49:24 GMT

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

N/A

Re: Perl DBI & Perl DBD for Oracle

John McDen — Thu, 18 Apr 2002 20:15:37 GMT

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

Re: Perl DBI & Perl DBD for Oracle

H.Merijn Brand (procura — Fri, 19 Apr 2002 10:25:09 GMT

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.