Strange error, 9.2.0.4 and libs

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

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

/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@xxxxxxxxxxxx> michael.kline@xxxxxxxxxxxx 
************************************************ 
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

Other related posts: