R3trans failed maybe someone set invalid values for DIR_LIBRARY

[Former Member]

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.

[former_member227600]

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

[Former Member]

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.

[volker_borowski2]

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

[ashish_mishra2]

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

[former_member188883]

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

[former_member206552]

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