R3trans error

[Former Member]

Hi

iam getting this error when i do an R3rans -x command:

twm1:wm1adm 84> more trans.log

4 ETW000 R3trans version 6.14 (release 700 - 10.07.07 - 13:48:00).

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

4 ETW000

4 ETW000 date&time : 12.12.2006 - 11:01:19

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 Dec 12 11:01:19 2006

116 0.000116

4 ETW000 [dev trc ,00000] db_con_init called

25 0.000141

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

49 0.000190

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/put/exe/dbsdbslib.s

o' ...

4 ETW000 55 0.000245

4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= libSQLDBC76.so: cannot open shared object file: No such file or directory -> DLENOACCESS (0,Success)

4 ETW000 493 0.000738

4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/put

/exe/dbsdbslib.so'

4 ETW000 37 0.000775

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/put/exe') or dbms_type ('ADA')"

So have checked the library dbsdbslib.so' its there in that directory.I also looked for libSQLDBC76.so and its in /sapdb/programs/lib.

i have set the DIR_LIBRARY to where dbsdbslib.so' is.

DB_SID=WM1

dbms_type=ADA

LD_ASSUME_KERNEL=2.4.21

SECUDIR=/usr/sap/saprouter

SNC_LIB=/usr/sap/saprouter/linux-glibc2.2.2/libsapcrypto.so

DIR_LIBRARY=/usr/sap/put/exe

so what i dont know is ,are they supposed to be in the same directory(dbsdbslib.so' and libSQLDBC76.so )and what kind of permissions should they have.

iam running SUSE Linux Enterprise 9.1 maxdb 7.6 (upgraded from 7.4.to.7.5 to 76 ),upgrading from 4.7 to ECC6.

any ideas welcome

[Former Member · Accepted solution]

Hi

Rename the library file and download a new library file as per the Kernel version.

Restart the Application including the Database

Regards

Shaji

[Former Member]

Hi Mudzingwa Wilson ,

1. hostname

hostname

**********************************************************

1. hostname -f

hostname.abc.com

***********************************************************

1. sestatus

SELinux status: disabled

If selinux is not disable please disable it or else use your own secutiry policy

**********************************************************

1. cat /etc/hosts

2. Do not remove the following line, or various programs

3. that require network functionality will fail.

127.0.0.1 localhost.localdomain localhost

::1 localhost6.localdomain6 localhost

172.17.1.198 hostname.abc.com hostname

*************************************************************

rpm -ivh IBMJava2-AMD64-142-SDK-1.4.2-9.0.x86_64.rpm

cp unrestrict142.zip /opt/IBMJava2-amd64-142/lib/

*******************************************************

copy below in ~/.bash_profile

JAVA_HOME=/opt/IBMJava2-amd64-142 export JAVA_HOME

#JAVA_PATH=/opt/IBMJava2-amd64-142 export JAVA_PATH

SAPINST_JRE_HOME=/opt/IBMJava2-amd64-142 export SAPINST_JRE_HOME

CPIC_MAX_CONV=500 export CPIC_MAX_CONV

***********************************************************************

In /etc/sysctl.conf Add the following parameters

#kernel.hostname = hostname.abc.com

#kernel.domainname = abc

kernel.shmmax = 23136829430

kernel.shmmni = 4096

kernel.shmseg = 4096

kernel.shmall = 3279547

kernel.shmmin = 1

kernel.sem = 1250 256000 100 1024

#Below are new entry

#kernel.semmsl = 700

#kernel.semmni = 200

#kernel.semmns = 15000

#kernel.semopm = 500

kernel.msgmni = 2878

kernel.msgmnb = 360000

vm.max_map_count = 300000

fs.file-max = 327679

net.ipv4.ip_local_port_range = 1024 65536

net.core.rmem_default=262144

net.core.wmem_default=262144

net.core.rmem_max=262144

net.core.wmem_max=262144

net.ipv4.tcp_wmem = 4096 65536 4194304

net.ipv4.tcp_rmem = 4096 87380 4194304

net.ipv4.tcp_syncookies = 1

#Increasing I/O Throughput at the Linux OS Level

#fs.aio-max-size = 214748364 changed on 08March2005

#fs.aio-max-size = 2097152

fs.aio-max-size = 1048576

#fs.aio-max-size = 131072

vm.hugetlb_pool=2256

******************************************************

/etc/security/limits.conf

Add the following parameters in limits.conf file

@sapsys soft noproc 32800

@sapsys hard noproc 32800

@sapsys hard nofile 32800

@sapsys soft nofile 32800

@dba soft noproc 32800

@dba hard noproc 32800

@dba soft nofile 32800

@dba hard nofile 32800

Thanks and Regards,

Kamal Kishore

[Former Member]

thanks for the note.

what i need is to fix the problem with env variable :

twm1:wm1adm 64> R3trans -x

This is R3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).

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

R3trans finished (0012).

i need to specify the env for sidam for R3trans to communicate with the database.eg cd /home/mt1adm

vi ..sapenv_twm1.csh

then add the entries.

i think iam making a mistake somewhere as it is not reading the env

[MichaelTe]

Hello,

here's what my machine tells me:

DIR_LIBRARY=/usr/sap/<sid>/SYS/exe/run

You'r doing an upgrade so your path with

DIR_LIBRARY=/usr/sap/put/exe

should be right.

But I doesn't have seen the environment variable

LD_LIBRARY_PATH

in your post?

It should be like this:

LD_LIBRARY_PATH=/opt/IBMJava2-amd64-142/jre/bin/j9vm:/opt/IBMJava2-amd64-142/jre/bin:/usr/sap/<sid>/SYS/exe/run:/sapdb/programs/lib

You should notice the end of the line '/sapdb/programs/lib'.

Set this variable and try again.

Also look at the rights. In my system they look like this:

-rwxr-xr-x  1 <sid>adm sapsys ... /usr/sap/<sid>/SYS/exe/run/dbsdbslib.so
-r-xr-xr-x  1 sdb sdba        ... /sapdb/programs/lib/libSQLDBC76.so

Regards, Michael

[Former Member]

Hi

havent won yet.some where somethinh is not right.I have set the Library path but still doesnt want to see it.its still looking at the wrong path.the rights and permissions for the libraries are ok

DIR_LIBRARY=/usr/sap/TWM/SYS/exe/run

JAVA_HOME=/opt/java1.4

LD_LIBRARY_PATH=/sapdb/programs/lib

DBENV_CSH=SET

DB_SID=WM1

dbms_type=ADA

LD_ASSUME_KERNEL=2.4.21

SECUDIR=/usr/sap/saprouter

SNC_LIB=/usr/sap/saprouter/linux-glibc2.2.2/libsapcrypto.so

twm1:wm1adm 85> R3trans -x

This is R3trans version 6.14 (release 700 - 10.07.07 - 13:48:00).

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

R3trans finished (0012)

could it be a java related problem?

t

wm1:wm1adm 86> java -version

java version "1.4.2"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2)

Classic VM (build 1.4.2, J2RE 1.4.2 IBM build cxia32142-20070708 (SR9) (JIT enabled: jitc))

[MichaelTe]

Hello,

in your first post you wrote:

4 ETW000 R3trans version 6.14 (release 700 - 10.07.07 - 13:48:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 12.12.2006 - 11:01:19

There seems to be something wrong with your date on the machine? 2006?

Why are you using:

LD_ASSUME_KERNEL=2.4.21

You have SLES 9 and a MaxDB 7.6, as far as I know you don't need this env variable.

I dont' know if this helps.

But please post your trans.log again after issuing R3trans -x

Regards, Michael

[Former Member]

This was an upgrade os from 8.1 to 9 and database from 7.4 to 7.5 to 7.6

[Former Member]

more trans.log

4 ETW000 R3trans version 6.14 (release 700 - 10.07.07 - 13:48:00).

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

4 ETW000

4 ETW000 date&time : 14.12.2007 - 12:51:58

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

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

4 ETW000 [dev trc ,00000] Fri Dec 14 12:51:58 2007

10462 0.010462

4 ETW000 [dev trc ,00000] db_con_init called

20 0.010482

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

44 0.010526

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/WM1/SYS/exe/run/dbs

dbslib.so' ...4 ETW00041 0.010567

4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= /usr/sap/WM1/SYS/exe/run/dbsdbslib.so: cannot open shared object file: No such file or directo

ry -> DLENOACCESS (0,Success)

4 ETW0004990 0.015557

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

4 ETW000 0.0155832EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/WM1/SYS/exe/run') or dbms_type ('ADA')"

[MichaelTe]

Hello,

another try:

ldd /usr/sap/WM1/SYS/exe/run/dbsdbslib.so

What does this say?

Regards, Michael

[Former Member]

hi

i checked it was missing in there.so copied it and its ok.But my problem is with R3trans when doing the prepare its complaining abt the version being old.After it gave me the error ,if i check its older that 21.06.06 (This is R3trans version 6.14 (release 700 - 19.06.07 - 16:20:42) and This is tp version 370.00.01 (release 700)for both exe and exenew

So now iam stuck but the requirements are there but still coming up with errors

[markus_doehr2]

You can't do an "R3trans -x" in the "exe" subdirectory during a PREPARE. This can't work because kernel 7.00 needs the dependent libraries in /usr/sap/put/exe which are not in your LD_LIBRARY_PATH and thus the system will complain. Additionally you can't simply add those to the path because then, the old 6.40 system won't work any more.

For that reason SAPup is setting a new environment for each call of R3trans and executing R3trans in that environment (not using the old one).

I did it the following way in the past:

- execute PREPARE

- run PREPARE until it complains, that your R3trans is too old

- replace R3trans and tp in /usr/sap/put/exe

- restart PREPARE

Any R3trans -x before the phase KX_SWITCH in the upgrade from the new kernel will fail - and this is intended.

--

Markus

[Former Member]

Hi,

according to sap note 817463

As of NW 2004s, the new MaxDB DBSL (dbsdbslib) and therefore the disp+work uses the Shared Library libSQLDBC76 of the MAXDB 7.6.00 client installation.

The shared library is loaded from the operating system,

which means that you have to set the relevant operating system-dependent system variables so that MaxDB DBSL can load the shared libraries.

Therefore, you must permanently enhance the following system variables in the user environment of <sid>adm:

SUN, DEC, SNI: LD_LIBRARY_PATH

HP : SHLIB_PATH

AIX: LIBPATH

with the path to the libSQLDBC76:

<INDEP_PROG_PATH>/lib[/lib64]

The system also checks whether the system variable is set correctly in PREPARE phase DBCHK_PRE..

regards,

kaushal

[Former Member]

Thanks for the note.

i tried that but no luck.May you give me the instructions on setting that up (the env)for sidadm at OS level.as i think there is somewhere iam doing it wrong.