Skip to Content
0
Former Member
Jan 30, 2007 at 11:56 AM

Upgrade 46c --> ECC 6.0 : PREPARE : Urgent issue

29 Views

Hi Again,

We are actually upgrading to an ECC 6.0 with an Oracle database 9.2.0.7. Even if the Kernel 7 support only a Oracle 10.g, we have benn ensured that the PREPARE phase could be done without upgrading the database.

During the PREPARE phase 2 and more specificly the sub phase PR_DBPAR, we have firstly an error :

When it try to open the dboraslib.so in the UPG_DIR/exe, it couldn't find some libraries (libclntsh.so.10.1 and libnnz10.so).

We first upgrade R3up as it was asked by SAP but it doesn't work.

Then we install an 10.g instant. Automatically, the two libraries were found but another problem appears. I'm reading notes and threads since 18 hours, try most of the recommandations but still no solution.

Here is the log :

<i>BLOCKED SIGNALS: ''

SAPup> Starting subprocess 19191 at 20070130114940

ENV <0x87dd3c>: DIR_LIBRARY=/sapmnt/QAS/prep/exe

ENV <0x87e13c>: LD_LIBRARY_PATH=/sapmnt/QAS/prep/exe:/usr/j2se/jre/lib/sparc/client:/usr/j2se/jre/lib/sparc:/usr/j2se/jre/../lib/sparc:/usr/sap/QAS/SYS/exe/run

ENV <0xffbffe13>: dbms_type=ORA

ENV <0xffbffe21>: dbs_ora_tnsname=QAS

ENV <0x877a54>: dbs_ora_schema=SAPR3

ENV <0xffbffe4a>: ORACLE_PSRV=QAS

ENV <0xffbffe5a>: ORACLE_SID=QAS

ENV <0xffbffe69>: ORACLE_HOME=/oracle/QAS/920_64

ENV <0xffbffe88>: ORACLE_BASE=/oracle

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

ENV <0xffbffed3>: NLS_LANG=AMERICAN_AMERICA.WE8DEC

ENV <0x877654>: auth_shadow_upgrade=0

EXECUTING /sapmnt/QAS/prep/exe/tp (tp) pf=/sapmnt/QAS/prep/bin/DEFAULT.TPP execdbscript QAS -x SQLDBSCRIPT.TQL

This is /sapmnt/QAS/prep/exe/tp version 370.00.09 (release 700)

ERROR: Connect to QAS failed (20070130114941, 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 DBNAME is no longer used.

Warning: Parameter DBHOST 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] Tue Jan 30 11:49:40 2007 67194 0.067194

TRACE-INFO: 2: [dev trc ,00000] load shared library (/sapmnt/QAS/prep/exe/dboraslib.so), hdl 0

TRACE-INFO: 3: 48 0.067242

TRACE-INFO: 4: [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 2068 0.069310

TRACE-INFO: 5: [dev trc ,00000] -->oci_initialize (con_hdl=0) 36 0.069346

TRACE-INFO: 6: [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII 10953 0.080299

TRACE-INFO: 7: [dev trc ,00000] Logon as OPS$-user to get SAPR3's password 75 0.080374

TRACE-INFO: 8: [dev trc ,00000] Connecting as /@QAS on connection 0 (nls_hdl 0) ... (dbsl 700 250806)

TRACE-INFO: 9: 42 0.080416

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

TRACE-INFO: 11: 60 0.080476

TRACE-INFO: 12: [dev trc ,00000] 0 US7ASCII 1 1015052b8 10150cd38 10150e530

TRACE-INFO: 13: 27 0.080503

TRACE-INFO: 14: [dev trc ,00000] Allocating service context handle for con_hdl=0 85 0.080588

TRACE-INFO: 15: [dev trc ,00000] Allocating server context handle 28 0.080616

TRACE-INFO: 16: [dev trc ,00000] Attaching to DB Server QAS (con_hdl=0,svchp=10150e460,svrhp=10150ecb0)

TRACE-INFO: 17: 177 0.080793

TRACE-INFO: 18: [dev trc ,00000] Assigning server context 10150ecb0 to service context 10150e460

TRACE-INFO: 19: 62730 0.143523

TRACE-INFO: 20: [dev trc ,00000] Allocating user session handle 123 0.143646

TRACE-INFO: 21: [dev trc ,00000] Starting user session (con_hdl=0,svchp=10150e460,srvhp=10150ecb0,usrhp=10150d550)

TRACE-INFO: 22: 56 0.143702

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

TRACE-INFO: 24: 11615 0.155317

TRACE-INFO: 25: [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=10150ecb0) 29 0.155346

TRACE-INFO: 26: [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=10150e460,srvhp=10150ecb0)

TRACE-INFO: 27: 24 0.155370

TRACE-INFO: 28: [dev trc ,00000] Deallocating server context handle 10150ecb0 1012 0.156382

TRACE-INFO: 29: [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705' 121 0.156503

TRACE-INFO: 30: [dev trc ,00000] Try to connect with default password 81 0.156584

TRACE-INFO: 31: [dev trc ,00000] Connecting as SAPR3/<pwd>@QAS on connection 0 (nls_hdl 0) ... (dbsl 700 250806)

TRACE-INFO: 32: 44 0.156628

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

TRACE-INFO: 34: 26 0.156654

TRACE-INFO: 35: [dev trc ,00000] 0 US7ASCII 1 1015052b8 10150cd38 10150e530

TRACE-INFO: 36: 25 0.156679

TRACE-INFO: 37: [dev trc ,00000] Allocating server context handle 19 0.156698

TRACE-INFO: 38: [dev trc ,00000] Attaching to DB Server QAS (con_hdl=0,svchp=10150e460,svrhp=10150ecb0)

TRACE-INFO: 39: 66 0.156764

TRACE-INFO: 40: [dev trc ,00000] Tue Jan 30 11:49:41 2007 52890 0.209654

TRACE-INFO: 41: [dev trc ,00000] Assigning server context 10150ecb0 to service context 10150e460

TRACE-INFO: 42: 25 0.209679

TRACE-INFO: 43: [dev trc ,00000] Assigning username to user session 10150d550 29 0.209708

TRACE-INFO: 44: [dev trc ,00000] Assigning password to user session 10150d550 102 0.209810

TRACE-INFO: 45: [dev trc ,00000] Starting user session (con_hdl=0,svchp=10150e460,srvhp=10150ecb0,usrhp=10150d550)

TRACE-INFO: 46: 30 0.209840

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

TRACE-INFO: 48: 19535 0.229375

TRACE-INFO: 49: [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=10150ecb0) 23 0.229398

TRACE-INFO: 50: [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=10150e460,srvhp=10150ecb0)

TRACE-INFO: 51: 23 0.229421

TRACE-INFO: 52: [dev trc ,00000] Deallocating server context handle 10150ecb0 556 0.229977

TRACE-INFO: 53: [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705' 37 0.230014

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

TRACE-INFO: 55: 303 0.230317

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

TRACE-INFO: 57: 25 0.230342

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 19191 terminated with status 232</i>

Thanks by advance for your help

Other Key words : ORA_NLS33, ORA-12705, TPSQLTD.OUT