RE: Perl in 10.2.0.3
- From: "Langston, Chris" <Chris.Langston@xxxxxx>
- To: "Shanmugam, Dhandapani" <dhandapani.shanmugam@xxxxxxx>, <scoles@xxxxxxxxxxx>
- Date: Tue, 27 May 2008 08:40:34 -0500
You're welcome, Dhandapani. I'm glad I could help. Please post to the
group that your issue was resolved.
Cheers,
Chris
-----Original Message-----
From: Shanmugam, Dhandapani [mailto:dhandapani.shanmugam@xxxxxxx]
Sent: Tuesday, May 27, 2008 5:18 AM
To: Langston, Chris; scoles@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Perl in 10.2.0.3
Wow Chris! Your instructions solved my perl problem!! Thanks for the
explanation
Thanks and Regards,
Dhandapani S
+ mailto:dhandapani.shanmugam@xxxxxxx
-----Original Message-----
From: Langston, Chris [mailto:Chris.Langston@xxxxxx]
Sent: Tuesday, May 20, 2008 12:16 AM
To: Shanmugam, Dhandapani; scoles@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Perl in 10.2.0.3
Dhandapani,
I recently went thru this exercise and after a while was finally able to
get the Perl DBI/DBD modules for Oracle to work. We are on Solaris 10
(Opteron 64 servers) using 10g (10.2.0.3). Here are some guidelines you
many find useful.
* Perl for Solaris is shipped as a 32bit version which is fine for
most Perl apps. Leave the default install alone (/usr/perl5) as this is
used by the operating system and could make your OS become unusable if
tampered with. Instead, you will need to compile another 64 bit version
of perl. I first did this in my home directory and later installed it
for production use in /opt/perl5 (/usr/local/bin/perl5 is another
alternate you can use).
* After building and installing the local version of Perl, create an
environment file that points to that version. That means, /usr/bin
should come last in your PATH. Also, be sure to unset/reset any perl
library and LD_LIBRARY_PATHs to point to the newly installed version
ahead of the system installed one.
* Begin installing the DBI/DBD modules. DBI is rather straight forward
but the DBD test is where I had the issue. This was resolved once I
recompiled a 64 bit version of Perl and made sure it was placed ahead of
the installed version. Recent your PERL5LIB to point to your 64 bit
version.
I think I still have instructions so email me off-line and I can send
them to you.
Kind regards,
Chris Langston
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Shanmugam,
Dhandapani
Sent: Friday, May 16, 2008 2:31 AM
To: scoles@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Perl in 10.2.0.3
Yes your correct..Do the Perl supports 64-bit Operating systems
Kinldy help me on how is should get it work on Oracle 64-bit Solaris
Operating system
========================================================================
=================================================
[bash]perl create_ddl.pl Can't locate DBI.pm in @INC (@INC contains:
/ade/stvobadm_perl_583_build/perl/bin/Solaris/Opt/lib/5.8.3/sun4-solaris
-thread-multi
/ade/stvobadm_perl_583_build/perl/bin/Solaris/Opt/lib/5.8.3
/ade/stvobadm_perl_583_build/perl/bin/Solaris/Opt/lib/site_perl/5.8.3/su
n4-solaris-thread-multi
/ade/stvobadm_perl_583_build/perl/bin/Solaris/Opt/lib/site_perl/5.8.3
/ade/stvobadm_perl_583_build/perl/bin/Solaris/Opt/lib/site_perl .) at
create_ddl.pl line 16.
BEGIN failed--compilation aborted at create_ddl.pl line 16.
While the DBI.pm is present in both directories specified below, the
Perl @INC array is pointing to non existent directories.
When I specify Including the Oracle directories (command line perl -I
$ORACLE_HOME/perl/lib/site_perl/5.8.3/sun4-solaris-thread-multi -I $ORAC
LE_HOME/perl/lib/5.8.3 create_ddl.pl,
I get the error:
perl -I $ORACLE_HOME/perl/lib/site_perl/5.8.3/sun4-solaris-thread-multi
-I $ORACLE_HOME/perl/lib/5.8.3 create_ddl.pl --pwd <password removed>
Can't load
'/usr/local/oracle/product/10.2.0.3/perl/lib/site_perl/5.8.3/sun4-solari
s-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:
ld.so.1: perl: fatal:
/usr/local/oracle/product/10.2.0.3/lib/libclntsh.so.10.1: wrong ELF
class: ELFCLASS64 at
/usr/local/oracle/product/10.2.0.3/perl/lib/5.8.3/sun4-solaris-thread-mu
lti/DynaLoader.pm line 229.
at create_ddl.pl line 18
Compilation failed in require at create_ddl.pl line 18.
BEGIN failed--compilation aborted at create_ddl.pl line 18.
The other error is due to the perl istallation pointing at the wrong
include directories. This tells it where to look for the perl modules
(*.pm) files, and other things. It is set when perl is installed on a
computer. You can add include libraries to perl with the "-I"
parameter, and can have as many of them as you want (look at the command
perl -I $ORACLE_HOME/perl/lib/site_perl/5.8.3/sun4-solaris-thread-multi
-I $ORACLE_HOME/perl/lib/5.8.3 create_ddl.pl, there are 2 -I
parameters).
Also,
[bash]perl -V
Can't locate Config.pm in @INC (@INC contains:
/ade/stvobadm_perl_583_build/perl/bin/Solaris/Opt/lib/5.8.3/sun4-solaris
-thread-multi
/ade/stvobadm_perl_583_build/perl/bin/Solaris/Opt/lib/5.8.3
/ade/stvobadm_perl_583_build/perl/bin/Solaris/Opt/lib/site_perl/5.8.3/su
n4-solaris-thread-multi
/ade/stvobadm_perl_583_build/perl/bin/Solaris/Opt/lib/site_perl/5.8.3
/ade/stvobadm_perl_583_build/perl/bin/Solaris/Opt/lib/site_perl .).
BEGIN failed--compilation aborted.
========================================================================
=================================================
Thanks and Regards,
DD
-----Original Message-----
From: scoles@xxxxxxxxxxx [mailto:scoles@xxxxxxxxxxx]
Sent: Friday, May 02, 2008 3:44 PM
To: Shanmugam, Dhandapani
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Perl in 10.2.0.3
The real question is does PERL support 64-bit operating systems?
We use PERL all the time on 64-bit systems with Oracle the only
problematic part is trying to get Perl, DBI and DBD to compile on a
64bit system.
Once it is up and running I have never run into any issues with 32bit vs
64 bit Oracle and PERL.
cheers
> Hi,
>
> Kindly clarify me on the below think
>
> We have Development users who uses PERL for there development work in
> oracle 9.2.0.8 32 bit version. In the past they had trouble compiling
> PERL on ORACLE 10g 64-bit, So we have not upgraded the database to 10g
> version. Do oracle 10.2.0.3 supports PERL?
>
>
> Thanks and Regards,
> Dhandapani S
>
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
