Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Strange error, and libs

Strange error, and libs

From: Kline.Michael <>
Date: Fri, 29 Oct 2004 06:45:59 -0400
Message-ID: <>

We did an install of Oracle 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 - Production on Thu Oct 28 14:32:44 2004

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

/usr/lib/pa20_64/ Unsatisfied data symbol 'kglla62_' in load module '/u001/app/oracle/product/'.

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/> find -name -print

Usage: find path-list [predicate-list]

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


EPMD:/u01/app/oracle/product/> file ./lib/

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

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

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


EPMD:/u01/app/oracle/product/> ls -la

-rwxr-xr-x 1 oracle dba 6144 Jul 26 2003  



DPFRPT:/home/oracle> cd $ORACLE_HOME

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


DPFRPT:/u001/app/oracle/product/> file ./lib/

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

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

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


DPFRPT:/u001/app/oracle/product/> ls -la

-rwxr-xr-x 1 oracle oinstall 6144 Jul 26 2003  

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

chatr 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/


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

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.
Received on Fri Oct 29 2004 - 05:41:32 CDT

Original text of this message