Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Help with 10.2.0.3 instant client and Perl 5.8.5

Re: Help with 10.2.0.3 instant client and Perl 5.8.5

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Sun, 21 Oct 2007 03:12:54 -0700
Message-ID: <486b2b610710210312k41ee8c65mba70bda876e9cdd4@mail.gmail.com>


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
> www.proquest.com
> 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
Received on Sun Oct 21 2007 - 05:12:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US