on 10-15-2012 3:27 PM
Hi,
When we execute in DB13 CHECKDB or Update Stats, than we get the following messages.
Job wurde gestartet
Step 001 gestartet (Programm RSDBAJOB, Variante &0000000000135
Ausführung des logischen Kommandos BRCONNECT auf Rechner lmtaix015
Parameter: -u / -jid CHECK20121015144130 -c -f check
BR0801I BRCONNECT 7.10 (37)
Could not load program oracleAMP:
Dependent module libskgxp11.so could not be loaded.
Could not load module libskgxp11.so.
System error: No such file or directory
BR0805I Start of BRCONNECT processing: cejqwqlm.chk 2012-10-15 14.41.30
BR0484I BRCONNECT log file: /oracle/AMP/sapcheck/cejqwqlm.chk
Could not load program oracleAMP:
Dependent module libskgxp11.so could not be loaded.
Could not load module libskgxp11.so.
System error: No such file or directory
BR0280I BRCONNECT time stamp: 2012-10-15 14.41.31
BR0301E SQL error -12547 at location db_connect-2, SQL statement:
'CONNECT /'
ORA-12547: TNS:lost contact
BR0310E Connect to database instance AMP failed
Could not load program oracleAMP:
Dependent module libskgxp11.so could not be loaded.
Could not load module libskgxp11.so.
System error: No such file or directory
BR0280I BRCONNECT time stamp: 2012-10-15 14.41.31
BR0301E SQL error -12547 at location db_connect-2, SQL statement:
'CONNECT /'
ORA-12547: TNS:lost contact
BR0310E Connect to database instance AMP failed
BR0806I End of BRCONNECT processing: cejqwqlm.chk2012-10-15 14.41.31
BR0280I BRCONNECT time stamp: 2012-10-15 14.41.31
BR0804I BRCONNECT terminated with errors
External program terminated with exit code 3
BRCONNECT returned error status E
Job wurde beendet
regards,
SAP wrote:
create as root following OS link:
ln -s /oracle/AMP/112_64/lib/libskgxp11.so /lib/lib/libskgxp11.so
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Shatti,
I got the same issue. However when i tried to create the link it mentioned no such file or directory.
ln -s /oracle/SID/112_64/lib/libskgxp11.so /lib/lib/libskgxp11.so
I doubt on the target path is it lib/lib/libskgxp11.so or lib/libskgxp11.so.
Regards,
Raja. G
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Another approach:
Is there a reason why you are still using brtools 7.10 ?
You might consider an upgrade to 7.20 or even 7.20 EXT.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
if this is AIX, what is the result for both SAP Users of
echo $LIBPATH
Should contain $ORACLE_HOME/lib an NO /.../instantclient for orasid, while
for sidadm it should NOT contain $ORACLE_HOME/lib and should have /oracle/client/11x_64/instantclient
BRTOOLS should be on 7.20 EXT and the C-runtime for aix 6.1 should be 11.1.0.2 or higher.
lslpp -l xlC.aix61.rte xlC.rte
(See note for EXT Kernel 7.20)
If you are on 7.20 standard brtools, you might stil use instantclient 10 (out of support) and older xlC environment.
Volker
Hi Volker,
[ampadm:/home/ampadm]# echo $LIBPATH
/usr/lib:/lib:/usr/sap/AMP/SYS/exe/run:/oracle/AMP/112_64/lib:/sapdb/programs/lib/lib64:/oracle/client/10x_64/instantclient
lmtaix015:oraamp 1> echo $LIBPATH
/usr/lib:/lib:/usr/sap/AMP/SYS/exe/run:/oracle/AMP/112_64/lib
lmtaix015:oraamp 4> lslpp -l xlC.aix61.rte xlC.rte
Fileset Level State Description
----------------------------------------------------------------------------
Path: /usr/lib/objrepos
xlC.aix61.rte 11.1.0.2 COMMITTED XL C/C++ Runtime for AIX 6.1
xlC.rte 11.1.0.2 COMMITTED XL C/C++ Runtime
regards,
Hi,
this
.... :/oracle/AMP/112_64/lib:...:/oracle/client/10x_64/instantclient
is a complete NO-GO! Never ever have both locations in LIBPATH.
- You should switch to instantclient 11, as Version 10 is out of support. (This is no must, but a "should")
- You must adopt the environment. Check Note 830578. It describes the environment for both users.
Your C-runtime is high enough to run the EXT Kernel on AIX. So you should at least switch the BRTOOLS to the 7.20-EXT Version if you decide to go for instantclient 11.
If you decide to stay with instantclient 10, I would recommend BRTOOLS 7.20-NON-EXT
Good luck
Volker
Check note 819829 in addition (this is for sidadm):
Message was edited by: Volker Borowski
As user ampadm please enter these commands:
ls -l /oracle/AMP/112_64/lib/libskgxp11.so
ls -ld /oracle/AMP/112_64/lib
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check if libskgxp11.so file exists in $ORACLE_HOME/lib directory. Perhaps you need to relink oracle software.
Regards
Roman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please relink oracle software as per Note 97953 - UNIX: Relinking of the Oracle executables. In two words (for single instance):
shutdown database and listener
# su - ora<sid>
check environment
$ relink all
Regards
Roman
now I executed relink all, but nothing has changed
[ampadm:/oracle/AMP/112_64/install]# startsap
Checking AMP Database
------------------------------
Database is not available via R3trans
Running /usr/sap/AMP/SYS/exe/run/startdb
Trying to start AMP database ...
Log file: /home/ampadm/startdb.log
/usr/sap/AMP/SYS/exe/run/startdb: Terminating with error code 12
DB startup failed
I started DB separately
regards,
------------------------------ Tue Oct 16 13:49:13 CEST 2012
LOGFILE FOR STARTING ORACLE
Trying to start AMP database ...
------------------------------ Tue Oct 16 13:49:14 CEST 2012
checking required environment variables
ORACLE_HOME is >/oracle/AMP/112_64<
ORACLE_SID is >AMP<
------------------------------ Tue Oct 16 13:49:14 CEST 2012
check initora
------------------------------ Tue Oct 16 13:49:14 CEST 2012
check initora
------------------------------ Tue Oct 16 13:49:14 CEST 2012
checking V2 connect
TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 16-OCT-2012 13:49:14
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
/usr/sap/AMP/SYS/profile/oracle/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = lmtaix015) (PORT = 1535))) (CONNECT_DATA = (SID = AMP) (GLOBAL_NAME = AMP.WORLD)))
OK (110 msec)
tnsping: V2 connect to AMP
------------------------------ Tue Oct 16 13:49:14 CEST 2012
Connect to the database to check the database state:
R3trans: connect check finished with return code: 12
Database not available
------------------------------ Tue Oct 16 13:49:14 CEST 2012
Shutdown database
First trying to shutdown the database - May be,
the database is in the nomount or mount state
------------------------------ Tue Oct 16 13:49:14 CEST 2012
starting database
SQL*Plus: Release 11.2.0.2.0 Production on Tue Oct 16 13:49:14 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Could not load program oracleAMP:
Dependent module libskgxp11.so could not be loaded.
Could not load module libskgxp11.so.
System error: No such file or directory
ERROR:
ORA-12547: TNS:lost contact
Could not load program oracleAMP:
Dependent module libskgxp11.so could not be loaded.
Could not load module libskgxp11.so.
System error: No such file or directory
Could not load program oracleAMP:
Dependent module libskgxp11.so could not be loaded.
Could not load module libskgxp11.so.
System error: No such file or directory
ORA-12547: TNS:lost contact
------------------------------ Tue Oct 16 13:49:14 CEST 2012
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/AMP/SYS/exe/run/startdb: Terminating with error code 12
regards,
lmtaix015:oraamp 11> brconnect -u / -jid CHECK20121015144130 -c -f check
BR0801I BRCONNECT 7.10 (37)
Could not load program oracleAMP:
Dependent module libskgxp11.so could not be loaded.
Could not load module libskgxp11.so.
System error: No such file or directory
BR0805I Start of BRCONNECT processing: cejrbwiw.chk 2012-10-16 16.12.38
BR0484I BRCONNECT log file: /oracle/AMP/sapcheck/cejrbwiw.chk
Could not load program oracleAMP:
Dependent module libskgxp11.so could not be loaded.
Could not load module libskgxp11.so.
System error: No such file or directory
BR0280I BRCONNECT time stamp: 2012-10-16 16.12.38
BR0301E SQL error -12547 at location db_connect-2, SQL statement:
'CONNECT /'
ORA-12547: TNS:lost contact
BR0310E Connect to database instance AMP failed
Could not load program oracleAMP:
Dependent module libskgxp11.so could not be loaded.
Could not load module libskgxp11.so.
System error: No such file or directory
BR0280I BRCONNECT time stamp: 2012-10-16 16.12.38
BR0301E SQL error -12547 at location db_connect-2, SQL statement:
'CONNECT /'
ORA-12547: TNS:lost contact
BR0310E Connect to database instance AMP failed
BR0806I End of BRCONNECT processing: cejrbwiw.chk 2012-10-16 16.12.38
BR0280I BRCONNECT time stamp: 2012-10-16 16.12.38
BR0804I BRCONNECT terminated with errors
Hi Shatti,
Are youable to execute the command, at the OS level?
brconnect -u / -jid CHECK20121015144130 -c -f check
On the other hand, check the permission on oracle executable;
cd /oracle/<DBSID>/<release>/bin
ls -ltr oracle
Best regards,
Orkun Gedik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Orkun,
here the output:
[ampadm:/home/ampadm]# brconnect -u / -jid CHECK20121015144130 -c -f check
BR0801I BRCONNECT 7.10 (37)
Could not load program oracleAMP:
Dependent module libskgxp11.so could not be loaded.
Could not load module libskgxp11.so.
System error: No such file or directory
BR0805I Start of BRCONNECT processing: cejravob.chk 2012-10-16 11.10.41
BR0484I BRCONNECT log file: /oracle/AMP/sapcheck/cejravob.chk
Could not load program oracleAMP:
Dependent module libskgxp11.so could not be loaded.
Could not load module libskgxp11.so.
System error: No such file or directory
BR0280I BRCONNECT time stamp: 2012-10-16 11.10.42
BR0301E SQL error -12547 at location db_connect-2, SQL statement:
'CONNECT /'
ORA-12547: TNS:lost contact
BR0310E Connect to database instance AMP failed
Could not load program oracleAMP:
Dependent module libskgxp11.so could not be loaded.
Could not load module libskgxp11.so.
System error: No such file or directory
BR0280I BRCONNECT time stamp: 2012-10-16 11.10.42
BR0301E SQL error -12547 at location db_connect-2, SQL statement:
'CONNECT /'
ORA-12547: TNS:lost contact
BR0310E Connect to database instance AMP failed
BR0806I End of BRCONNECT processing: cejravob.chk 2012-10-16 11.10.42
BR0280I BRCONNECT time stamp: 2012-10-16 11.10.42
BR0804I BRCONNECT terminated with errors
[ampadm:/oracle/AMP/11202]# cd bin
[ampadm:/oracle/AMP/11202/bin]# ls -ltr oracle
-rwsr-sr-x 1 oraamp dba 279037427 Feb 27 2011 oracle*
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.