Re: Help with 10.2.0.3 instant client and Perl 5.8.5

  • From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
  • To: Mark.Bobak@xxxxxxxxxxxxxxx
  • Date: Sun, 21 Oct 2007 03:12:54 -0700

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
> 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@xxxxxxxxxxxx
http://www.trivadis.com

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

Other related posts: