Question:
Dear all,
We have a SM 3.2 installed on Linux 32bit and running Oracle 10.2.
In the middle of the upgrade, I got an error about the SVERS table. It seems that the user SAPSM1SHD tries to read the table SAPSM1.SVERS, but there is no public view on this table.
The log I get in the file TPSQLSTD.OUT is showed below:
==============================================================================================
BLOCKED SIGNALS: ''
SAPup> Starting subprocess 15232 at 20070301130939
ENV <0x87ff260>: DIR_LIBRARY=/usr/sap/put/exe
ENV <0x87ff660>: LD_LIBRARY_PATH=/usr/sap/put/exe:/usr/lib/SunJava2-1.4.2/jre/lib/i386/client:/usr/lib/SunJava2-1.4.2/jre/lib/i386:/usr/lib/SunJava2-1.4.2/jre/../lib/i386:/usr/sap/SM1/SYS/exe/run:/oracle/SM1/102_32/lib:/oracle/client/10x_32/instantclient
ENV <0xbffffe57>: dbms_type=ORA
ENV <0xbffffe65>: dbs_ora_tnsname=SM1
ENV <0x87f7a60>: dbs_ora_schema=SAPSM1
ENV <0xbffffe8f>: ORACLE_PSRV=SM1
ENV <0xbffffe9f>: ORACLE_SID=SM1
ENV <0xbffffeb9>: ORACLE_HOME=/oracle/SM1/102_32
ENV <0xbffffed8>: ORACLE_BASE=/oracle
ENV <0xbffffeec>: ORA_NLS33=/oracle/client/92x_32/ocommon/nls/admin/data
ENV <0xbfffff23>: NLS_LANG=AMERICAN_AMERICA.WE8DEC
ENV <0x87f7e60>: auth_shadow_upgrade=1
EXECUTING /usr/sap/put/exe/tp (tp) pf=/usr/sap/put/bin/EXDBNEW.TPP execdbscript SM1 -x ALORDC.XQL
This is /usr/sap/put/exe/tp version 370.00.09 (release 700)
ERROR: Connect to SM1 failed (20070301130939), failed to read table SVERS.
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.
TRACE-INFO: 1: [dev trc ,00000] Thu Mar 1 13:09:39 2007 13972 0.013972
TRACE-INFO: 2: [dev trc ,00000] load shared library (/usr/sap/put/exe/dboraslib.so), hdl 0
TRACE-INFO: 3: 10 0.013982
TRACE-INFO: 4: [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 353 0.014335
TRACE-INFO: 5: [dev trc ,00000] -->oci_initialize (con_hdl=0) 11 0.014346
TRACE-INFO: 6: [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 3422 0.017768
TRACE-INFO: 7: [dev trc ,00000] Logon as OPS$-user to get SAPSM1SHD's password 22 0.017790
TRACE-INFO: 8: [dev trc ,00000] Connecting as /@SM1 on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
TRACE-INFO: 9: 11 0.017801
TRACE-INFO: 10: [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
TRACE-INFO: 11: 16 0.017817
TRACE-INFO: 12: [dev trc ,00000] 0 WE8DEC 1 0x8b15f60 0x8b1b5ec 0x8b1ae74
TRACE-INFO: 13: 10 0.017827
TRACE-INFO: 14: [dev trc ,00000] Allocating service context handle for con_hdl=0 18 0.017845
TRACE-INFO: 15: [dev trc ,00000] Allocating server context handle 11 0.017856
TRACE-INFO: 16: [dev trc ,00000] Attaching to DB Server SM1 (con_hdl=0,svchp=0x8b1ae00,svrhp=0x8b1f89c)
TRACE-INFO: 17: 41 0.017897
TRACE-INFO: 18: [dev trc ,00000] Assigning server context 0x8b1f89c to service context 0x8b1ae00
TRACE-INFO: 19: 31507 0.049404
TRACE-INFO: 20: [dev trc ,00000] Allocating user session handle 45 0.049449
TRACE-INFO: 21: [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x8b1ae00,srvhp=0x8b1f89c,usrhp=0x8b44954)
TRACE-INFO: 22: 42 0.049491
TRACE-INFO: 23: [dev trc ,00000] Assigning user session 0x8b44954 to service context 0x8b1ae00
TRACE-INFO: 24: 12330 0.061821
TRACE-INFO: 25: [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;
TRACE-INFO: 26: 59 0.061880
TRACE-INFO: 27: [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;
TRACE-INFO: 28: 133 0.062013
TRACE-INFO: 29: [dev trc ,00000] Now '/@SM1' is connected (con_hdl 0, nls_hdl 0). 1134 0.063147
TRACE-INFO: 30: [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY
TRACE-INFO: 31: 29 0.063176
TRACE-INFO: 32: [dev trc ,00000] SELECT USERID, PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)
TRACE-INFO: 33: 467 0.063643
TRACE-INFO: 34: [dev trc ,00000] Got SAPSM1SHD's password from OPS$-user 1028 0.064671
TRACE-INFO: 35: [dev trc ,00000] Disconnecting from connection 0 ... 9 0.064680
TRACE-INFO: 36: [dev trc ,00000] Rolling back transaction ... 19 0.064699
TRACE-INFO: 37: [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x8b1ae00,usrhp=0x8b44954)
TRACE-INFO: 38: 225 0.064924
TRACE-INFO: 39: [dev trc ,00000] Now I'm disconnected from ORACLE 818 0.065742
TRACE-INFO: 40: [dev trc ,00000] Connecting as SAPSM1SHD/<pwd>@SM1 on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
TRACE-INFO: 41: 14 0.065756
TRACE-INFO: 42: [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
TRACE-INFO: 43: 11 0.065767
TRACE-INFO: 44: [dev trc ,00000] 0 WE8DEC 1 0x8b15f60 0x8b1b5ec 0x8b1ae74
TRACE-INFO: 45: 10 0.065777
TRACE-INFO: 46: [dev trc ,00000] Assigning username to user session 0x8b44954 8 0.065785
TRACE-INFO: 47: [dev trc ,00000] Assigning password to user session 0x8b44954 18 0.065803
TRACE-INFO: 48: [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x8b1ae00,srvhp=0x8b1f89c,usrhp=0x8b44954)
TRACE-INFO: 49: 12 0.065815
TRACE-INFO: 50: [dev trc ,00000] Assigning user session 0x8b44954 to service context 0x8b1ae00
TRACE-INFO: 51: 4539 0.070354
TRACE-INFO: 52: [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;
TRACE-INFO: 53: 37 0.070391
TRACE-INFO: 54: [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;
TRACE-INFO: 55: 33 0.070424
TRACE-INFO: 56: [dev trc ,00000] Now 'SAPSM1SHD/<pwd>@SM1' is connected (con_hdl 0, nls_hdl 0).
TRACE-INFO: 57: 582 0.071006
TRACE-INFO: 58: [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY
TRACE-INFO: 59: 23 0.071029
TRACE-INFO: 60: [dev trc ,00000] SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER IN ('NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET') ORDER BY PARAM
TRACE-INFO: 61: 358 0.071387
TRACE-INFO: 62: [dev trc ,00000] ETER
TRACE-INFO: 63: 9 0.071396
TRACE-INFO: 64: [dev trc ,00000] Database NLS settings: AMERICAN_AMERICA.WE8DEC 582 0.071978
TRACE-INFO: 65: [dev trc ,00000] SELECT UPPER(INSTANCE_NAME), HOST_NAME, VERSION, TO_CHAR (STARTUP_TIME, 'YYYYMMDD') FROM V$INSTANCE
TRACE-INFO: 66: 44 0.072022
TRACE-INFO: 67: [dev trc ,00000] Database instance SM1 is running on CHCHBE-S0217 with ORACLE version 10.2.0.2.0 since 20070220
TRACE-INFO: 68: 518 0.072540
TRACE-INFO: 69: [dev trc ,00000] SELECT SUBSTR(NAME, 1, 3), TO_CHAR (CREATED, 'YYYYMMDDHHMMSS') FROM V$DATABASE
TRACE-INFO: 70: 23 0.072563
TRACE-INFO: 71: [dev trc ,00000] SELECT VERSION FROM SVERS
TRACE-INFO: 72: 6128 0.078691
TRACE-INFO: 73: [dblink ,01299] ***LOG BZA=>table SVERS does not exist on database [dblink#3 @ 1299]
TRACE-INFO: 74: 1281 0.079972
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 15232 terminated with status 232
==============================================================================================
I'm stooped in the phase SQLSCREXE_SEQ. And cannot go back to phase SCEXEC_GRANT as recommende by SAP, because I don't have the necessary password for that.
Have any of you had the same problem as me?
Thanks for your attention,
Ernaldo
_________________
=======================
Ernaldo Cezar
Novartis Consumer Health
Answer:
have you search SAP notes and Googled with proper keywords:
you will find:
http://sap.ittoolbox.com/groups/technical-functional/sap-basis/table-svers-does-not-exist-on-database-629567
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Search: /forums/search.php
SAP Notes: http://service.sap.com/notes
SAP Help: http://help.sap.com
Basic Rules: /forums/viewtopic.php?t=222759
Answer:
HI i have exactly the same problem upgrading from BW 3.5 to SAP BW 7.00 (Kernel 700 too) & Nw2004s.
Have you resolve the problem?
thanks in advance
Answer:
Hi again:
Did you change the database host before perfom the upgrade process?
Regards.