cancel
Showing results for 
Search instead for 
Did you mean: 

Could not load module libskgxp11.so.

Former Member
0 Kudos

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,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

SAP wrote:

create as root following OS link:

ln -s /oracle/AMP/112_64/lib/libskgxp11.so /lib/lib/libskgxp11.so

Former Member
0 Kudos

Please provide output of the following command as oraamp user:

ldd $ORACLE_HOME/bin/oracle

Regards,

Roman

Answers (5)

Answers (5)

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

volker_borowski2
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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,

volker_borowski2
Active Contributor
0 Kudos

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):

  • The library search path ('LD_LIBRARY_PATH', 'SHLIB_PATH', 'LIBPATH') MUST refer to only one instant client directory. It MUST NOT contain more than one instant client directory or any Oracle Home directory ('$ORACLE_HOME/lib'), regardless of the order.

Message was edited by: Volker Borowski

Former Member
0 Kudos

If you are on 7.20 standard brtools, you might stil use instantclient 10 (out of support) and older xlC environment.

You can use brtools 7.20 with instantclient 11. Simply create soft link

$ cd /oracle/client

$ ln -s 11x_64 10x_64

Regards

Roman

Former Member
0 Kudos

As user ampadm please enter these commands:

ls -l /oracle/AMP/112_64/lib/libskgxp11.so

ls -ld /oracle/AMP/112_64/lib

Former Member
0 Kudos

[ampadm:/home/ampadm]# ls -l /oracle/AMP/112_64/lib/libskgxp11.so

-rwxr-xr-x    1 oraamp   dba          884028 Oct 16 13:47 /oracle/AMP/112_64/lib/libskgxp11.so*

[ampadm:/home/ampadm]# ls -ld /oracle/AMP/112_64/lib

drwxr-xr-x    4 oraamp   dba           16384 Oct 16 13:47 /oracle/AMP/112_64/lib/

Former Member
0 Kudos

Thanks;

not what I was thinking ....

But is there really a * at the end of /oracle/AMP/112_64/lib/libskgxp11.so* ??

strange ...

Or is that an AIX feature?

(I am not familiar with AIX.)

Former Member
0 Kudos

Check if libskgxp11.so file exists in $ORACLE_HOME/lib directory. Perhaps you need to relink oracle software.

Regards

Roman

Former Member
0 Kudos

Hi Roman,

[root@lmtaix015:/oracle/AMP/11202/lib]# ls -la libskgxp11.so

-rwxr-xr-x    1 oraamp   dba          884028 Oct 15 15:24 libskgxp11.so*

How I relink oracle software?

regards,

Former Member
0 Kudos

First please provide more info about what actions you performed on system that led to this error.

Regards

Roman

Former Member
0 Kudos

We made an Update on OS from AIX 5.3 to AIX 6.1

Regards,

Former Member
0 Kudos

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

Former Member
0 Kudos

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,

Former Member
0 Kudos

Could you give the permission, below;

chmod 6751 $ORACLE_HOME/bin/oracle

Best regards,

Orkun Gedik

Former Member
0 Kudos

lmtaix015:oraamp 32> ls -la oracle

-rwsr-s--x    1 oraamp   dba       279037427 Feb 27 2011  oracle

regards,

Former Member
0 Kudos

Please attach /home/ampadm/startdb.log file.

Regards

Roman

Former Member
0 Kudos

------------------------------ 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,

Former Member
0 Kudos

As per note 97953:

"ORACLE_HOME point to the directory RDBMS_SOFTWARE-installation that must be relinked."

What ORACLE_HOME value you are used?

Regards

Roman

Former Member
0 Kudos

for ampadm : ORACLE_HOME=/oracle/AMP/112_64

for oraamp:   ORACLE_HOME=/oracle/AMP/112_64

regards,

Former Member
0 Kudos

You need to relink as oraamp with $ORACLE_HOME=/oracle/AMP/11202 (set only for relink)

Regards

Roman

Former Member
0 Kudos

how I do it?

Former Member
0 Kudos

Shutdown the database and listener

# su - oraamp

$ setenv ORACLE_HOME /oracle/AMP/11202

$ cd /oracle/AMP/11202/bin

$ relink all

Regards

Roman

Former Member
0 Kudos

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

Former Member
0 Kudos

Please provide output of the following command as oraamp user:

ldd $ORACLE_HOME/bin/oracle

Regards

Roman

Former Member
0 Kudos

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

Former Member
0 Kudos

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*

Former Member
0 Kudos

Execute the statements, below;

cd $ORACLE_HOME/bin

relink all

Do not forget to shutdown the database before, the relink.

Best regards,

Orkun Gedik