ORA-12705: Cannot access NLS data files or invalid environment specified

[Former Member]

Hi

I am unable to connect the SAP. seen some post regarding this error but couldn't get over it.

The Oracle DB and client version is 10.2.0.4

Appreciate your help....Thanks

trans.log

-

---

4

*4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705'*

4 ETW000 51 1.300549

*4 ETW000 [dblink ,00419] **LOG BY2=>sql error 12705 performing CON [dblink#2 @ 419]

4 ETW000 221 1.300770

*4 ETW000 [dblink ,00419] **LOG BY0=>ORA-12705: Cannot access NLS data files or invalid environment specified [dblink#2 @ 419]4 ETW000 24 1.300794

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'QEC'"

[markus_doehr2 · Accepted solution]

- Did you upgrade your database?

- Did you install Oracle before you started the database installation?

- What OS is that?

Markus

[Former Member · Accepted solution]

Hi Sachin, Markus

This is ECC 5 and the DB is upgraded from 9.2.0.7 to 10.2.0.4, Also installled the client 10.2.0.4.

OS is Solaris 5.9

NLS_LANG is AMERICAN.AMERICA.WE8DEC.

Do you thiink I have to revert back the client to 9.2.0 for ECC5

Thanks

Shaji

Edited by: Shaji Jacob on Sep 25, 2009 7:41 PM

[fidel_vales · Accepted solution]

Hi,

> Do you thiink I have to revert back the client to 9.2.0 for ECC5

Have you changed the SAP Kernel?

I assume NO.

Have you read the Oracle-SAP Upgrade guide to 10g in Unix?

I assume you have not done so completely, because in the guide it does NOT mentioned anywhere to change the oracle client.

The ORACLE Client that the SAP Kernel used depends on the SAP Kernel Version. It does NOT depends on the Oracle RDBMS version. Therefore, if you upgrade ONLY the RDBMS version you do not have to change the client version nor the environment variables related to the kernel.

[markus_doehr2 · Accepted solution]

> This is ECC 5 and the DB is upgraded from 9.2.0.7 to 10.2.0.4, Also installled the client 10.2.0.4.

> OS is Solaris 5.9

> NLS_LANG is AMERICAN.AMERICA.WE8DEC.

and NLS_33 is also set?

> Do you thiink I have to revert back the client to 9.2.0 for ECC5

If you use the current kernel, yes. If you install kernel 640_EX2 you use the Oracle 10g client.

Markus

[Former Member · Accepted solution]

Hi Markus, Fidel,

Thanks for your replies.

The issue is fixed, after adding the ORA_NLS33 parameter.

The SAP Kernel -640 was upgraded from 118 to 274 but not of 640_EX2..

Thanks everybody for your replies and help.

Regards

Shaji

[Former Member · Accepted solution]

Hi Shaji,

Please be reminded to close the thread if the problem is solved.

Best regards,

Warren

[Former Member]

Hi,

Check NLS_LANG parameter is set correctly.

Also check Oracle client sofware is correctly installed.

Errors are originating from oracle client software.

Regards,

Sachin Rane.