Perl5.8 Oracle DBI connects failing

From: vmbharathi@xxxxxxxxx (Bharathi Masilamani)
Date: Thu, 16 Nov 2006 19:21:23 -0800

Hi,
I am unable to connect to my oracle database I am getting the following
errors..

" DBI connect Failed: connect Failing because of ERROR OCIEnvNlsCreate.
Check ORACLE_HOME env var, NLS settings, permissions, etc."

I stumble into this when I try to execute

"$dbh->selectall_arrayref( $sql )"

I am running Perl5.8 on Red Hat Enterprise Edition 3 and using DBD Oracle
1.17, DBI 1.46 trying to access Oracle 10g

I am not sure which module was compiled against which one..?

any insight into whats happenign here can be great.

Thanks
--

-vmbharathi

I can resist anything but temptation

Follow-Ups:
- Re: Perl5.8 Oracle DBI connects failing
  - From: John Scoles

Prev by Date: Re: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?
Next by Date: Re: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?
Previous by thread: Fw: Problem trying to build and deploy DBD-Oracle 1.19
Next by thread: Re: Perl5.8 Oracle DBI connects failing
Index(es):
- Date
- Thread

Relevant Pages

Re: Required permissions cannot be acquired?
... Changing the file permissions was one of the things I tried. ... >¤ I have forms authentication in SQL RS working like a charm. ... I am now trying to do some authentication against an Oracle ... >Any application that is using the Authenticated User privilege will not work. ...
(microsoft.public.dotnet.security)
Re: Mounted volume, different permissions
... > some other stuff we were going to be installing, ... > Oracle software, and, using Veritas Volume manager, we created a 30GB ... > What exactly is going on between the permissions of the underlying mount ...
(comp.sys.sun.admin)
Re: 80004005 error with Oracle
... on all the files that I could see were relevant, the permissions were ... I have been working on Citrix 1 and 2 and ignoring 3 for the moment. ... tells me that all the Oracle database and networking is functioning ... ADO is a data access library which works with an Oracle OLE DB provider to ...
(microsoft.public.vb.database.ado)
10gR2 tru64 permissions
... I have some problems on a TRU64 box running a 10gR2 database. ... found some notes from oracle saying the owner group of Oracle_home ... Seems there are a lot of permissions problems on this box. ... cluster if I restart the computer an another node will restart the ...
(comp.databases.oracle.server)
SUMMARY: perl, oracle, sendmail and Solaris 10
... changing the permissions on the ORACLE_HOME files to 755 shouldn't be a ... After discussing with our Oracle admins, ... We have a perl script that gets executed when users send email ... having problems getting this script to work with the alias. ...
(SunManagers)