ORA-12705 Cannot access NLS data files (EHP4:problems with SYSTEM password

[uta_hedemann]

When installing ehp4 with sapehpi on a distributed system (CI and DB are on different hosts)I get following error in phase PREP_INPUT/DBQUERY_PRE:

>>>> Required system passwords <<<<

ERROR: SYSTEM password does not work, please reenter.

CHKSYSPWD.LOG:

SAPehpi> Starting subprocess 22360 at 20101105120955
ENV: DIR_LIBRARY=/sapmnt/D01/EHPI/abap/exe
ENV: JAVA_HOME=/usr/java
ENV: LD_LIBRARY_PATH=/sapmnt/D01/EHPI/abap/exe:/sapmnt/D01/EHPI/jvm/jre/lib/sparcv9/server:/sapmnt/D01/
EHPI/jvm/jre/lib/sparcv9:/sapmnt/D01/EHPI/jvm/jre/../lib/sparcv9:/usr/sap/D01/SYS/exe/run:/oracle/clien
t/10x_64/instantclient
ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
ENV: ORACLE_BASE=/oracle
ENV: ORACLE_SID=D01
ENV: PATH=/sapmnt/D01/EHPI/abap/exe:/usr/java/bin:/usr/sap/d01adm:/usr/sap/D01/SYS/exe/run:/usr/bin:.:/
usr/ccs/bin:/usr/ucb
ENV: SAPSYSTEMNAME=D01
ENV: auth_shadow_upgrade=0
ENV: dbms_type=ORA
ENV: dbs_ora_schema=SAPSR3
ENV: dbs_ora_tnsname=D01

EXECUTING /sapmnt/D01/EHPI/abap/exe/brconnect (/sapmnt/D01/EHPI/abap/exe/brconnect) <args>...
BR0801I BRCONNECT 7.20 (7)
BR0280I BRCONNECT time stamp: 2010-11-05 12.09.55
BR0301E SQL error -12705 at location db_connect-2, SQL statement:
'CONNECT SYSTEM/********@D01'
ORA-12705: Cannot access NLS data files or invalid environment specified
BR0310E Connect to database instance D01 failed

BR0280I BRCONNECT time stamp: 2010-11-05 12.09.55
BR0804I BRCONNECT terminated with errors
Process with ID 22360 terminated with status 3

I have checked the environment according note 830578 on database server and sap central instance server.

Connect on db-server with system and given password works fine.

R3trans -x on ci-host with user <sid>adm works also fine.

Any ideas ?

[Former Member]

HI,

Try to delete NLS_LANG from CI and then retry .

Regards,

[Former Member]

Hi Uta,

Check NLS_LANG environment variable. Try to set it to "AMERICAN_AMERICA.WE8DEC". If it is not work then drop it, then try to perform the phase again.

Best regards,

Orkun Gedik

[uta_hedemann]

But NLS_LANG=AMERICAN_AMERICA.UTF8 should be o.k, because:

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

[Former Member]

Ok. Then try to delete the environment variable. Then, perform the phase again.

[uta_hedemann]

Problem was solved WITHOUT deleting NLS_LANG from environment.

I have exchanged the downwards compatible 7.20 Brtools in /sapmnt/SID/exe and my EHP-Directory /sapmnt/<SID>/EHPI/abap/exe againt the 7.10 brtools. Now sapehpi is running again....

7.20- Brtools seems to be not 100 % downwards compatible, even when note 12741 says:

The BR*Tools 7.20 can be used with all SAP releases that run with an Oracle 10g or 11g.

Edited by: Uta Hedemann on Nov 5, 2010 4:00 PM