ORACLE NLS_LANG on Dialog Instance (Application Server)

[Former Member]

Hello everyone

We upgraded to Oracle 10 on the DB/CI

We also upgraded the Kernel version to the latest 640_EX2 Kernel on the App. Server.

However when doing an R3trans -x on the App server. We got the following error.

Got ORACLE_HOME=/oracle/client from environment 528 0.075553

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 117 0.075670

4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment

4 ETW000 41 0.075711

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII 13442 0.089153

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPR3's password 91 0.089244

4 ETW000 [dev trc ,00000] Connecting as /@QA7 on connection 0 (nls_hdl 0) ... (dbsl 640 070208)

4 ETW000 42 0.089286

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 58 0.089344

4 ETW000 [dev trc ,00000] 0 US7ASCII 1 1012d1d00 1012d9750 1012daf18

4 ETW000 51 0.089395

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 25 0.089420

4 ETW000 [dev trc ,00000] Allocating server context handle 44 0.089464

4 ETW000 [dev trc ,00000] Attaching to DB Server QA7 (con_hdl=0,svchp=1012dae48,srvhp=1012db5e8)

4 ETW000 72 0.089536

4 ETW000 [dev trc ,00000] Assigning server context 1012db5e8 to service context 1012dae48

4 ETW000 328370 0.417906

4 ETW000 [dev trc ,00000] Allocating user session handle 48 0.417954

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=1012dae48,srvhp=1012db5e8,usrhp=1012d9f68)

4 ETW000 57 0.418011

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 12705

4 ETW000 8210 0.426221

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=1012db5e8)

4 ETW000 32 0.426253

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=1012dae48,srvhp=1012db5e8)

4 ETW000 26 0.426279

4 ETW000 [dev trc ,00000] Deallocating server context handle 1012db5e8 501 0.426780

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

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12705 17 0.685896

4 ETW000 [dblink ,00428] ***LOG BY2=>sql error 12705 performing CON [dblink#3 @ 428]

4 ETW000 109 0.686005

4 ETW000 [dblink ,00428] **LOG BY0=>ORA-12705: invalid or unknown NLS parameter value specified [dblink#3 @ 428]*4 ETW000 27 0.686032

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

The NLS_LANG for the DB is AMERICAN_AMERICA.WE8DEC. How do I switch the Oracle Client on the App. server to use AMERICAN_AMERICA.WE8DEC instead of US7ASCII

The environment variables (this is a UNIX/SOLARIS system) has been set

dbms_type=ORA

dbs_ora_tnsname=QA7

dbs_ora_schema=SAPR3

ORACLE_PSRV=QA7

ORACLE_SID=QA7

DB_SID=QA7

ORACLE_HOME=/oracle/client

ORACLE_BASE=/oracle

NLS_LANG=AMERICAN_AMERICA.WE8DEC

SAPDATA_HOME=/oracle/QA7

LD_LIBRARY_PATH=/usr/sap/QA7/SYS/exe/run/:oracle/client/10x_64/instantclient:/usr/sap/QA7/SYS/exe/run

Any ideas, anyone ?

Any pointers greatly appreciated.

[stefan_koehler · Accepted solution]

Hello,

which Kernel version did you download? (Unicode/ Non-Unicode)

Info: The national character set is not important for ABAP systems (check sapnote #669902)

Regards

Stefan

[Former Member]

Hi Fidel

It seems it has been solved.

Some guy here claimed he removed the double reference to the LD_LIBRARY_PATH

the new LD_LIBRARY_PATH is now

SAPSYSTEMNAME=QA7

DIR_LIBRARY=/usr/sap/QA7/SYS/exe/run

LD_LIBRARY_PATH=/usr/sap/QA7/SYS/exe/run:/oracle/client/10x_64/instantclient

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=QA7

dbs_ora_schema=SAPR3

ORACLE_PSRV=QA7

It seems to work now, though it's a strange solution.

Thanks for the help.

[fidel_vales]

Hi,

Happy that is solved

Sad because I have no clue whatsoever why it is solved

[Former Member]

Hi Fidel

The ldd is :

sap04:qa7adm 13% ldd libclntsh.so.10.1

libnnz10.so => /oracle/client/10x_64/instantclient/libnnz10.so

libkstat.so.1 => /lib/64/libkstat.so.1

libnsl.so.1 => /lib/64/libnsl.so.1

libsocket.so.1 => /lib/64/libsocket.so.1

libgen.so.1 => /lib/64/libgen.so.1

libdl.so.1 => /lib/64/libdl.so.1

libsched.so.1 => /usr/lib/64/libsched.so.1

libaio.so.1 => /lib/64/libaio.so.1

librt.so.1 => /lib/64/librt.so.1

libm.so.1 => /lib/64/libm.so.1

libc.so.1 => /lib/64/libc.so.1

libmp.so.2 => /lib/64/libmp.so.2

libmd.so.1 => /lib/64/libmd.so.1

libscf.so.1 => /lib/64/libscf.so.1

libdoor.so.1 => /lib/64/libdoor.so.1

libuutil.so.1 => /lib/64/libuutil.so.1

libm.so.2 => /lib/64/libm.so.2

/platform/SUNW,Sun-Fire-V240/lib/sparcv9/libmd_psr.so.1

[Former Member]

Hi Fidel

Sorry for the screen.

Not sure what the issues is (I usually 'minimize' the left detailed nav portion, by clicking on the "<" to increase the screen size)

This is the ooutput of the ldd

sap04:qa7adm 4% ldd dboraslib.so

libdl.so.1 => /lib/64/libdl.so.1

libnsl.so.1 => /lib/64/libnsl.so.1

libsocket.so.1 => /lib/64/libsocket.so.1

libclntsh.so.10.1 => /oracle/client/10x_64/instantclient/libclntsh.so.10.1

libnnz10.so => /oracle/client/10x_64/instantclient/libnnz10.so

libc.so.1 => /lib/64/libc.so.1

libmp.so.2 => /lib/64/libmp.so.2

libmd.so.1 => /lib/64/libmd.so.1

libscf.so.1 => /lib/64/libscf.so.1

libkstat.so.1 => /lib/64/libkstat.so.1

libgen.so.1 => /lib/64/libgen.so.1

libsched.so.1 => /usr/lib/64/libsched.so.1

libaio.so.1 => /lib/64/libaio.so.1

librt.so.1 => /lib/64/librt.so.1

libm.so.1 => /lib/64/libm.so.1

libdoor.so.1 => /lib/64/libdoor.so.1

libuutil.so.1 => /lib/64/libuutil.so.1

libm.so.2 => /lib/64/libm.so.2

/platform/SUNW,Sun-Fire-V240/lib/sparcv9/libmd_psr.so.1

sap04:qa7adm 5%

[fidel_vales]

Hi,

Do not worry about the screen, it is not your fault.

getting interesting the issue (and running out of ideas)

Let me know the output of:

ldd /oracle/client/10x_64/instantclient/libclntsh.so.10.1

[Former Member]

HI stefan

It's Non-Unicode

[Former Member]

Hi Fidel

The outout is as follows.

sap04:qa7adm 40% ls -lR /oracle/client/10x_64

/oracle/client/10x_64:

total 14

lrwxrwxrwx 1 qa7adm sapsys 22 Aug 25 17:59 instantclient -> instantclient_10202_V2

drwxr-xr-x 2 qa7adm sapsys 512 Aug 26 16:47 instantclient_10202_V2

-rw-rr 1 qa7adm sapsys 4394 Aug 26 14:44 trans.log

/oracle/client/10x_64/instantclient_10202_V2:

total 129902

-rw-rr 1 qa7adm sapsys 336 Mar 31 07:09 IC.CKSUM

-rw-rr 1 qa7adm sapsys 1583682 Mar 18 06:07 classes12.jar

-rwxr-xr-x 1 qa7adm sapsys 33912 Mar 31 07:03 genezi

-rwxr-xr-x 1 qa7adm sapsys 23970672 Mar 31 05:34 libclntsh.so.10.1

-rwxr-xr-x 1 qa7adm sapsys 6899544 Mar 31 05:34 libnnz10.so

-rwxr-xr-x 1 qa7adm sapsys 1416904 Mar 31 05:34 libocci.so.10.1

-rwxr-xr-x 1 qa7adm sapsys 30815160 Mar 31 05:34 libociei.so

-rwxr-xr-x 1 qa7adm sapsys 123560 Mar 31 05:34 libocijdbc10.so

-rw-rr 1 qa7adm sapsys 1529660 Mar 18 06:06 ojdbc14.jar

-rw-rr 1 qa7adm sapsys 2131 Mar 31 07:04 package_info.txt

-rw-rr 1 qa7adm sapsys 9201 Aug 27 08:59 trans.log

Thanks for the effort !

[fidel_vales]

Grr,

I do not know why the post of this thread are wider than my screen and no there is no scroll bar

I almost can't press the reply button.

could you go to the kernel directory and execute

ldd dbsoraslib*

[Former Member]

Hi Markus

the output is

SQL> connect / as sysdba

Connected.

SQL> select property_value from database_properties where upper(property_name)='NLS_NCHAR_CHARACTERSET';

PROPERTY_VALUE

-

---

AL16UTF16

Thanks for the help.

[fidel_vales]

Hi,

Curious issue.

Environment variables seem to be OK (assuming that nothing else is set)

Can you provide with the outpiut of

> ls -lR /oracle/client/10x_64/

[markus_doehr2]

Execute the following under sqlplus:

select property_value from database_properties where upper(property_name) = 'NLS_NCHAR_CHARACTERSET';

What's the output?

Markus