cancel
Showing results for 
Search instead for 
Did you mean: 

No connect due to DbSl Load Lib Failure - During upgrade

Former Member
0 Kudos

Hi,

I am in the middle of performing PREPARE on a ECC 5.0 system to upgrade to ECC 6.0. During the phase PR_DBPAR the following error is coming:

SAPup> Starting subprocess 15413368 at 20080525190758

ENV <0x1105f2e90>: ORACLE_PSRV=DR5

ENV <0x1105f2ed0>: PATH=/oracle/DR5/102_64/bin:.:/home/dr5adm:/usr/sap/DR5/SYS/e

xe/runU:/usr/sap/DR5/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/

sbin:/usr/java14_64/jre/bin:/usr/java14_64/bin

ENV <0x1105f3070>: NLS_LANG=AMERICAN_AMERICA.UTF8

ENV <0x1105f30d0>: ORACLE_BASE=/oracle

ENV <0x1105f3290>: dbs_ora_tnsname=DR5

ENV <0x1105f32d0>: ORACLE_SID=DR5

ENV <0x1105f34b0>: DIR_LIBRARY=/usr/sap/put/exe

ENV <0x1105f3670>: dbs_ora_schema=SAPDR2

ENV <0x1105f3830>: ORA_NLS33=/oracle/client/9208/ocommon/nls/admin/data

ENV <0x1105f3990>: ORACLE_HOME=/oracle/DR5/102_64

ENV <0x1105f3a70>: dbms_type=ORA

ENV <0x1105f3c30>: LIBPATH=/usr/sap/put/exe:/usr/sap/DR5/SYS/exe/run

ENV <0x1105f3d50>: auth_shadow_upgrade=0

EXECUTING /usr/sap/put/exe/tp (tp) pf=/usr/sap/put/bin/DEFAULT.TPP execdbscript

DR5 -x SQLDBSCRIPT.TQL

This is /usr/sap/put/exe/tp version 372.04.08 (release 700, unicode enabled)

ERROR: No connect due to DbSl Load Lib Failure

ERROR: The values set for DIR_LIBRARY ('/usr/sap/put/exe') or dbms_type ('ORA')

ERROR: Connect to DR5 failed (20080525190759).

Warning: Parameter INTERRUPT is no longer used.

Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.

Warning: Parameter WITH_TACOB is no longer used.

Warning: Parameter IMPDP_BY_EVENT is no longer used.

Warning: Parameter INTERRUPT is no longer used.

Warning: Parameter DAYLIGHT_SHUTDOWN is no longer used.

Warning: Parameter WITH_TACOB is no longer used.

Warning: Parameter IMPDP_BY_EVENT is no longer used.

Warning: Parameter DBCONFPATH is no longer used.

Warning: Parameter STARTDB is no longer used.

Warning: Parameter STOPDB is no longer used.

TRACE-INFO: 1: [dev trc ,00000] Sun May 25 19:07:59 2008

4777 0.004777

TRACE-INFO: 2: [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()=

0509-130 Symbol resolution failed for /usr/sap/put/exe/dboraslib.o because:

TRACE-INFO: 3: 0509-136 Symbol OCIClientVersion (numb

er 130) is not exported from

TRACE-INFO: 4: dependent module /usr/sap/DR5

/SYS/exe/run/libclntsh.a[shr.o].

TRACE-INFO: 5: 0509-022 Cannot load module /usr/sap/put

/exe/dboraslib.o.

TRACE-INFO: 6: 0509-026 System error: Cannot run a file

that does not have a valid format.

TRACE-INFO: 7: 0509-192 Examine .loader section symbols

with the 58 0.004835

TRACE-INFO: 8: 'dump -Tv' command. -> DLENOACC

ESS (8,Exec format error)

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0249

tp finished with return code: 249

meaning:

connect failed due to DbSL load lib failure

Process with ID 15413368 terminated with status 249

We are having oracle 10g on AIX 5.3.

I tried options like setting LIBPATH with /oracle/client/10x_64/instantclient (instead of the default /oracle/client/9208/lib) along with /usr/sap/DR5/SYS/exe/run and having LIBPATH only with /usr/sap/DR5/SYS/exe/run and having env variable DBS_LIBPATH_EXT=/oracle/client/10x_64/instantclient (as per note 836517)

but if i try to restart PREPARE again, it is picking up the changes happening in LIBPATH (but same error) and also it not picking up DBS_LIBPATH_EXT env variable at all (may be if i try to make it permanent using .sh file it will pick up but i dont want that)

With all the above said, anyone has any perfect idea to have this issue fixed and continue the prepare process ?

Thanks,

Murali.

Accepted Solutions (1)

Accepted Solutions (1)

ImreSAP
Participant
0 Kudos

Hi Murali,

There is an issue with the tp connection to database. It fails with the

following error:

ERROR DlLoadLib: dlopen()= 0509-022 Cannot load

module /usr/sap/put/exe/dboraslib.o

Could you please check the file /usr/sap/put/exe/dboraslib.o ?

Is this library from version 7.00 ?

Please refer to the following SAP Notes:

403004 Database connect using R3trans fails

538849 UNIX: DLENOACCESS when loading dboraslib and libclntsh

Kind regards

Imre Takácsi-Nagy

Senior Support Consultant II.

SAP Global Support Center Austria

Netweaver WEB Application Server ABAP / JAVA

Former Member
0 Kudos

Hi Imre,

Thanks for taking time to reply. I did go through those notes but not quite clear and did not fixed my issue.

I did R3trans -x as shown in the note and following is the output:

#dr5adm@sapdr5-3d[DR5]> more trans.log

4 ETW000 ./R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 26.05.2008 - 12:53:48

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] Mon May 26 12:53:48 2008

113 0.000113

4 ETW000 [dev trc ,00000] db_con_init called

29 0.000142

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

60 0.000202

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

' ...

4 ETW000

69 0.000271

4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= 0509-130

Symbol resolution failed for /usr/sap/put/exe/dboraslib.o because:

4 ETW000 0509-136 Symbol OCIClientVersion (numb

er 130) is not exported from

4 ETW000 dependent module /usr/sap/DR5

/SYS/exe/run/libclntsh.a[shr.o].

4 ETW000 0509-022 Cannot load module /usr/sap/put

/exe/dboraslib.o.

4 ETW000 0509-026 System error: Cannot run a file

that does not have a valid format.

4 ETW000 0509-192 Examine .loader section symbols

with the

4 ETW000 'dump -Tv' command. -> DLENOACC

ESS (8,Exec format error)

4 ETW000

2309 0.002580

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

/exe/dboraslib.o'

4 ETW000

47 0.002627

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY

('/usr/sap/put/exe') or dbms_type ('ORA')"

#[/usr/sap/put/exe]

#dr5adm@sapdr5-3d[DR5]>

The following are the special env variable change i did for sidadm before executing ./R3trans -x from /usr/sap/put/exe :

export DBS_LIBPATH_EXT=/oracle/client/10x_64/instantclient

export DIR_LIBRARY=/usr/sap/put/exe

LIBPATH=/usr/sap/DR5/SYS/exe/run:/usr/sap/put/exe

We are in AIX 5.3/Oracle 10.0.2.0.2

Thanks,

Murali.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Thanks for whoever try to help me so far. Issue is solved after having the DIR_LIBRARY and LIBPATH pointing to exe of upgrade directory (/usr/sap/put/exe) and having DBS_LIBPATH_EXT=/oracle/client/10x_64/instantclient

Thanks

former_member236869
Participant
0 Kudos

Hi, I have the same problem with PREPARE in PR_DBPAR phase.

I'm doing Combined upgrade and Unicode conversion of an MDMP R/3 4.6C system to ECC 6.0 Unicode

I thing you had to add only DBS_LIBPATH_EXT=/oracle/client/10x_64/instantclient to <sid>adm environment profiles.

DIR_LIBRARY and LIBPATH are OK for me, because pointing to exe of upgrade directory /usr/sap/put/exe.

Otherwise, how could you have the PREPARE and R/3, productive, running in the same time ?

Could you let me know ?

Thanks in advance.

former_member236869
Participant
0 Kudos

Hi to all.

I found the answer.

The changes suggested can be done for the life of the session, with setenv comand, in the <sid>adm session where the Upgrade Asssistant Server will run into.

The setting will be OK when R3trans -d will work from this session.

markus_doehr2
Active Contributor
0 Kudos

Did you install Oracle instantclient after you upgraded your database to 10g? The "normal" 6.40 kernels use the 9.2 client but the 7.00 kernel needs the instantclient.

819829 - Oracle Database 10g: Instant Client 10.x on Unix

Markus

Former Member
0 Kudos

Yes we have the instantclient installed in the box. (/oracle/client/10x_64/instantclient)

Thanks,

Murali.

markus_doehr2
Active Contributor
0 Kudos
TRACE-INFO: 2: http://dlux.c ,00000 *** ERROR => DlLoadLib: dlopen()=
0509-130 Symbol resolution failed for /usr/sap/put/exe/dboraslib.o because:
TRACE-INFO: 3: 0509-136 Symbol OCIClientVersion (number 130) is not exported from
TRACE-INFO: 4: dependent module /usr/sap/DR5/SYS/exe/run/libclntsh.ahttp://shr.o.
TRACE-INFO: 5: 0509-022 Cannot load module /usr/sap/put/exe/dboraslib.o.
TRACE-INFO: 6: 0509-026 System error: Cannot run a filethat does not have a valid format.
TRACE-INFO: 7: 0509-192 Examine .loader section symbolswith the 58 0.004835
TRACE-INFO: 8: 'dump -Tv' command. -> DLENOACC

The problem seems to be that the system is loading the client from your instance directory (see line 4) and not from the instantclient.

I've not seen such a configuration. Is there a special reason why you put the 9.2 client library in the DIR_LIBRARY of the instance?

Markus

Former Member
0 Kudos

Hi Markus,

Thanks for your reply. The issue is as follows:

If i keep the current default value of the env variable LIBPATH which is

LIBPATH=/usr/lib:/lib:/usr/sap/DR5/SYS/exe/run:/usr/sap/DR5/SYS/exe/runU:/oracle

/client/9208/lib

and being in /usr/sap/SID/SYS/exe/run (which is 6.40 kernel ECC 5.0) if i execute

ldd dboraslib.o the following is the output:

dboraslib.o needs:

/usr/sap/DR5/SYS/exe/run/libsapu16.so

/usr/sap/DR5/SYS/exe/run/libclntsh.a(shr.o)

/oracle/client/9208/lib/libwtc9.so

/usr/lib/libc.a(shr_64.o)

/usr/lib/libpthreads.a(shr_xpg5_64.o)

/usr/lib/libdl.a(shr_64.o)

/usr/lib/libodm.a(shr_64.o)

/usr/lib/libc.a(aio_64.o)

/unix

/usr/lib/libcrypt.a(shr_64.o)

being in /usr/sap/put/exe (which is in the middle of PREPARE step for ECC 6.0 upgrade, so it put kernel 7.0 files), the following is the output:

dboraslib.o needs:

/usr/lib/libc.a(shr_64.o)

/usr/sap/DR5/SYS/exe/run/libclntsh.a(shr.o)

/unix

/usr/lib/libcrypt.a(shr_64.o)

/usr/lib/libpthreads.a(shr_xpg5_64.o)

/usr/lib/libdl.a(shr_64.o)

/usr/lib/libodm.a(shr_64.o)

/usr/lib/libc.a(aio_64.o)

But if i change the environment variable for LIBPATH as follows:

LIBPATH=/oracle/client/10x_64/instantclient:/usr/lib:/lib:/usr/sap/DR5/SYS/exe/run:

/usr/sap/DR5/SYS/exe/runU (since we have already installed oracle 10g which is up and running and so we have already installed instant client also during that process)

the following is what the output for both the path as mentioned earlier:

#[/usr/sap/put/exe]

#dr5adm@sapdr5-3d[DR5]> ldd dboraslib.o

dboraslib.o needs:

/usr/lib/libc.a(shr_64.o)

/oracle/client/10x_64/instantclient/libclntsh.a(shr.o)

/unix

/usr/lib/libcrypt.a(shr_64.o)

/usr/lib/libpthreads.a(shr_xpg5_64.o)

/usr/lib/libdl.a(shr_64.o)

/usr/lib/libodm.a(shr_64.o)

/usr/lib/libperfstat.a(shr_64.o)

/usr/lib/libcfg.a(shr_64.o)

/usr/lib/liblvm.a(shr_64.o)

#[/usr/sap/DR5/SYS/exe/run]

#dr5adm@sapdr5-3d[DR5]> ldd dboraslib.o

dboraslib.o needs:

/usr/sap/DR5/SYS/exe/run/libsapu16.so

/oracle/client/10x_64/instantclient/libclntsh.a(shr.o)

/oracle/client/92x_64/lib/libwtc9.so

/usr/lib/libc.a(shr_64.o)

/usr/lib/libpthreads.a(shr_xpg5_64.o)

/usr/lib/libdl.a(shr_64.o)

/usr/lib/libodm.a(shr_64.o)

/usr/lib/libperfstat.a(shr_64.o)

/usr/lib/libc.a(aio_64.o)

/unix

/usr/lib/libcrypt.a(shr_64.o)

/usr/lib/libcfg.a(shr_64.o)

/usr/lib/liblvm.a(shr_64.o)

DIR_LIBRARY on both the cases and by default also is /usr/sap/SID/SYS/exe/run (pointing to running 6.40 kernel)

But if i try the PREPARE with or without this changes, the issue what i reported is what happening. Let me know your ideas on this.

Thanks,

Murali.