Upgrade PREPARE : wrong parameter NLS_LANG

[Former Member]

I'm upgrade from R/3 4.70 to ECC 6.0.

However during execution 'Upgrade PREPARE', error was occurred.

My system's NLS_LANG=AMERICAN_AMERICA.WE8DEC.

but Client NLS settings: AMERICAN_AMERICA.US7ASCII.

I don't know that why client NLS is US7ASCII.

help me please.

thanks.

==========================================================================

BLOCKED SIGNALS: ''

SAPup> Starting subprocess 626888 at 20081229094416

ENV <0x2ff22bc4>: PATH=/oracle/L47/920_64/bin:/home/l47adm:/usr/sap/L47/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/l47adm/bin:/usr/bin/X11:/sbin:/usr/java14_64/bin:.

ENV <0x2017c1d8>: DIR_LIBRARY=/usr/sap/put/exe

ENV <0x2ff22d14>: dbms_type=ORA

ENV <0x2ff22d22>: dbs_ora_tnsname=L47

ENV <0x20150fe8>: dbs_ora_schema=SAPL47

ENV <0x2ff22d4c>: ORACLE_PSRV=L47

ENV <0x2ff22d5c>: ORACLE_SID=L47

ENV <0x2ff22d76>: ORACLE_HOME=/oracle/L47/920_64

ENV <0x2ff22d95>: ORACLE_BASE=/oracle

ENV <0x2ff22da9>: ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data

ENV <0x2ff22de0>: NLS_LANG=AMERICAN_AMERICA.WE8DEC

ENV <0x2017d4bc>: LIBPATH=/usr/sap/put/exe:/usr/java14_64/jre/bin:/usr/java14_64/jre/bin/classic:/usr/java14_64/jre/bin:/usr/sap/L47/SYS/exe/run:/usr/java14_64/jre/bin/sovvm

ENV <0x20150be8>: auth_shadow_upgrade=0

EXECUTING /usr/sap/put/exe/tp (tp) pf=/usr/sap/put/bin/DEFAULT.TPP execdbscript L47 -x SQLDBSCRIPT.TQL

This is /usr/sap/put/exe/tp version 372.04.08 (release 700)

ERROR: Connect to L47 failed (20081229094416, probably wrong environment).

Warning: Parameter INTERRUPT is no longer used.

Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.

Warning: Parameter WITH_TACOB is no longer used.

Warning: Parameter IMPDP_BY_EVENT is no longer used.

Warning: Parameter INTERRUPT is no longer used.

Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.

Warning: Parameter WITH_TACOB is no longer used.

Warning: Parameter IMPDP_BY_EVENT is no longer used.

Warning: Parameter DBCONFPATH is no longer used.

Warning: Parameter STARTDB is no longer used.

Warning: Parameter STOPDB is no longer used.

TRACE-INFO: 1: [dev trc ,00000] Mon Dec 29 09:44:16 2008 24506 0.024506

TRACE-INFO: 2: [dev trc ,00000] load shared library (/usr/sap/put/exe/dboraslib.o), hdl 0

TRACE-INFO: 3: 31 0.024537

TRACE-INFO: 4: [dev trc ,00000] Got LIBPATH=/usr/sap/put/exe:/usr/java14_64/jre/bin:/usr/java14_64/jre/bin/classic:/usr/java14_64/jre/bin:/usr/sap/L47/SYS/exe/run:/usr/java14_64/jre/bin/sovvm from environment

TRACE-INFO: 5: 2109 0.026646

TRACE-INFO: 6: [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 148 0.026794

TRACE-INFO: 7: [dev trc ,00000] -->oci_initialize (con_hdl=0) 19 0.026813

TRACE-INFO: 8: [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII 7484 0.034297

TRACE-INFO: 9: [dev trc ,00000] Logon as OPS$-user to get SAPL47's password 21 0.034318

TRACE-INFO: 10: [dev trc ,00000] Connecting as /@L47 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

TRACE-INFO: 11: 27 0.034345

TRACE-INFO: 12: [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

TRACE-INFO: 13: 31 0.034376

TRACE-INFO: 14: [dev trc ,00000] 0 US7ASCII 1 110ac8748 110ad1c80 110ad1530

TRACE-INFO: 15: 32 0.034408

TRACE-INFO: 16: [dev trc ,00000] Allocating service context handle for con_hdl=0 20 0.034428

TRACE-INFO: 17: [dev trc ,00000] Allocating server context handle 27 0.034455

TRACE-INFO: 18: [dev trc ,00000] Attaching to DB Server L47 (con_hdl=0,svchp=110ad1160,srvhp=110ad2460)

TRACE-INFO: 19: 137 0.034592

TRACE-INFO: 20: [dev trc ,00000] Assigning server context 110ad2460 to service context 110ad1160

TRACE-INFO: 21: 111117 0.145709

TRACE-INFO: 22: [dev trc ,00000] Allocating user session handle 84 0.145793

TRACE-INFO: 23: [dev trc ,00000] Starting user session (con_hdl=0,svchp=110ad1160,srvhp=110ad2460,usrhp=110ad0568)

TRACE-INFO: 24: 65 0.145858

TRACE-INFO: 25: [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=12705

TRACE-INFO: 26: 13079 0.158937

TRACE-INFO: 27: [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=110ad2460) 21 0.158958

TRACE-INFO: 28: [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=110ad1160,srvhp=110ad2460)

TRACE-INFO: 29: 27 0.158985

TRACE-INFO: 30: [dev trc ,00000] Deallocating server context handle 110ad2460 407 0.159392

TRACE-INFO: 31: [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705' 38 0.159430

TRACE-INFO: 32: [dev trc ,00000] set_ocica() -> OCI or SQL return code 12705 18 0.159448

TRACE-INFO: 33: [dev trc ,00000] Try to connect with default password 24 0.159472

TRACE-INFO: 34: [dev trc ,00000] Connecting as SAPL47/<pwd>@L47 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

TRACE-INFO: 35: 30 0.159502

TRACE-INFO: 36: [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

TRACE-INFO: 37: 30 0.159532

TRACE-INFO: 38: [dev trc ,00000] 0 US7ASCII 1 110ac8748 110ad1c80 110ad1530

TRACE-INFO: 39: 30 0.159562

TRACE-INFO: 40: [dev trc ,00000] Allocating server context handle 17 0.159579

TRACE-INFO: 41: [dev trc ,00000] Attaching to DB Server L47 (con_hdl=0,svchp=110ad1160,srvhp=110ad2460)

TRACE-INFO: 42: 90 0.159669

TRACE-INFO: 43: [dev trc ,00000] Assigning server context 110ad2460 to service context 110ad1160

TRACE-INFO: 44: 99633 0.259302

TRACE-INFO: 45: [dev trc ,00000] Assigning username to user session 110ad0568 25 0.259327

TRACE-INFO: 46: [dev trc ,00000] Assigning password to user session 110ad0568 43 0.259370

TRACE-INFO: 47: [dev trc ,00000] Starting user session (con_hdl=0,svchp=110ad1160,srvhp=110ad2460,usrhp=110ad0568)

TRACE-INFO: 48: 30 0.259400

TRACE-INFO: 49: [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=12705

TRACE-INFO: 50: 17122 0.276522

TRACE-INFO: 51: [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=110ad2460) 19 0.276541

TRACE-INFO: 52: [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=110ad1160,srvhp=110ad2460)

TRACE-INFO: 53: 26 0.276567

TRACE-INFO: 54: [dev trc ,00000] Deallocating server context handle 110ad2460 321 0.276888

TRACE-INFO: 55: [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705' 30 0.276918

TRACE-INFO: 56: [dev trc ,00000] set_ocica() -> OCI or SQL return code 12705 18 0.276936

TRACE-INFO: 57: [dblink ,00431] ***LOG BY2=>sql error 12705 performing CON [dblink#5 @ 431]

TRACE-INFO: 58: 119 0.277055

TRACE-INFO: 59: [dblink ,00431] ***LOG BY0=>ORA-12705: invalid or unknown NLS parameter value specified [dblink#5 @ 431]

TRACE-INFO: 60: 27 0.277082

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0232

tp finished with return code: 232

meaning:

connect failed

Process with ID 626888 terminated with status 232

[Former Member]

Hi Myung-Ho Cha,

Check below note for the solution.

Note 592657 - ORA-12701/ORA-12705/ORA-12709

Regards

Ashok