on 01-30-2007 11:56 AM
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
I also got the same some error . My solution is update the kernal for solving this problem.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sachin,
I believed 4.6c is not released with Kernel 620? (SN 156548).
(OS : SOLARIS 10 SPARC 64b, DB Oracle 9.2.0.7). If I'm wrong, could you send me to a note or something which could hemp me out with this upgrade.
By the way, I tried to use the 4.6D tp for executing the script, it works but of course a mismatch appears when it tries to load the libraries.
Best regards
You need to upgrade to the 46D_EXT kernel.
Vicki
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes, updating kernel would solve the problem.
tx
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
104 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.