Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Question about DBD::Oracle and DBI installation

稀里哗啦
Advisor

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.
7 REPLIES
Ravi_8
Honored Contributor

Re: Question about DBD::Oracle and DBI installation

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
never give up
Indira Aramandla
Honored Contributor

Re: Question about DBD::Oracle and DBI installation

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

Never give up, Keep Trying
Indira Aramandla
Honored Contributor

Re: Question about DBD::Oracle and DBI installation

Sorry, here is the attachment.
Never give up, Keep Trying
Colin Topliss
Esteemed Contributor

Re: Question about DBD::Oracle and DBI installation

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.
稀里哗啦
Advisor

Re: Question about DBD::Oracle and DBI installation

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
Honored Contributor

Re: Question about DBD::Oracle and DBI installation

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
Enjoy, Have FUN! H.Merijn
稀里哗啦
Advisor

Re: Question about DBD::Oracle and DBI installation

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