Skip to Content
avatar image
Former Member

R3trans failed maybe someone set invalid values for DIR_LIBRARY

Hi All,

My OS is Solaris 10, I have upgrade the database 10.2 to 11.2 and the upgrade completed successfully. Then installed the oracle client 11.2 as per note 819829 and updated the new kernel 7.20 and changed the DB parameter and client parameters. these are the kernel files i updated in the following order

SAPEXE_300-20006802.SAR; SAPEXE_402-20006802.SAR; DBATL720O10_31-20005217.SAR; lib_dbsl_421-20005217.sar; tp_420-20005216.sar; dw_423-20005216.sar and run the script saproot.sh also. When check the R3trans -x it got failed and giving the error

R3trans -d

This is R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).

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

R3trans finished (0012).

Then i checked the BRconnect that is also failed.

brconnect: fatal: relocation error: file /oracle/client/10x_64/instantclient/libnnz10.so: symbol nzdacvalue: referenced symbol not found.

Dew_w0 log below

root@filqua # more dev_w0

---------------------------------------------------

trc file: "dev_w0", trc level: 1, release: "700"

---------------------------------------------------

*

* ACTIVE TRACE LEVEL 1

* ACTIVE TRACE COMPONENTS all, MJ

*

M sysno 00

M sid FQC

M systemid 370 (Solaris on SPARCV9 CPU)

M relno 7000

M patchlevel 0

M patchno 278

M intno 20050900

M make: single threaded, ASCII, 64 bit, optimized

M pid 3401

M

M

M Tue Apr 16 10:18:45 2013

M kernel runs with dp version 245(ext=110) (@(#) DPLIB-INT-VERSION-245)

M length of sys_adm_ext is 364 bytes

M ThInit: rdisp/cleanup_after_crash = 1

M ***LOG Q01=> ThInit, WPStart (Workproc 0 1 3401) [thxxhead.c 1344]

M ThInit: running on host filqua

M calling db_connect ...

B Loading DB library '/usr/sap/FQC/SYS/exe/run/dboraslib.so' ...

B

B Tue Apr 16 10:18:46 2013

B Library '/usr/sap/FQC/SYS/exe/run/dboraslib.so' loaded

B Version of '/usr/sap/FQC/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.290)

C Oracle Client Version: '10.2.0.2.0', (dbsl 700 150211, non-unicode)

C Application info callback registered.

C Client NLS setting (OCINlsGetInfo): con=0, 'AMERICAN_AMERICA.WE8DEC'

C Logon as OPS$-user to get SAPR3's password

C Connecting as /@FQC on connection 0 (nls 0) ... (dbsl 700 150211, non-unicode)

C Attaching to DB Server FQC (con_hdl=0,svchp=105de2068,srvhp=105de47b8)

C Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=105de2068, srvhp=105de47b8, usrhp=105ddefa8)

C CbApplInfoGet() failed (ignored 1).

C Connected to session 72.

C Now '/@FQC' is connected: con_hdl=0, nls_hdl=0, session_id=72.

C Got SAPR3's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=105de2068,usrhp=105ddefa8)

C Now I'm disconnected from ORACLE

C Connecting as SAPR3/<pwd>@FQC on connection 0 (nls 0) ... (dbsl 700 150211, non-unicode)

C Starting user session: OCISessionBegin(con_hdl=0, usr=SAPR3/<pwd>, svchp=105de2068, srvhp=105de47b8, usrhp=105ddefa8)

C Connected to session 72.

C Now 'SAPR3/<pwd>@FQC' is connected: con_hdl=0, nls_hdl=0, session_id=72.

C con=0, V$NLS_PARAMETERS: NLS_LANG=AMERICAN_AMERICA.WE8DEC, NLS_NCHAR_CHARACTERSET=AL16UTF16, UNI_NON=FALSE

C Nls CharacterSet (Env./V$NLS) NatioCharSet (Env./V$NLS) EnvHp ErrHp ErrBt

C 0 (WE8DEC) WE8DEC (AL16UTF16) AL16UTF16 105dd6cf0 105dde790 105de2138

C DB instance FQC is running on filqua with ORACLE version 10.2.0.2.0 since APR 16, 2013, 10:18:13

B Connection 0 opened (DBSL handle 0)

Can anyone help me to solve this issue.

Regards

Jose H.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • Apr 18, 2013 at 02:35 PM

    Hi Jose,

    There is nothing to do with DIR_LIBRARY environment variable.

    This is because of your client version compatibility with current OS patch set. Just compare the oslevel and it's ML/TL level with the system where it is working fine.

    It looks like, pre-requsites related to OS patch set were ignored while perorming oracle upgrade.

    solution is to change the path of oracle client and point it to earlier oracle client version till you get your OS patch upgraded to the recommended patch level.This is tested workaround.

    Do let me know if you still face same problem after changing client path ..

    Cheers !!!

    Ashish

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 17, 2013 at 09:20 AM

    hi jose,

    can you please post the trans.log

    and also double check the env

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

    LD_LIBRARY_PATH=/usr/sap/SID/SYS/exe/run:/oracle/client/11x_64/instantclient

    dbms_type=ORA

    dbs_ora_tnsname=SID

    dbs_ora_schema=SAPSR3

    ORACLE_SID=SID

    DB_SID=SID

    ORACLE_BASE=/oracle

    TNS_ADMIN=/usr/sap/SID/SYS/profile/oracle

    ORACLE_HOME=/oracle/SID/112_64

    best regards

    marius

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 17, 2013 at 09:35 AM

    Hi Jose,

    Refer SAP

    Note 1449619 - BR*Tools cannot be started on Oracle 11g

    Create the missing soft link manually using the user ora<sid>:

    > cd $ORACLE_HOME/lib

    > ln -s libnnz11.so libnnz10.so


    Hope this helps.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 18, 2013 at 03:30 PM

    Hi,

    bad news, obviously you did not update anything at all according to you trace file:

    B Version of '/usr/sap/FQC/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.290)

    C Oracle Client Version: '10.2.0.2.0', (dbsl 700 150211, non-unicode)

    C DB instance FQC is running on filqua with ORACLE version 10.2.0.2.0 since APR 16, 2013, 10:18:13

    So your kernel is on Version 7.0

    You client is on 10.2.0.2

    Your DB is on 10.2.0.2

    Volker

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 12, 2013 at 05:24 AM

    Hello Jose,

    Check below.

    1) Check if /oracle/client" is available and you are using correct client version.

    2) Give full permission to profile directory.

    3) For your case keep both 10x_64 & 11x_64 Clients and retry .

    This worked for me.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 12, 2013 at 02:33 PM

    Hi Jose,

    I have recently faced this issue. Please don't rename or delete 10X_64 dir . Keep both dir just make delte old soft like & create in new client i.e 11X_64. Please change env for new cliet. I am sure this will resolve your issue.

    Regards

    Ram

    Add comment
    10|10000 characters needed characters exceeded