Re: Perl in oracle 10.2.0.3 on 64 BIT OS
On 2008-05-19 17:17:22 -0700, Jonathan Leffler wrote: On Mon, May 19, 2008 at 11:49 AM, Shanmugam, Dhandapani [EMAIL PROTECTED] wrote: Does PERL support 64-bit operating systems? Yes. Kindly help me on how should perl work on Oracle 64-bit Solaris Operating system . Am getting the below error [bash]perl create_ddl.pl Can't locate DBI.pm in @INC So, you haven't installed DBI yet. You will have to do that before you can use it. For example, you must have DBI installed before installing DBD::Oracle. Given that the install is currently using Perl 5.8.3, you should build your own Perl, either 5.8.8 or 5.10.0, and then install it in a location of your own choosing (rather than messing with the system version) The install path looks strange: /ade/stvobadm_perl_583_build/perl/bin/Solaris/Opt I don't know where Solaris puts their files (last version of Solaris I used was 2.7 or maybe 8, I think), but I doubt that this is the system version. I have seen similarly crazy paths in the perl distributed with Oracle Application Server. OAS sets up the environment in such a way that it does work (on Fridays at full moon), but it is still a pain. I suspect that this version of perl is also distributed as part of some application and not intended to be standalone. I agree that the OP should just get a current version of perl (I guess there are binary packages available for solaris, or he can compile it himself) instead of trying to beat a messed-up version into submission. (If he needs to use perl *as part of* an application he should pester their tech support) and then get on with installing DBI and its pre-requisites and then install DBD::Oracle. I can't answer for whether DBD::Oracle supports 64-bit systems, but it would be astonishing (to me) if it did not do so. It works at least on 64-bit Linux. I believe 64-bit HP-UX has been mentioned on this list, too. hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users pgpfM5U52k43E.pgp Description: PGP signature
Perl in oracle 10.2.0.3 on 64 BIT OS
Does PERL support 64-bit operating systems? Kindly help me on how should perl work on Oracle 64-bit Solaris Operating system . Am getting the below error [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
Re: Perl in oracle 10.2.0.3 on 64 BIT OS
On Mon, May 19, 2008 at 11:49 AM, Shanmugam, Dhandapani [EMAIL PROTECTED] wrote: Does PERL support 64-bit operating systems? Yes. Kindly help me on how should perl work on Oracle 64-bit Solaris Operating system . Am getting the below error [bash]perl create_ddl.pl Can't locate DBI.pm in @INC So, you haven't installed DBI yet. You will have to do that before you can use it. For example, you must have DBI installed before installing DBD::Oracle. Given that the install is currently using Perl 5.8.3, you should build your own Perl, either 5.8.8 or 5.10.0, and then install it in a location of your own choosing (rather than messing with the system version) and then get on with installing DBI and its pre-requisites and then install DBD::Oracle. I can't answer for whether DBD::Oracle supports 64-bit systems, but it would be astonishing (to me) if it did not do so. Do not follow-up to me - use the list. -- Jonathan Leffler [EMAIL PROTECTED] #include disclaimer.h Guardian of DBD::Informix - v2008.0229 - http://dbi.perl.org Blessed are we who can laugh at ourselves, for we shall never cease to be amused.