topic Re: HP UX 11.11 + Oracle 9.2.0 in Operating System - HP-UX

HP UX 11.11 + Oracle 9.2.0

Giridhar S — Tue, 10 Feb 2004 09:04:56 GMT

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

Re: HP UX 11.11 + Oracle 9.2.0

Mark Greene_1 — Tue, 10 Feb 2004 09:11:54 GMT

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

Re: HP UX 11.11 + Oracle 9.2.0

Jean-Luc Oudart — Tue, 10 Feb 2004 09:18:33 GMT

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

Re: HP UX 11.11 + Oracle 9.2.0

Giridhar S — Tue, 10 Feb 2004 09:22:53 GMT

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

Re: HP UX 11.11 + Oracle 9.2.0

Jean-Luc Oudart — Tue, 10 Feb 2004 09:27:42 GMT

Could you set your LD_LIBRARY_PATH and test again ?

Jean-Luc

Re: HP UX 11.11 + Oracle 9.2.0

Giridhar S — Tue, 10 Feb 2004 09:30:07 GMT

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

Re: HP UX 11.11 + Oracle 9.2.0

Steven E. Protter — Tue, 10 Feb 2004 09:33:11 GMT

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

Re: HP UX 11.11 + Oracle 9.2.0

Giridhar S — Tue, 10 Feb 2004 09:37:19 GMT

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

Re: HP UX 11.11 + Oracle 9.2.0

Jean-Luc Oudart — Tue, 10 Feb 2004 09:38:07 GMT

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

Jean-Luc

Re: HP UX 11.11 + Oracle 9.2.0

Giridhar S — Tue, 10 Feb 2004 09:42:09 GMT

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

Re: HP UX 11.11 + Oracle 9.2.0

Jean-Luc Oudart — Tue, 10 Feb 2004 09:59:31 GMT

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

Re: HP UX 11.11 + Oracle 9.2.0

Giridhar S — Tue, 10 Feb 2004 10:07:25 GMT

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.

Re: HP UX 11.11 + Oracle 9.2.0

Jean-Luc Oudart — Tue, 10 Feb 2004 10:08:04 GMT

Also,
check Metalink note 181628.1

regards,
Jean-Luc

Re: HP UX 11.11 + Oracle 9.2.0

Mark Greene_1 — Tue, 10 Feb 2004 11:38:43 GMT

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

Re: HP UX 11.11 + Oracle 9.2.0

Brian Crabtree — Tue, 10 Feb 2004 20:24:05 GMT

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

Re: HP UX 11.11 + Oracle 9.2.0

T G Manikandan — Tue, 10 Feb 2004 22:41:38 GMT

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.

Re: HP UX 11.11 + Oracle 9.2.0

Yogeeraj_1 — Tue, 10 Feb 2004 23:24:16 GMT

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

Re: HP UX 11.11 + Oracle 9.2.0

Giridhar S — Tue, 10 Feb 2004 23:54:51 GMT

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

Re: HP UX 11.11 + Oracle 9.2.0

T G Manikandan — Wed, 11 Feb 2004 00:15:33 GMT

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

Re: HP UX 11.11 + Oracle 9.2.0

Giridhar S — Wed, 11 Feb 2004 01:40:22 GMT

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 ?