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

[Jean-Luc Oudart]

So it looks like sqlplus was relinked.

From Metalink doc 109621.1
(HP-UX: LD_LIBRARY_PATH and SHLIB_PATH)
...
5. WHICH VARIABLE SHOULD BE SET FOR 64 BIT ORACLE? ----------------------------------------------- A 64 bit install of Oracle includes both 32 bit executables (such as svrmgrl and sqlplus) and 64 bit executables (such as oracle). The installation contains two 'lib' areas: Prior to 9i: $ORACLE_HOME/lib - 32 bit libs $ORACLE_HOME/lib64 - 64 bit libs 9i onwards: $ORACLE_HOME/lib32 - 32 bit libs $ORACLE_HOME/lib - 64 bit libs 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

...

Rgds,
Jean-Luc

[Giridhar S]

I tried setting LD_LIBRARY_PATH and SHLIB_PATH as per the instructions:

oracle@ismuxa21:echo $LD_LIBRARY_PATH
/disk1/ora9i/lib
oracle@ismuxa21:echo $SHLIB_PATH
/disk1/ora9i/lib32:/usr/lib

but no luck yet. I am still getting the same error.

[Jean-Luc Oudart]

Also,
check Metalink note 181628.1

regards,
Jean-Luc

[Mark Greene_1]

From the Oracle metalink website I found two instances of this. There are two different fixes.

First, run the "file" command against all of the patches you loaded to ensure you got the 64 bit versions.

Second, run "nm" against the oracle executable to see all the symbols; when you find the reference for kglla62, run "ar" with the "rv" options on that library file and then try to launch Oracle again.

mark

[Brian Crabtree]

Giridhar,

Just to start with the obvious. Have you relinked the binaries ($OH/bin ; relink all), and verified that they are compiled correctly? Also, make sure that you relink sqlplus as well (cd $OH/sqlplus/lib ; make -f ins_sqlplus.mk install)

You should get some errors when trying to relink that might help diagnose the problem.

Thanks,

Brian

[T G Manikandan]

The problem is that you have not followed the readme notes of the patch installation.

set your env properly.
shutdown Oracle services.
apply the patch bundle.
Re-link the oracle binaries


That should work fine.

[Yogeeraj_1]

hi giridhar,

1. Please check your environment.
2. Consider relinking: make -f ins_rdbms.mk ioracle
3. can you post the output of "which sqlplus"?

regards
Yogeeraj

[Giridhar S]

Here'z the output:
oracle@ismuxa21:which sqlplus
/disk1/ora9i/bin/sqlplus

By the way, I tried relinking oracle, with the command
make -f ins_rdbms.mk ioracle 1>relinkoraout 2>>relinkoraout. I have attached the relinkoraout file with this reply. The undefined symbol 'kglla62' is clearly visible when I relink. Not sure what is the option I have now ?

Should I consider re-installing this patch (migrating from 9.2.0.1 to 9.2.0.4) again now ? Please advise

[T G Manikandan]

Do you have all HPUX patches installed.

What recent bundles you have on your system,

you need to have all the below patches on HPUX11i,
Pre-requisite System Patches:
Support Plus Bundle 'December 2002 SP-0212' or later
JDK 1.3.1.02
PHNE_27745 (For RAC systems)
PHNE_28568
PHKL_25506
PHSS_26560
PHSS_26946
PHSS_28849 (For ServiceGuard systems)
PHCO_28427
PHCO_24402


check and revert

[Giridhar S]

Yes, I just checked and I have all the HP-UX 11i patches shipped as a part of GoldBase patches. Attached are lines from swlist:

GOLDBASE11i B.11.11.0306.4 Gold Base Patches for HP-
UX 11i, June 2003
GOLDAPPS11i B.11.11.0306.4 Gold Applications Patches
for HP-UX 11i, June 2003

The JDK version installed is 1.3.1.05 - Sun's HotSpot VM.

I tried re-installing the patch but even after re-installation, I still get the same error !! Can somebody please help ?

[Brian Crabtree]

Giridhar,

This looks really wrong. I would verify that you have the correct patchset
(ie: make sure that you downloaded the one for HP-UX and not AIX or Solaris). The
errors that you are seeing are coming from internal oracle libraries, not system
libraries (libserver.a).

I would definately either remove and reinstall oracle and the bad, or recover it
from a backup (Oracle Home and Oracle base). I would download the patchset again
from Oracle. and verify that it is correct. If you are absolutely positive that it is
correct, I would contact Oracle support, but I would download a new version of it and
install that.

Brian

[T G Manikandan]

Was Oracle running well after the initial 9.2.0.1 installation?

If so,check whether you are installing the proper patchset of HPUX OS.

[Giridhar S]

Yes, oracle was running fine with version 9.2.0.1.

[wernerp]

Hello,

I have the same problem, exactly the same error which you have posted 2 years ago. I wonder if you found a solution to it (besides reinstalling Oracle). I use the same Oracle version you used an also HP-UX11.11.
If you solved the problem please send me your solution because I've been trying EVERYTHING and it doesn't work.

Thank you!