cancel
Showing results for 
Search instead for 
Did you mean: 

Solman Upgrade error in PREPARE Phase II

Former Member
0 Kudos

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>

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Depending on OS, check SHLIB_PATH and/or LD_LIBRARY_PATH

also check ORA_NLS33 path

Check this SAP Note :836517

Thanks

Kalyan

Former Member
0 Kudos

Here I have on more doubt. Is it very important to have Oracle 10g in the prepare phase itself.

please confirm

Answers (4)

Answers (4)

Former Member
0 Kudos

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

Former Member
0 Kudos

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!.

Former Member
0 Kudos

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...

Former Member
0 Kudos

Hi,

You have got to have 3 env.. variables.

LD_LIBRARY_PATH

DISPLAY

JAVA_PATH=

Make sure you using these correct env.. variables..

Thanks,