Front page | perl.dbi.users |
Postings from February 2001
I have never had to set ORA_NLS33 to get DBI to return results. Further,
I'm not sure what it is for, although my guess is for multiple language sets
and/or Unicode. I'm curious... John, do you have your server specially
configured for Unicode or something?
> -----Original Message-----
> From: siberian [mailto:siberian@siberian.org]
> Sent: Tuesday, February 20, 2001 10:11 AM
> To: Strassel, Chris
> Cc: 'Michael Klein'; 'dbi-users@perl.org'
> Subject: RE: PERL DBI with Oracle 8.1.7?
>
>
> I have to set three variables to avoid issues like this :
>
> LD_LIBRARY_PATH=/usr/Oracle/u01/app/oracle/product/8.1.6/lib
> ORACLE_HOME=/usr/Oracle/u01/app/oracle
> ORA_NLS33=/usr/Oracle/u01/app/oracle/product/8.1.6/ocommon/nls/admin/data
>
> If I am missing the first two I get issues like the one described below.
> If I am missing ORA_NLS33 I just never get db results.
>
> John-
>
>
> On Tue, 20 Feb 2001, Strassel, Chris wrote:
> > I encountered this same problem a few days ago, and the solution was to
> > reset the Oracle environment variables and the LD_LIBRARY_PATH var.
> >
> > I have also run into some segmentation faults from the
> disconnect() method
> > when connecting to 8.1.7. Haven't tracked that down yet, though.
> >
> > Good luck...
> >
> > Chris
> >
> > -----Original Message-----
> > From: Michael Klein [mailto:mklein@bridgewatersystems.com]
> > Sent: Tuesday, February 20, 2001 1:04 PM
> > To: dbi-users@perl.org
> > Subject: PERL DBI with Oracle 8.1.7?
> >
> >
> > Has anyone encountered any problems running the PERL DBI with Oracle
> > 8.1.7?
> >
> > I didn't have any problems with Oracle 8.1.5, but after an upgrade to
> > Oracle 8.1.7, I'm now getting the error message shown at the bottom of
> > this message. I checked and found that the Oracle.so file does exist.
> > I then looked at DynaLoader.pm on line 200 and found the following
> > comment:
> >
> > # Many dynamic extension loading problems will appear to come from
> > # this section of code: XYZ failed at line 123 of DynaLoader.pm.
> > # Often these errors are actually occurring in the initialisation
> > # C code of the extension XS file. Perl reports the error as being
> > # in this perl code simply because this was the last perl code
> > # it executed.
> >
> > my $libref = dl_load_file($file, $module->dl_load_flags) or
> > croak("Can't load '$file' for module $module: ".dl_error());
> >
> >
> > install_driver(Oracle) failed: Can't load
> >
> '/usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBD/Oracle
> /Oracle.so
> > '
> > for module DBD::Oracle: ld.so.1: /usr/local/bin/perl: fatal:
> > libclntsh.so.8.0: open failed: No such file or directory at
> > /usr/local/lib/perl5/5.6.0/sun4-solaris/DynaLoader.pm line 200.
> > at (eval 1) line 3
> > Compilation failed in require at (eval 1) line 3.
> > Perhaps a required shared library or dll isn't installed where expected
> > at ./myfile.pl line 91
> >
> > Any ideas?
> >
> > Thanks for your time,
> > Mike
> >
>
>