MAIN_SWITCH/SQLDB_BAS_TCP

[Former Member]

Hi Friends,

I am stuck in the following phase

MAIN_SWITCH/SQLDB_BAS_TCP

Last error code set: Process 'tp' exited with 255, see /upgrade/../../TPSQLSTD.OUT' for details

File TPSQLSTD.OUT' details

BLOCKED SIGNALS: ''

SAPehpi> Starting subprocess 21451 at 20090907160041

ENV: DIR_LIBRARY=/usr/sap/SMD/DVEBMGS34/exe

ENV: JAVA_HOME=/opt/java1.4

ENV: LD_LIBRARY_PATH=/usr/sap/SMD/DVEBMGS34/exe/upgrade/jvm/jre/lib/ia64/server/upgrade/jvm/jre/lib/ia64/upgrade/jvm/jre/../lib/ia64

ENV: NLS_LANG=AMERICAN_AMERICA.UTF8

ENV: ORACLE_BASE=/oracle

ENV: ORACLE_HOME=/oracle/SMD/102_64

ENV: ORACLE_SID=SMD

ENV: PATH=/usr/sap/SMD/DVEBMGS34/exe:/oracle/SMD/102_64/bin:/opt/java1.4/bin:.:/home/SMDadm:/usr/sap/SMD/SYS/exe/run:/bin:/usr/bin:/usr/dt/bin:/usr/bin/X11:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/ipf/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/fcms/bin:/opt/sas/bin:/opt/resmon/bin:/opt/perf/bin:/usr/contrib/kwdb/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/graphics/common/bin:/opt/prm/bin:/opt/sfm/bin:/opt/upgrade/bin:/opt/wlm/bin:/opt/sec_mgmt/bastille/bin:/opt/dsau/bin:/opt/dsau/sbin:/opt/firefox:/opt/gnome/bin:/opt/ignite/bin:/opt/mozilla:/opt/perl/bin:/opt/sec_mgmt/spc/bin:/opt/ssh/bin:/opt/hpsmh/bin:/opt/thunderbird:/opt/gwlm/bin:/usr/contrib/bin/X11:/usr/local/bin/:/opt/super/bin:/opt/pwplus/bin

ENV: SAPSYSTEMNAME=SMD

ENV: auth_shadow_upgrade=0

ENV: dbms_type=ORA

ENV: dbs_ora_schema=SAPSR3

ENV: dbs_ora_tnsname=SMD

EXECUTING /usr/sap/SMD/DVEBMGS34/exe/tp (tp) pf=/upgrade/abap/bin/DEFAULT.TPP execdbscript SMD -x SQLDBSCRIPT.TQL

Could not open the ICU common library.

The following files must be in the path described by

the environment variable "LD_LIBRARY_PATH":

libicuuc.sl.30, libicudata.sl.30, libicui18n.sl.30 [nlsui0.c 1485] pid = 21451

Process with ID 21451 terminated with status 255

Thanks

kris

[Former Member]

Hi ,

The following files must be in the path described by
the environment variable "LD_LIBRARY_PATH":
libicuuc.sl.30, libicudata.sl.30, libicui18n.sl.30 http://nlsui0.c 1485 pid = 21451
Process with ID 21451 terminated with status 255

Check the LD_LIBRARY_PATH where it is pointing to.At this location as its says in log files libicuuc.sl.30, libicudata.sl.30, libicui18n.sl.30 missing.So check if these files exists & if not copy these files at this location & continue.

Thanks..

Mohit

[Former Member]

Hi ,

When i have done Env i got the following

SHLIB_PATH=/usr/sap/SMD/SYS/exe/run:/oracle/client/10x_64/instantclient

Ours is a hpux cshell and i have checked the exe and the run directory the lib* files are already existing.

Can you please help me what i have to do..

thnaks

[Former Member]

ENV: LD_LIBRARY_PATH=/usr/sap/SMD/DVEBMGS34/exe/upgrade/jvm/jre/lib/ia64/server/upgrade/jvm/jre/lib/ia64/upgrade/jvm/jre/../lib/ia64

I guess it is searching for library at this location as given in your log.Check the files at this locaion & copy files from /usr/sap/SMD/SYS/exe/run to specified location.

Also please have a look on these follwoing notes ::

SAP Note 519753 - Problems with ICU shared libraries.

Thanks..

Mohit

Edited by: mohit gupta on Sep 8, 2009 11:02 AM

[Former Member]

Tried the note but still didn't help. we have copied all the files to the path specified in LD_LIBRARY_PATH but still the same.

In the File TPSQLSTD.OUT' details

BLOCKED SIGNALS: ''

SAPehpi> Starting subprocess 21451 at 20090907160041

ENV: DIR_LIBRARY=/usr/sap/SMD/DVEBMGS34/exe

ENV: JAVA_HOME=/opt/java1.4

ENV: LD_LIBRARY_PATH=/usr/sap/SMD/DVEBMGS34/exe/upgrade/jvm/jre/lib/ia64/server/upgrade/jvm/jre/lib/ia64/upgrade/jvm/jre/../lib/ia64

ENV: NLS_LANG=AMERICAN_AMERICA.UTF8

ENV: ORACLE_BASE=/oracle

ENV: ORACLE_HOME=/oracle/SMD/102_64

ENV: ORACLE_SID=SMD

ENV: PATH=/usr/sap/SMD/DVEBMGS34/exe:/oracle/SMD/102_64/bin:/opt/java1.4/bin:.:/home/SMDadm:/usr/sap/SMD/SYS/exe/run:/bin:/usr/bin:/usr/dt/bin:/usr/bin/X11:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/ipf/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/fcms/bin:/opt/sas/bin:/opt/resmon/bin:/opt/perf/bin:/usr/contrib/kwdb/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/graphics/common/bin:/opt/prm/bin:/opt/sfm/bin:/opt/upgrade/bin:/opt/wlm/bin

ENV: SAPSYSTEMNAME=SMD

ENV: auth_shadow_upgrade=0

ENV: dbms_type=ORA

ENV: dbs_ora_schema=SAPSR3

ENV: dbs_ora_tnsname=SMD

EXECUTING /usr/sap/SMD/DVEBMGS34/exe/tp (tp) pf=/upgrade/abap/bin/DEFAULT.TPP execdbscript SMD -x SQLDBSCRIPT.TQL

Could not open the ICU common library.

The following files must be in the path described by

the environment variable "LD_LIBRARY_PATH":

libicuuc.sl.30, libicudata.sl.30, libicui18n.sl.30 http://nlsui0.c

Process with ID 21451 terminated with status 255

In the above log there is LD_LIBRARY_PATH=/usr/sap/SMD/DVEBMGS34/exe/upgrade/jvm/jre/lib/ia64/server/upgrade/jvm/jre/lib/ia64/upgrade/jvm/jre/../lib/ia64

in this line there /../ actually when i verified the in the directory it should be upgrade/jvm/jre/lib/ia64/upgrade/jvm/jre/lib/ia64, that may be the reason for error, how can i set this environment path in cshell.

thanks

kris

[former_member204746]

change LD_LIBRARY_PATH to a valid directory and try again.

[Former Member]

I have done that but still the same issue.

When i run the R3trans -d i get the following error

<host> R3trans -d

Could not open the ICU common library.

The following files must be in the path described by

the environment variable "LD_LIBRARY_PATH":

libicuuc.sl.30, libicudata.sl.30, libicui18n.sl.30 [nlsui0.c 1485]

trans.log

4 ETW000 R3trans version 6.14 (release 701 - 17.11.08 - 18:00:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 0.09.2009 -

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Tue Sep 15:45:56 2009 1453 0.001453

4 ETW000 [dev trc ,00000] db_con_init called 0.002668

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 1026 0.003694

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/SMD/SYS/exe/run/dboraslib.sl' ...

4 ETW000 1635 0.005329

4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= Unable to find library 'libclntsh.sl.10.1'. -> DLENOACCESS (0,Error 0)

4 ETW000 8739 0.014068

4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/SMD/SYS/exe/run/dboraslib.sl'

4 ETW000 3384 0.017452

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/SMD/SYS/exe/run') or dbms_type ('ORA')"

Can some one help me please.

thanks

[Former Member]

Hi ,

Please have a look at this note as this seems very near to your case.:::

Note 716378 - Missing libraries during Unicode upgrade.

Hope this will solve your issue.

Thanks..

Mohit

[Former Member]

Resolved this by copying the lib file from the other box and setting enviroment.

thnaks