NLS_NCHAR on Oracle client

[Former Member]

Hi Gurus,

I encountered this error when starting sap.

I have changed the environment on oraSID and SIDadm but the problem persists.

> env | grep -i lang

LANG=WE8DEC

NLS_LANG=AMERICAN_AMERICA.WE8DEC

Kindly advice on how to change NLS_NCHAR on Oracle client. THanks in advance.

Oracle client version: 11.2.0.3.0, V1, default build, (dbsl 740 140314, non-unicode)

C  Installed Oracle client patches:

C  # Patch  13508485     : Created on 21 Dec 2011, 13:23:38 hrs PST8PDT

C  # Patch Description: Created on  3 Jan 2012, 02:50:27 hrs PST8PDT

C  # Patch  11742262     : Created on  7 Mar 2012, 12:22:41 hrs CET

C  Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF8'

C     default client setting: NLS_CHAR=charset='UTF8'

C  Connecting as SAPR3/<pwd>@DV1 on connection 0 (nls 0) ... (dbsl 740 140314, non-unicode)

C  Attaching to database server DV1 (con=0, svchp=8, srvhp=0)

C  Starting user session: OCISessionBegin(con=0, usr='SAPR3', svc=8, srv=0, usr=0)

C  Now 'SAPR3/<pwd>@DV1' is connected: con=0, nls=0, session=120, time='2014-10-05 13:42:32'

C  DB instance DV1 is running on xxxdev with ORACLE version 11.2.0.3.0 since OCT 05, 2014, 13:42:02.

C  con=0, V$NLS_PARAMETERS: NLS_LANG=AMERICAN_AMERICA.WE8DEC, NLS_NCHAR=UTF8

C  ]*** ERROR => Env. NLS_LANG='AMERICAN_AMERICA.UTF8' not compatible to V$NLS_PARAMETERS: 'AMERICAN_AMERICA.WE8DEC', connection refused.

[dbsloci.c    16626

[ACE-SAP]

Hi

If your system is Unicode the NLS_LANG env var should be set to AMERICAN_AMERICA.UTF8.

Check also note 1837503 - SAP system could not connect to DB

Regards

606359 - FAQ Oracle National Language Support (NLS)

[Former Member]

Hi Yves,

I managed to overcome this issue by changing the LANG value in .dbenv.sh (.csh).

Currently I'm able to start SAP.

New issue comeup .

SAPlogon showing this message : logon not possible (error in license check). I shall start new discussion for this. Thanks

R,

AM

[ACE-SAP]

Hi Alamsyah

Search on SCN you'll quickly find the answer.

You just need to drop the license, install a temporary one or request a new one.

This can be done through command line using saplikey tool.

Regards

Delete all existing license(s)

saplikey pf=/usr/sap/<SID>/sys/profile/<SID>_DVEBMGS00_<hostname> -delete <SID> <HW Key> <product>

Create temporary license

saplikey pf=/usr/sap/<SID>/sys/profile/<SID>_DVEBMGS00_<hostname> -temp NetWeaver_ORA

Install license

saplikey pf=/usr/sap/<SID>/sys/profile/<SID>_DVEBMGS00_<hostname> -install D:\finename.txt

870871 - License key installation