ORA-12705: invalid or unknown NLS parameter value specified

[Former Member]

When I update the SAP Kernel SAP 6.20 to 6.40 ( I have HPUX B11.11 with a Oracle database 9.2.0.8) SAP not start and when I launch « R3trans –x » I have this message error

This is R3trans version 6.13 (release 640 - 10.07.07 - 13:48:00).

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

R3trans finished (0012).

Here the file log R3trans :

4 ETW000 R3trans version 6.13 (release 640 - 10.07.07 - 13:48:00).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 02.01.2008 - 14:22:12

4 ETW000 control file:

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 Wed Jan 2 14:22:12 2008 317 0.000317

4 ETW000 db_con_init called 16 0.000333

4 ETW000 create_con (con_name=R/3) 80 0.000413

4 ETW000 Loading DB library '/usr/sap/C11/SYS/exe/run/dboraslib.sl' ...

4 ETW000 80 0.000493

4 ETW000 load shared library (/usr/sap/C11/SYS/exe/run/dboraslib.sl), hdl 0

4 ETW000 40718 0.041211

4 ETW000 Library '/usr/sap/C11/SYS/exe/run/dboraslib.sl' loaded

4 ETW000 59 0.041270

4 ETW000 function DbSlExpFuns loaded from library /usr/sap/C11/SYS/exe/run/dboraslib.sl

4 ETW000 76 0.041346

4 ETW000 Version of '/usr/sap/C11/SYS/exe/run/dboraslib.sl' is "640.00", patchlevel (0.175)

4 ETW000 203 0.041549

4 ETW000 function dsql_db_init loaded from library /usr/sap/C11/SYS/exe/run/dboraslib.sl

4 ETW000 28 0.041577

4 ETW000 function dbdd_exp_funs loaded from library /usr/sap/C11/SYS/exe/run/dboraslib.sl

4 ETW000 61 0.041638

4 ETW000 New connection 0 created 25 0.041663

4 ETW000 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000

, con_max = 255, con_opt = 255, occ = NO

4 ETW000 31 0.041694

4 ETW000 db_con_connect (con_name=R/3) 58 0.041752

4 ETW000 find_con_by_name found the following connection for reuse:

4 ETW000 23 0.041775

4 ETW000 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000,

con_max = 255, con_opt = 255, occ = NO

4 ETW000 27 0.041802

4 ETW000 Got ORACLE_HOME=/oracle/C11/920_64 from environment

4 ETW000 584 0.042386

4 ETW000 -->oci_initialize (con_hdl=0) 56 0.042442

4 ETW000 got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment

4 ETW000 23 0.042465

4 ETW000 Client NLS settings: AMERICAN_AMERICA.US7ASCII 2970 0.045435

4 ETW000 Logon as OPS$-user to get SAPC11's password 37 0.045472

4 ETW000 Connecting as /@C11 on connection 0 (nls_hdl 0) ... (dbsl 640 250407)

4 ETW000 32 0.045504

4 ETW000 Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBat

ch

4 ETW000 34 0.045538

4 ETW000 0 US7ASCII 1 8000000100ade450 8000000100ae5

c90 8000000100ae5628

4 ETW000 27 0.045565

4 ETW000 Allocating service context handle for con_hdl=0 41 0.045606

4 ETW000 Allocating server context handle 27 0.045633

4 ETW000 Attaching to DB Server C11 (con_hdl=0,svchp=8000000100ae5558,srvhp=8000000100ae6358)

4 ETW000 77 0.045710

4 ETW000 Assigning server context 8000000100ae6358 to service context 8000000100ae5558

4 ETW000 46191 0.091901

4 ETW000 Allocating user session handle 48 0.091949

4 ETW000 Starting user session (con_hdl=0,svchp=8000000100ae5558,srvhp=8000000100ae6358,usrhp=800000010

0af05a8)

4 ETW000 31 0.091980

4 ETW000 *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 12705

4 ETW000 2989 0.094969

4 ETW000 server_detach(con_hdl=0,stale=1,svrhp=8000000100ae6358)

4 ETW000 26 0.094995

4 ETW000 Detaching from DB Server (con_hdl=0,svchp=8000000100ae5558,srvhp=8000000100ae6358)

4 ETW000 25 0.095020

4 ETW000 Deallocating server context handle 8000000100ae6358

4 ETW000 535 0.095555

4 ETW000 *** ERROR => CONNECT failed with sql error '12705'

4 ETW000 82 0.095637

4 ETW000 set_ocica() -> OCI or SQL return code 12705 33 0.095670

4 ETW000 Try to connect with default password 30 0.095700

4 ETW000 Connecting as SAPC11/@C11 on connection 0 (nls_hdl 0) ... (dbsl 640 250407)

4 ETW000 34 0.095734

4 ETW000 Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBat

ch

4 ETW000 28 0.095762

4 ETW000 0 US7ASCII 1 8000000100ade450 8000000100ae5

c90 8000000100ae5628

4 ETW000 26 0.095788

4 ETW000 Allocating server context handle 18 0.095806

4 ETW000 Attaching to DB Server C11 (con_hdl=0,svchp=8000000100ae5558,srvhp=8000000100ae6358)

4 ETW000 175 0.095981

4 ETW000 Assigning server context 8000000100ae6358 to service context 8000000100ae5558

4 ETW000 37466 0.133447

4 ETW000 Assigning username to user session 8000000100af05a8

4 ETW000 30 0.133477

4 ETW000 Assigning password to user session 8000000100af05a8

4 ETW000 29 0.133506

4 ETW000 Starting user session (con_hdl=0,svchp=8000000100ae5558,srvhp=8000000100ae6358,usrhp=800000010

0af05a8)

4 ETW000 26 0.133532

4 ETW000 *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 12705

4 ETW000 5175 0.138707

4 ETW000 server_detach(con_hdl=0,stale=1,svrhp=8000000100ae6358)

4 ETW000 24 0.138731

4 ETW000 Detaching from DB Server (con_hdl=0,svchp=8000000100ae5558,srvhp=8000000100ae6358)

4 ETW000 25 0.138756

4 ETW000 Deallocating server context handle 8000000100ae6358

4 ETW000 206 0.138962

4 ETW000 *** ERROR => CONNECT failed with sql error '12705'

4 ETW000 33 0.138995

4 ETW000 set_ocica() -> OCI or SQL return code 12705 17 0.139012

4 ETW000 ***LOG BY2=>sql error 12705 performing CON

4 ETW000 201 0.139213

4 ETW000 ***LOG BY0=>ORA-12705: invalid or unknown NLS parameter value specified

4 ETW000 26 0.139239

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

[Former Member]

Hello Stefan,

SQL> SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';

VALUE

-

---

WE8DEC

SQL> SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_NCHAR_CHARACTERSE

T';

VALUE

-

---

UTF8

Regards

Thomas

[stefan_koehler]

Hello Thomas,

your environment and database characterset seems to be ok.

I think there is something wrong with your client (nls files) installation. Unfortunately we don't see which libraries are linked in.

As Fidel already mentioned you have to check your client installation and have a look at sapnote #521230.

> R/3 kernel 6.x: The path /oracle/client/81x_<bits>/lib is permanently set in the kernel -> No reference required in <LIBRARYPATH>

But i doubt this statement by SAP, because of we are running 6.40 kernel with 9i clients.

Another sapnote #952388 is confirming my dobut.

The only way to go throug this and be sure is to trace the systemcalls. With HPUX 11 there is a tool called tusc which is able to do this: http://h21007.www2.hp.com/portal/site/dspp/PAGE.template/page.document?ciid=61086d6e1de021106d6e1de0...

If you would install this tool and will execute it - we will be able to see the nls files / libraries which are used:

> tusc "R3trans –x" -o /tmp/tusc.out

After this please upload the tusc.out file to a file hoster like rapidshare.

Which client is installed on your HPUX system?

Regards

Stefan

[fidel_vales]

Hi,

That is too complicated.

First, have you changed the oracle client and the environemnt variables related to it?

I do not see any answer to this question.

What is the value of ORA_NLS33?

what is the output of

ls -l /oracle/client

ls -l /oracle/client/92x_64

ls -l /oracle/client/92x_64/lib

The note 521230 is a generic one and it mentions:

>3. How is the Oracle client software version dependent on the Oracle

> release and the R/3 kernel?

>...

>6.20 (except AIX 5.x 64-bit, HPIA64): 8.1.7

>6.20 UNICODE (+ 6.20 AIX, HPIA64): 9.2.0

>6.40: 9.2.0

between other things.

The part of the note you quoted is not correct (better, it is not updated), thanks for pointing it out.

It should say (to be coherent with the previous part):

>R/3 kernel 6.2: The path /oracle/client/81x_<bits>/lib is

>permanently set in the kernel -> No reference required in

><LIBRARYPATH>

>R/3 kernel 6.2 UNICODE and 6.40: The /oracle/client/92x_<bits>/lib path

>is permanently set in the kernel -> No reference required in

><LIBRARYPATH>

Edited by: Fidel Vales on Jan 4, 2008 2:14 PM

[stefan_koehler]

Hi Fidel,

>> First, have you changed the oracle client and the environemnt variables related to it?

Of course he answerd the questions already - he said that he didn't change the client on server or client side.

>> What is the value of ORA_NLS33?

It is not set, because of the "env | grep -i nls" only shows the NLS_LANG variable.

So i think, the old oracle client 81x is installed and not the 92x one, but to be sure which client is used or required we can use "tusc"

Regards

Stefan

[fidel_vales]

Hi,

If what you mention is correct, there is nothing to be check.

Client 9.2 must be installed when kernel 6.40 is installed and it must be configured.

All explained on the note

539922 Installing the ORACLE client software 9.2.X for UNIX

if there are no errors on the note, of course.

The note indicate the environment variable settings ...

[Former Member]

Hello Stefan,

env | grep -i nls

NLS_LANG=AMERICAN_AMERICA.WE8DEC

Have you changed the folder of the oracle NLS files (of your client or server)?

no

Have you downloaded the unicode or non unicode kernel?

Non unicode Kernel

Regards

Thomas

[fidel_vales]

hi,

Kernel 6.20 uses oracle client 8i ( with few exceptions, but HPUX RISC is not one of them )

Kernel 6.40 uses oracle client 9i.

Have you installed/configured/changed environment variables as required for a client change?

see notes:

521230 FAQ: Client software 9i or earlier on UNIX

539922 Installing the ORACLE client software 9.2.X for UNIX

[stefan_koehler]

Hello Thomas,

1) Please post the environment of the <sid>adm user:

> env | grep -i nls

2) Have you changed the folder of the oracle NLS files (of your client or server)?

3) Please post the following query result:

> shell> sqlplus "/ as sysdba"

> SQL> SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';

> SQL> SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_NCHAR_CHARACTERSET';

4) Have you downloaded the unicode or non unicode kernel?

Regards

Stefan

[markus_doehr2]

What NLS parameters have you set?

- login as c11adm

- enter "env | grep -i nls"

Markus