Skip to Content
avatar image
Former Member

R3trans error

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 13, 2008 at 03:46 PM

    Hi

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

    Restart the Application including the Database

    Regards

    Shaji

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 12, 2007 at 10:37 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

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

  • avatar image
    Former Member
    Dec 12, 2007 at 02:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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