Re: Why do I encounter this error ? ORA-12705 : Cannot access NLS data files or invalid environment specified



pmonschein@xxxxxxxxxxxxxxxx wrote:
Hello John

I think you shot very well and very fast :-)

I compiled DBD::Oracle with the 32 client of Oracle 9i that is installed in 64bit too.

So because NLS data in Oracle 9i are stored by default in /app/oracle/product/9.2.0/enterprise64bit/ocommon/nls/admin/data
I set the ORA_NLS33 to this path (I set ORA_NLS33 because I am using within Perl the Oracle 9i client library).
And then it works !

I am glad It was sort of a wisdom guess on my part. I have never used 32/64 bit boxes but I have seen lots of posts on this vain
So I am happy : it works but I am confused now. Did I do something wrong ?
No nothing these configuration snafus happen all the time especially when working on 32/64 bit boxes
My environment is a mix of Oracle 9i and Oracle 10g installed in 64bit on different Unix
I decided to build DBD::Oracle with Oracle 9i, perhaps would it be better to compile with Oracle 10g.

And for Perl scripts, perhaps is it better to set variables inside the script itself instead of using variable of environment ?
I test that too it works.
Do you have recommendations in regards with your experience ?

The instant client might be what you it has a very small footprint.

As for setting the variables in the script I think that will make you code work for a entire environment and removes possiable users problems who might have different setting that override or confuse DBD::Oracle or Oracle. Of course it all depends on what you are going to use the script for and who is using it. So short answer Yes with a But, Long Answer No with a Maybe.

Cheers


.

Relevant Pages

  • Re: Possible memory corruption bug in DBD::Oracle
    ... I reproduced it on Oracle 9.0.1. ... > machines with Oracle client 9.2. ... > Here is a simple script that exhibits the problem ... ... > You are executing an anonymous PL/SQL block ...
    (perl.dbi.users)
  • Re: DBD::Oracle / Instant Client segfaults
    ... I've been doing some more tests concerning this issue and it seems that it only appears with the combination of Oracle Instant client libraries, Perl configured with -Dusemymalloc on RHEL 3. ... When i run the script with the 'use Digest::SHA1;' line commented ...
    (perl.dbi.users)
  • Re: DBI with different versions of Oracle
    ... What would happen in this case it would use the client from 9.2.0.6 not the DB. ... DBI with different versions of Oracle ... I have found in the previous version, if ORACLE_HOME is 9.2.0.6 when you originally compiled the module and you decide to use oracle 10g, the module will try to use use the oracle version that has been set when the module was built. ... anyones guess as to which client your DBD::Oracle with compile against. ...
    (perl.dbi.users)
  • RE: OCI Initialize failed 1804 check ORACLE_HOME NLS_SETTINGS
    ... I tried to compile DBD:Oracle 1.15 with Oracle 10g client on HP-UX11.11 ... You should not have to recompile Perl again but you will have to ...
    (perl.dbi.users)
  • Possible memory corruption bug in DBD::Oracle
    ... I'm not sure whether this is a DBD::Oracle bug or a bug in the Oracle ... machines with Oracle client 9.2. ... Here is a simple script that exhibits the problem ... ... You are executing an anonymous PL/SQL block ...
    (perl.dbi.users)