RE: Help with 10.2.0.3 instant client and Perl 5.8.5
- From: "Peter McLarty" <p.mclarty@xxxxxxxxxx>
- To: <Mark.Bobak@xxxxxxxxxxxxxxx>
- Date: Mon, 22 Oct 2007 13:23:43 +1000
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:
