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_at_gmail.com] Sent: Sunday, 21 October 2007 08:13 PM
To: Mark.Bobak_at_il.proquest.com
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_at_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_at_il.proquest.com> 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_at_il.proquest.com <mailto:mark.bobak_at_il.proquest.com> 
	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_at_trivadis.com
http://www.trivadis.com

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

--
http://www.freelists.org/webpage/oracle-l