on 10-15-2007 1:21 PM
Hi,
I am upgrading the solution manager to 4.0 in the windows-oracle environment.
I am getting the following error in the phase "PR_DBPAR"(PREPARE-INITIALIZATION)
<i>"Error: During execution of script 'SQLDBSCRIPT.TQL'.
Error found in logfile or standard output file.
Check log files 'TPSQLSTD.OUT' and 'SQLDBSCRIPT.OUT' "</i>
<u><b>The output of 'TPSQLSTD.OUT' </b></u>
<i>SAPup> Starting subprocess tp.exe with id 3664 at 20071015171207
EXECUTING D:\usr\sap\put\exe\tp.exe pf=D:\usr\sap\put\bin\DEFAULT.TPP execdbscript SMS -x SQLDBSCRIPT.TQL
Environment: dbs_ora_schema=SAPSMS
Environment: dbs_ora_tnsname=SMS
Environment: NLS_LANG=AMERICAN_AMERICA.UTF8
Environment: ORACLE_HOME=D:\oracle\ora92
Environment: ORACLE_SID=SMS
This is D:\usr\sap\put\exe\tp.exe version 372.03.35 (release 700, unicode enabled)
Process with ID 1320 terminated with status -1066598273</i>
<u><b>Shared_Pool.Log</b></u>
<i>1 ETQ201XEntering upgrade-phase "PR_DBPAR" ("20071015171207")
2 ETQ367 Connect variables are set for standard instance access
4 ETQ399 System-nr = '00', GwService = 'sapgw00'
4 ETQ399 Environment variables:
4 ETQ399 dbs_ora_schema=SAPSMS
4 ETQ399 auth_shadow_upgrade=0
4 ETQ399 Requested task ID is 'SHARED_POOL'.
4 ETQ399 Generating file 'SQLDBSCRIPT.TQL'.
4 ETQ399 Task ID is: 'SHARED_POOL'.
4 ETQ399 Validating file 'SQLDBSCRIPT.TQL'...
4 ETQ380 computing toolpath for request "TP_EXECDBSCRIPT_NEW"
4 ETQ381 request "TP_EXECDBSCRIPT_NEW" means "execdbscript with 46A feature"
4 ETQ382 translates to group "R3UP_TOOL_GROUP_NEW"
4 ETQ383 translates to path "exe"
4 ETQ383 translates to path "exe"
4 ETQ276 Executing SQL-script "SQLDBSCRIPT.TQL"
2EETQ278 Errors during execution of SQL-script "SQLDBSCRIPT.TQL"
1EETQ204 Upgrade phase "PR_DBPAR" aborted with severe errors ("20071015171210")</i>
<u><b>PRDBPAR.LOG</b></u>
<i>1 ETQ201XEntering upgrade-phase "PR_DBPAR" ("20071015171207")
2 ETQ367 Connect variables are set for standard instance access
4 ETQ399 System-nr = '00', GwService = 'sapgw00'
4 ETQ399 Environment variables:
4 ETQ399 dbs_ora_schema=SAPSMS
4 ETQ399 auth_shadow_upgrade=0</i>
Depending on OS, check SHLIB_PATH and/or LD_LIBRARY_PATH
also check ORA_NLS33 path
Check this SAP Note :836517
Thanks
Kalyan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I also getting the same erro but I upgrading solution manager 3.2 to 4.
Have solved the problem.
Can you help me to solve this proble
Regards
K Balram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check this variables, I used this ones!, as you are upgrading to ECC6 you need the client for 10x_64 in case of 64 bits
Whatch out for <SID>
LIBPATH=/usr/lib:/lib:/usr/sap/<SID>/SYS/exe/run:/oracle/client/10x_64/instantclient
DIR_LIBRARY=/usr/sap/<SID>/SYS/exe/run "OR" /usr/sap/put/exe can't remember wich!
dbms_type=ORA
regards,
Daniel!.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I've got the same abort on AIX 5.3 / Oracle 10g !!
<u><b>The output of 'TPSQLSTD.OUT' </b></u>
SAPup> Starting subprocess 1597472 at 20071029160832
ENV <0x20163480>: DIR_LIBRARY=/usr/sap/put/exe
ENV <0x2ff22d11>: dbms_type=ORA
ENV <0x2ff22d1f>: dbs_ora_tnsname=P93
ENV <0x20138290>: dbs_ora_schema=SAPE91
ENV <0x2ff22d49>: ORACLE_PSRV=P93
ENV <0x2ff22d59>: ORACLE_SID=P93
ENV <0x2ff22d73>: ORACLE_HOME=/oracle/P93/102_64
ENV <0x2ff22d92>: ORACLE_BASE=/oracle
ENV <0x2ff22da6>: ORA_NLS33=/oracle/client/9207/ocommon/nls/admin/data
ENV <0x2ff22ddb>: NLS_LANG=AMERICAN_AMERICA.WE8DEC
ENV <0x20164764>: LIBPATH=/usr/sap/put/exe:/usr/sap/P93/SYS/exe/run:/oracle/client/9207/lib
ENV <0x20137e90>: auth_shadow_upgrade=0
EXECUTING /usr/sap/put/exe/tp (tp) pf=/usr/sap/put/bin/DEFAULT.TPP execdbscript P93 -x SQLDBSCRIPT.TQL
This is /usr/sap/put/exe/tp version 370.00.09 (release 700)
ERROR: <b>No connect due to DbSl Load Lib Failure</b>
ERROR: The values set for DIR_LIBRARY ('/usr/sap/put/exe') or dbms_type ('ORA') are invalid.
ERROR: Connect to P93 failed (20071029160833).
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] Mon Oct 29 16:08:33 2007 3194 0.003194
TRACE-INFO: 2: [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= 0509-130 Symbol resolution failed for /usr/sap/put/exe/dboraslib.o
because:
TRACE-INFO: 3: 0509-136 <b>Symbol OCIClientVersion (number 87) is not exported from
TRACE-INFO: 4: dependent module /oracle/client/92x_64/lib/libclntsh.a[shr.o].</b>
TRACE-INFO: 5: 0509-022 Cannot load module /usr/sap/put/exe/dboraslib.o.
TRACE-INFO: 6: 0509-026 System error: Cannot run a file that does not have a valid format.
TRACE-INFO: 7: 0509-192 Examine .loader section symbols with the 22 0.003216
TRACE-INFO: 8: 'dump -Tv' command. -> DLENOACCESS (8,Exec format error)
tp returncode summary:
TOOLS: Highest return code of single steps was: 0
ERRORS: Highest tp internal error was: 0249
tp finished with return code: 249
meaning:
connect failed due to DbSL load lib failure
Process with ID 1597472 terminated with status 249
____________________________________________________
<b><u>Environment of sidadm:</u></b>
TERM=xterm
AUTHSTATE=LDAP
SHELL=/bin/csh
HOME=/home/p93adm
USER=p93adm
PATH=/oracle/P93/102_64/bin:/home/p93adm:/usr/sap/P93/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/p93adm/bin:/usr/bin/X11:/sbin:.
TZ=NFT-1DFT,M3.5.0,M10.5.0
LANG=en_US
LOCPATH=/usr/lib/nls/loc
LC__FASTMSG=true
ODMDIR=/etc/objrepos
LC_MESSAGES=en_US
LOGNAME=p93adm
LOGIN=p93adm
SAPSYSTEMNAME=P93
DIR_LIBRARY=/usr/sap/P93/SYS/exe/run
THREAD=NOPS
dbms_type=ORA
dbs_ora_tnsname=P93
dbs_ora_schema=SAPE91
ORACLE_PSRV=P93
ORACLE_SID=P93
DB_SID=P93
ORACLE_HOME=/oracle/P93/102_64
ORACLE_BASE=/oracle
ORA_NLS33=/oracle/client/9207/ocommon/nls/admin/data
NLS_LANG=AMERICAN_AMERICA.WE8DEC
SAPDATA_HOME=/oracle/P93
DBS_LIBPATH_EXT=/oracle/client/10x_64/instantclient
MAIL=/var/spool/mail/p93adm
MAILMSG=[YOU HAVE NEW MAIL]
LIBPATH=/usr/sap/P93/SYS/exe/run:/oracle/client/9207/lib
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/en_US/%N:/usr/lib/nls/msg/%L/%N.cat:/usr/lib/nls/msg/en_US/%N.cat
_______________________________________
<u>There are 3 Oracle clients installed:</u>
<b>9204_64</b> for another SAP-system on the same Server (the link 92x_64 references to this directory).
<b>9207</b> for the 640-system before the upgrade.
<b>10x_64</b> for the upgrade to 700 (DBS_LIBPATH_EXT points at the instantclient)
The problem is: I don't know why TPSQLSTD.OUT references on file /oracle/client/92x_64/lib/libclntsh.a although the environment is set to 9207 respectively 102_64 ?!
I already send a message to SAP yesterday....no answer until now...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You have got to have 3 env.. variables.
LD_LIBRARY_PATH
DISPLAY
JAVA_PATH=
Make sure you using these correct env.. variables..
Thanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.