Question about DBD::Oracle and DBI installation

[稀里哗啦]

Hi,all
I have seen many message about DBD::Oracle and DBI installation on hpux. These message make me very confused.
Is There someone have a detail step by step installaion guid, and send it to me?
I am a newbie for perl, I need using perl connect Oracle database(8.1.6/64bits), my HPUX version is 11i(64bits), A500 PA-RISC server.
Thanks.

[Ravi_8]

Hi,

http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/A96167_01/html/pre.htm#CHDCJDHI

above URL tells the procedure for oracle 9i rel2, Same kernel parameters and procedure holds good even for 8.1.6 also.

Oracle doesn't support to connecting using perl, it supports only SQL. you have to modify your perl script to connect to oracle DB

[Indira Aramandla]

Hi,

Attached document has information regarding installing the DBI and DBD::Oracle Modules.

After successfull installation, make sure all the library paths are set properly. And during the build DBD process, make sure to link the 64 bit objects from ORACLE_HOME/lib.

Refer to this URL for the details of environment variables to connect to oracle, after successfull installation.

http://search.cpan.org/author/TIMB/DBD-Oracle-1.12/Oracle.pm#Connecting_without_environment_variables_or_tnsname_ora_file

[Indira Aramandla]

Sorry, here is the attachment.

[Colin Topliss]

I've tried to get this working under 64bit HP-UX for ages - no luck yet.

I've only managed to get DBI/DBD compiled on a 32 bit HPUX system using their ANSI C compiler (using GCC always gave me problems as well). Note that the way that Perl was built in the first place can cause you problems:

Special Notes re: HP-UX
-----------------------
1. At the present time, HP-UX V11 cannot dynamically load
libraries that contain thread local storage. As such,
additional libraries, -lpthread and -lcl, MUST be
specified when building perl. If this is not done,
errors will occur during the DBD::DB2 "make test" phase.
2. In order to avoid some warnings when building perl, DBI,
and DBD::DB2, you may want to add the compile option,
+DAportable. This compile option is used to generate
code that is compatible across both PA_RISC 1.1 and 2.0
workstations and servers.
3. If an "out of memory" error is returned when compiling
the file Constants.c during the DBD::DB2 build process,
remove the "+Onolimit" compile option from the file
Makefile.PL in the Constants subdirectory and restart
the build process. Removing this compile option will
result in a warning like "Exceeding compiler resource
limits in constants; some optimizations skipped", but
this warning can be ignored.

Check www.cpan.org.

Also, this discussion can be found on this forum:
http://forums.itrc.hp.com/cm/QuestionAnswer/0,,0xcb1036e69499d611abdb0090277a778c,00.html

Good luck.

[稀里哗啦]

I have finaly done it using HP ansi c compiler.
Attachment file is the log of process.
It include compile perl 5.8 using source code;
install DBI using source code and install DBD:oracle module using source code.
Maybe someone need it.

[H.Merijn Brand (procura]

What I think is strange, is that with this log, I see you have acomplished a 32bit build of all modules and perl, I do not see the 64bit option:

where is +DD64 or +DA2.0w ?

In your intro, you explicitely requested 8.1.6/64bit.

# file `which perl`

will probably show you that it ain't 64bit ELF

Enjoy, have FUN! H.Merijn

[稀里哗啦]

Yes, You are right.But it's look good.