R3trans error after upgrade oracle 10.2.0.4 to 11.2.0.3

[ricardo_rivas]

Hello,

After upgrade Oracle to 11.2.0.3 and upgrade kernel 7.20 EXT into AIX 6.1 the R3trans -x  finished (0012). The R3trans.los show:

4 ETW000 R3trans version 6.24 (release 720 - 23.05.13 - 20:13:04 ).

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

4 ETW000

4 ETW000 date&time   : 21.06.2013 - 09:35:08

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]  Fri Jun 21 09:35:08 2013                                                 111  0.000111

4 ETW000  [     dev trc,00000]  db_con_init called                                                        10  0.000121

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used        28  0.000149

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  16  0.000165

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

4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/P01/SYS/exe/run/dboraslib.o' ...             42  0.000216

4 ETW000  [    dlux.c  ,00000]  *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/P01/SYS/exe/run/dboraslib.o") FAILED

4 ETW000                          "     0509-130 Symbol resolution failed for /usr/sap/P01/SYS/exe/run/dboraslib.o because:

4 ETW000                                0509-136   Symbol strcat (number 150) is not exported from             1656  0.001872

4 ETW000                                           dependent module /usr/lib/libclntsh.a[shr.o].

4 ETW000                                050"  (errno=8,Exec format error)

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

4 ETW000                                                                                                  61  0.001933

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

How can solved this issue?

Best Regards,

Ricardo Rivas

[stefan_koehler · Accepted solution]

Hi Ricardo,

> After upgrade Oracle to 11.2.0.3 and upgrade kernel 7.20 EXT into AIX 6.1

So you changed the operating system or server as well?

The error is pretty misleading, but it can be caused by disabled async I/O (on AIX). Please check a pretty old blog of mine about this:

http://scn.sap.com/community/aix/blog/2008/05/05/sap-r3trans-error-on-aix-with-async-io

If async I/O is enabled and it still does not work - please execute the following and post the output:

shell> su - p01adm
shell> ldd /usr/sap/P01/SYS/exe/run/dboraslib.o

** UPDATE: Just have seen that it seems like you have an Oracle client (libclntsh.a) in /usr/lib/. What is this client about? It seems like this is the wrong version as well. Please check SAPnote #819829 for a guide how to install the instant client correctly (and the correct version).

Regards

Stefan

[ricardo_rivas · Accepted solution]

Hi Stefan

Reviewing libclntsh.a in /usr/lib,  I see a link to old client path, then deleted the link and R3trans -x is successfully.

Thanks for you help.

[Reagan]

Hello

Did you update the Oracle 11G instant client ?

Check this SAP note

Note 819829 - Oracle Instant Client Installation and Configuration on Unix

Regards

RB