cancel
Showing results for 
Search instead for 
Did you mean: 

HP UX 11.11 + Oracle 9.2.0

Giridhar S
Occasional Advisor

HP UX 11.11 + Oracle 9.2.0

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
23 REPLIES
Mark Greene_1
Honored Contributor

Re: HP UX 11.11 + Oracle 9.2.0

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
the future will be a lot like now, only later
Jean-Luc Oudart
Honored Contributor

Re: HP UX 11.11 + Oracle 9.2.0

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
fiat lux
Giridhar S
Occasional Advisor

Re: HP UX 11.11 + Oracle 9.2.0

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
Honored Contributor

Re: HP UX 11.11 + Oracle 9.2.0

Could you set your LD_LIBRARY_PATH and test again ?

Jean-Luc
fiat lux
Giridhar S
Occasional Advisor

Re: HP UX 11.11 + Oracle 9.2.0

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
Exalted Contributor

Re: HP UX 11.11 + Oracle 9.2.0

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Giridhar S
Occasional Advisor

Re: HP UX 11.11 + Oracle 9.2.0

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
Honored Contributor

Re: HP UX 11.11 + Oracle 9.2.0

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

Jean-Luc
fiat lux
Giridhar S
Occasional Advisor

Re: HP UX 11.11 + Oracle 9.2.0

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
Honored Contributor

Re: HP UX 11.11 + Oracle 9.2.0

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
fiat lux
Giridhar S
Occasional Advisor

Re: HP UX 11.11 + Oracle 9.2.0

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
Honored Contributor

Re: HP UX 11.11 + Oracle 9.2.0

Also,
check Metalink note 181628.1

regards,
Jean-Luc
fiat lux
Mark Greene_1
Honored Contributor

Re: HP UX 11.11 + Oracle 9.2.0

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
the future will be a lot like now, only later
Brian Crabtree
Honored Contributor

Re: HP UX 11.11 + Oracle 9.2.0

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
Honored Contributor

Re: HP UX 11.11 + Oracle 9.2.0

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
Honored Contributor

Re: HP UX 11.11 + Oracle 9.2.0

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Giridhar S
Occasional Advisor

Re: HP UX 11.11 + Oracle 9.2.0

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
Honored Contributor

Re: HP UX 11.11 + Oracle 9.2.0

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
Occasional Advisor

Re: HP UX 11.11 + Oracle 9.2.0

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
Honored Contributor

Re: HP UX 11.11 + Oracle 9.2.0

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
Honored Contributor

Re: HP UX 11.11 + Oracle 9.2.0

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
Occasional Advisor

Re: HP UX 11.11 + Oracle 9.2.0

Yes, oracle was running fine with version 9.2.0.1.
wernerp
Occasional Visitor

Re: HP UX 11.11 + Oracle 9.2.0

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!