Strange error, 9.2.0.4 and libs

From: Kline.Michael <Michael.Kline_at_SunTrust.com>
Date: Fri, 29 Oct 2004 06:45:59 -0400
Message-ID: <52C70FF150F49E479DAF59C68A27149D5A8557@va016a0e2.corp.suntrust.com>

We did an install of Oracle 9.2.0.4 on HP-UX...

Was only supposed to take a couple of hours to do that and convert the database.

But when it was time to bring things up:

SQL*Plus: Release 9.2.0.4.0 - Production on Thu Oct 28 14:32:44 2004

/usr/lib/pa20_64/dld.sl: Unsatisfied data symbol 'kglla62_' in load module '/u001/app/oracle/product/9.2.0.4/bin/oracle'.

ERROR: ORA-12547: TNS:lost contact

Enter user-name:

No problem I thought since I had hits on Metalink about libraries. No setting of any libraries helps. All metalink docs seem to not be the solution.

I did a couple of queries on a working box:

Checking libraries

BSDD: EPMD:/home/oracle>

EPMD:/home/oracle> cd $ORACLE_HOME

EPMD:/u01/app/oracle/product/9.2.0.4> find -name libodm9.sl -print

Usage: find path-list [predicate-list]

EPMD:/u01/app/oracle/product/9.2.0.4> find . -name libodm9.sl -print

./lib/libodm9.sl

EPMD:/u01/app/oracle/product/9.2.0.4> file ./lib/libodm9.sl

./lib/libodm9.sl: ELF-64 shared object file - PA-RISC 2.0 (LP64)

EPMD:/u01/app/oracle/product/9.2.0.4> ls -la ./lib/libodm9.sl

lrwxrwxr-x 1 oracle dba 11 Aug 24 09:56
./lib/libodm9.sl -> libodmd9.sl

EPMD:/u01/app/oracle/product/9.2.0.4>

EPMD:/u01/app/oracle/product/9.2.0.4/lib> ls -la libodmd9.sl

-rwxr-xr-x 1 oracle dba 6144 Jul 26 2003 libodmd9.sl

D50:

DPFRPT:/home/oracle>

DPFRPT:/home/oracle> cd $ORACLE_HOME

DPFRPT:/u001/app/oracle/product/9.2.0.4> find . -name libodm9.sl -print

./lib/libodm9.sl

DPFRPT:/u001/app/oracle/product/9.2.0.4> file ./lib/libodm9.sl

./lib/libodm9.sl: ELF-64 shared object file - PA-RISC 2.0 (LP64)

DPFRPT:/u001/app/oracle/product/9.2.0.4> ls -la ./lib/libodm9.sl

lrwxrwxr-x 1 oracle oinstall 11 Oct 26 14:21
./lib/libodm9.sl -> libodmd9.sl

DPFRPT:/u001/app/oracle/product/9.2.0.4>

DPFRPT:/u001/app/oracle/product/9.2.0.4/lib> ls -la libodmd9.sl

-rwxr-xr-x 1 oracle oinstall 6144 Jul 26 2003 libodmd9.sl

This is the same on both boxes, or appears to be:

chatr oracle

/u001/app/oracle/product/9.2.0.4/bin/oracle:

64-bit ELF executable

shared library dynamic path search:

LD_LIBRARY_PATH enabled first

SHLIB_PATH enabled second

embedded path enabled third /u001/app/oracle/product/9.2.0.4/rdbms/lib/:/u001/app/oracle/product/9.2

.0.4/lib/:/usr/lib/pa20_64:/opt/langtools/lib/pa20_64:

We've tried the metalink points to the paths, we've experimented with others, nothing seems to work.

Some clues in MetaLink:

Both of these directories contain libraries of the same name. To ensure

that 32 bit executables search the 32 bit dir, and 64 bit executables

search the 64 bit dir, set the following:

Prior to 9i:

$LD_LIBRARY_PATH - includes $ORACLE_HOME/lib64, but not $ORACLE_HOME/lib

$SHLIB_PATH - includes $ORACLE_HOME/lib, but not $ORACLE_HOME/lib64

9i onwards:

$LD_LIBRARY_PATH - includes $ORACLE_HOME/lib, but not $ORACLE_HOME/lib32

$SHLIB_PATH - includes $ORACLE_HOME/lib32, but not $ORACLE_HOME/lib

export SHLIB_PATH=/u001/app/oracle/product/9.2.0.4/lib32 Doesn't seem to matter.

There isn't a lib64 on either box.

Michael Kline
Database Administration
SunTrust Technology Center
1030 Wilmer Avenue
Richmond, Virginia 23227
Outside 804.261.9446
STNet 643.9446

Cell 804.744.1545
<mailto:michael.kline_at_suntrust.com> michael.kline_at_suntrust.com

The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 29 2004 - 05:41:32 CDT