RE: Help with 10.2.0.3 instant client and Perl 5.8.5

I have found an anomoly with DBI on quad core Xeon processors HP boxes,
we needed to recompile DBI on those boxes. Same code was in use on dual
core CPU servers. This was redhat same release
 
Can you connect without NLS Parameters?
 
I would compile both DBI and DBD on that server for the 10g client


Cheers
 
Peter

________________________________

From: Stefan Knecht [mailto:knecht.stefan@xxxxxxxxx] 
Sent: Sunday, 21 October 2007 08:13 PM
To: Mark.Bobak@xxxxxxxxxxxxxxx
Cc: oracle-l
Subject: Re: Help with 10.2.0.3 instant client and Perl 5.8.5


And one more idea -- 

in 10.2.0.3 the default permissions have changed of various places in
ORACLE_HOME.

And according to 
oracle@central:~/ [CENTRAL] oerr ora 12705
12705, 00000, "Cannot access NLS data files or invalid environment
specified" 
// *Cause: Either an attempt was made to issue an ALTER SESSION command
//         with an invalid NLS parameter or value; or the environment
//         variable(s) NLS_LANG, ORA_NLSxx, or ORACLE_HOME was
incorrectly 
//         specified, therefore the NLS data files cannot be located.

it may not be able to read the nls files.

Try running strace -o strace.log <your perl script that fails>

Then grep the output file for "open" and check for permission errors. 

Stefan




On 10/16/07, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxxxxx> wrote: 

        Hi,

         

        Trying to port some stuff to 10.2 instant client, and getting an
ORA-12705 in OCISessionBegin with NLS_LANG set to
AMERICAN_AMERICA.WE8ISO8859P1, which appears to be a perfectly valid
value.  SQL*Plus from the same instant client home works fine.  Using
the 9i client works fine.

         

        Anyone have any ideas?

         

        Thanks,

         

        -Mark

         

        PS   This is RedHat Linux, Enterprise Server 4 Update 3.

         

        --
        Mark J. Bobak
        Senior Database Administrator, System & Product Technologies
        ProQuest
        789 E. Eisenhower, Parkway, P.O. Box 1346
        Ann Arbor MI 48106-1346
        +1.734.997.4059  or +1.800.521.0600 x 4059
        mark.bobak@xxxxxxxxxxxxxxx <mailto:mark.bobak@xxxxxxxxxxxxxxx> 
        www.proquest.com <http://www.proquest.com> 
        www.csa.com <http://www.csa.com> 
        
        ProQuest...Start here. 

         




-- 
=========================

Stefan P Knecht
Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20 
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht@xxxxxxxxxxxx
http://www.trivadis.com

OCP SCSA SCNA
========================= 

Other related posts: