on 08-04-2010 11:24 PM
Hi All!
After a backup/restore system copy, and after checking (and applyng!) all the step descibed in the following link,
on my SAP NW2004s (AIX, Oracle 10g) I have the following problem:
if I try to execute the command startsap with usr <SID>adm i can't start DB and I have the following error message
starting database
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Aug 4 23:58:21 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
exec(): 0509-036 Cannot load program oracleBWP because of the following errors:
0509-150 Dependent module libjox10.a(shr.o) could not be loaded.
0509-022 Cannot load module libjox10.a(shr.o).
0509-026 System error: A file or directory in the path name does not exist.
ERROR:
ORA-12547: TNS:lost contact
exec(): 0509-036 Cannot load program oracleBWP because of the following errors:
0509-150 Dependent module libjox10.a(shr.o) could not be loaded.
0509-022 Cannot load module libjox10.a(shr.o).
0509-026 System error: A file or directory in the path name does not exist.
exec(): 0509-036 Cannot load program oracleBWP because of the following errors:
0509-150 Dependent module libjox10.a(shr.o) could not be loaded.
0509-022 Cannot load module libjox10.a(shr.o).
0509-026 System error: A file or directory in the path name does not exist.
ORA-12547: TNS:lost contact
Connect to the database to verify, that the database is now open
R3trans check finished with return code: 12
ERROR: Startup of database failed
Notify Database Administrator.
/usr/sap/BWP/SYS/exe/run/startdb: Terminating with error code 12
Also i check the entry in /etc/services and is correctly defined
sapmsBWT 3600/tcp # SAP System Message Server Port
I can start/stop correctly my oracle database with ora<SID> user using sqlplus.
If I try the R3trans -d command with user <SID>adm the return code is 0.
The <SID>adm env configuration contains the following line
LIBPATH=/usr/lib:/lib:/usr/sap/BWP/SYS/exe/run:/oracle/client/10x_64/instantclient
and the $ORACLE_HOME is set to /oracle/BWP/102_64
Please, can someone help me?
Thanks a lot!
Marzia
Hello Marzia,
> After a backup/restore system copy .....
> 0509-150 Dependent module libjox10.a(shr.o) could not be loaded.
Did you also change the SID (and ORACLE_HOME path) while performing the systemcopy?
If yes you need to relink the oracle binaries ... perform the following step
shell> su - ora<SID>
shell> relink all
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mark e Stefan.
First of all, thank for your cooperations!
Now... I've checked the env path as you say, and everithing is ok.
After that I try to check the "List of Dynamic Dependencies" with the ldd command, and this is the result:
bwpadm> ldd $ORACLE_HOME/bin/oracle
/oracle/BWP/102_64/bin/oracle needs:
/usr/lib/libc.a(shr_64.o)
/usr/lib/libpthreads.a(shr_xpg5_64.o)
Cannot find libjox10.a(shr.o)
/usr/lib/libdl.a(shr_64.o)
/usr/lib/libperfstat.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)
/usr/lib/libcfg.a(shr_64.o)
/usr/lib/liblvm.a(shr_64.o)
Now, "just for fun", i've created a symlink to the quality test system (BWT)
/oracle/BWT -> BWP
and executing the ldd $ORACLE_HOME/bin/oracle command i didn't get any error!
Now, after executing the relink all command I get the following error message:
ld: 0706-006 Cannot find or open library file: -l java
ld:open(): A file or directory in the path name does not exist.
ld: 0706-006 Cannot find or open library file: -l jvm
ld:open(): A file or directory in the path name does not exist.
make: 1254-004 The error code from the last command is 255.
/bin/ld -G -o /oracle/BWP/102_64/sysman/lib/libnmemso.so -bE:/oracle/BWP/102_64/sysman/lib32/libnmemso.exp -bI:/usr/lib/aio.exp -L/oracle/BWP/102_64/lib32 -L/oracle/BWP/102_64/sysman/lib32/ -blibpath:/oracle/BWP/102_64/lib32/:/oracle/BWP/102_64/lib/:/oracle/BWP/102_64/sysman/lib32/ /oracle/BWP/102_64/sysman/lib32/libnmem.a /oracle/BWP/102_64/sysman/lib32/libnmer.a /oracle/BWP/102_64/sysman/lib32/libnmeu.a /oracle/BWP/102_64/sysman/lib32/libnmt.a /oracle/BWP/102_64/sysman/lib32/libnml.a /oracle/BWP/102_64/sysman/lib32/libnmee.a /oracle/BWP/102_64/sysman/lib32/libnmefmgr.a /oracle/BWP/102_64/sysman/lib32/libnmevr.a /oracle/BWP/102_64/sysman/lib32/libnmehu.a /oracle/BWP/102_64/sysman/lib32/libnmehl.a /oracle/BWP/102_64/sysman/lib32/libnmepm.a /oracle/BWP/102_64/sysman/lib32/libnmedc.a /oracle/BWP/102_64/sysman/lib32/libnmedt.a /oracle/BWP/102_64/sysman/lib32/libnmedm.a /oracle/BWP/102_64/sysman/lib32/libnmedr.a /oracle/BWP/102_64/sysman/lib32/libnmeb.a /oracle/BWP/102_64/sysman/lib32/libnmec.a /oracle/BWP/102_64/sysman/lib32/libnmesched.a /oracle/BWP/102_64/sysman/lib32/libnmectl.a /oracle/BWP/102_64/sysman/lib32/libnmejc.a /oracle/BWP/102_64/sysman/lib32/libnmej.a -L/oracle/BWT/102_64/jdk/jre/bin/classic -L/oracle/BWT/102_64/jdk/jre/bin -blazy -ljava -ljvm /oracle/BWP/102_64/sysman/lib32/libnmeclumgr.a /oracle/BWP/102_64/sysman/lib32/libnmecluster.a /oracle/BWP/102_64/sysman/lib32/libnmexml.a -lttsh10 -lld -lm `cat /oracle/BWP/102_64/lib32/sysliblist` -lm
After, after, after all wi try to set JRE_LIB_DIR=$(ORACLE_HOME)/jdk/jre/bin with the following command
export JRE_LIB_DIR=$(ORACLE_HOME)/jdk/jre/bin
but nothing changes!
Any ideas?!?
Thanks
Marzia
Just for my clarification... You have restored a backup from database BWP to BWP, correct? Or are you going to rename the database to BWT?
If the Oracle software of BWT is working correctly, you could consider copying the database software from BWT to BWP and relink the software.. You could also install the new Oracle software. It will not take too long..
Kind regards,
Mark
Have you searched your system for the existence of file libjox10.a? Also check the permissions..
Kind regards,
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mark.
I've checked.
This are the permission on file
-rw-rr 1 orabwp dba 13257611 May 10 2008 libjox10.a
The library is into /oracle/BWP/102_64/lib
The Oracle restored DB is from a NOT UNICODE system. The installed sap system first was a NW2004s UNICODE system (the SAP target release is ONLY unicode). I switched the kernell with a not unicode versione, as I do on my "quality" server in system landscape.
Thanks.
Marzia
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.