HP UX 11.11 + Oracle 9.2.0

[Giridhar S]

I had an Oracle 9.2.0.1 installation on HP UX 11.11 which we migrated to 9.2.0.4 by applying a patch [Oracle9i Database Server Patch Set Notes Release 2 Patch Set 3 Version 9.2.0.4.0 for hp-ux PA-RISC (64-bit)].

I am getting the following error when I try to login using sqlplus as sysdba. Can somebody help me please ?

oracle@ismuxa21:sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Feb 10 19:46:38 2004

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

SQL> connect /as sysdba
/usr/lib/pa20_64/dld.sl: Unsatisfied data symbol 'kglla62_' in load module '/disk1/ora9i/
bin/oracle'.
ERROR:
ORA-12547: TNS:lost contact

[Mark Greene_1]

It appears you may have either been missing a path to a library file or the file itself when you did the upgrade. Have you gone to Oracles's web site and done a search on the error? This may be a known problem with a standard solution.

mark

[Jean-Luc Oudart]

Hi,

what value do you have for
ORACLE_BASE
ORACLE_HOME
ORACLE_PATH
SHLIB_PATH
LD_LIBRARY_PATH
PATH

and output for :
chatr $ORACLE_HOME/bin/oracle

Regards,
Jean-Luc

[Giridhar S]

I have the following values:
ORACLE_BASE=/disk1/ora9i
ORACLE_HOME=/disk1/ora9i
ORACLE_PATH - Parameter not set
SHLIB_PATH=/disk1/ora9i/lib:/usr/lib
LD_LIBRARY_PATH - Parameter not set
PATH=/usr/sbin:/usr/bin:/opt/ansic/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/mx/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/upgrade/bin:/opt/fcms/bin:/opt/pd/bin:/opt/resmon/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/scr/bin://opt/perl/bin:/usr/sbin/diag/contrib:/opt/hpnp//bin:/opt/perl5/bin:/opt/aCC/bin:/opt/langtools/bin:/opt/imake/bin:/opt/netscape:/opt/graphics/common/bin:/sbin:/home/root:/disk1/ora9i/bin:/usr/local/bin

and output for :
chatr $ORACLE_HOME/bin/oracle
ismuxa21:/disk1/ora9i/bin->chatr oracle
oracle:
64-bit ELF executable
shared library dynamic path search:
LD_LIBRARY_PATH enabled first
SHLIB_PATH enabled second
embedded path enabled third /disk1/ora9i/rdbms/lib/:/disk1/ora9i/lib/:/usr/lib/pa20_64:/opt/langtools/lib/pa20_64:
shared library list:
libodm9.sl
libskgxn9.sl
libjox9.sl
libcl.2
librt.2
libpthread.1
libnss_dns.1
libdl.1
libm.2
libc.2
shared library binding:
deferred
global hash table disabled
shared vtable support disabled
segments:
index type address flags size
5 text 4000000000000000 z-r-c 64M
6 data 8000000100000000 ---m- L (largest possible)
executable from stack: D (default)
kernel assisted branch prediction enabled
lazy swap allocation for dynamic segments disabled

[Jean-Luc Oudart]

Could you set your LD_LIBRARY_PATH and test again ?

Jean-Luc

[Giridhar S]

I set LD_LIBRARY_PATH to /disk1/ora9i/lib:/usr/lib (same as $SHLIB_PATH) but no luck. I get the same error.

[Steven E. Protter]

LD_LIB_PATH is not a valid environment variable for HP-UX/Oracle.

Set SHLIB_PATH

It would appear that you need at this point to relink oracle.

Check tnsnames.ora and sqlnet.ora with tnsping and make sure your oracle network connectivity is working right.

SEP

[Giridhar S]

Here is the output of tnsping command:

oracle@ismuxa21:tnsping ismuxa21

TNS Ping Utility for HPUX: Version 9.2.0.4.0 - Production on 10-FEB-2004 20:18:40

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
/disk1/ora9i/network/admin/sqlnet.ora

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=ismuxa21.))(ADDRESS
=(PROTOCOL=TCP)(HOST=ismuxa21)(PORT=1521)))
OK (10 msec)

So it looks like the Oracle network connectivity is alright.

What is relinking you are referring to ? How do I do that ?

Thanks, Giri

[Jean-Luc Oudart]

The patch install should have relinked the binaries.
ll $ORACLE_HOME/bin/sqlplus*
output ?

Jean-Luc

[Giridhar S]

Here'z the output:

oracle@ismuxa21:ll $ORACLE_HOME/bin/sqlplus*
-rwxr-x--x 1 oracle dba 15670544 Feb 10 17:58 /disk1/ora9i/bin/sqlplus
-rwxr-xr-x 1 oracle dba 0 Aug 7 2003 /disk1/ora9i/bin/sqlplusO