on 05-26-2008 3:39 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.