topic Re: Oracle error in Operating System - HP-UX

Oracle error

sreejith_4 — Thu, 24 Feb 2005 09:33:54 GMT

Hi,

Any idea about this error,

# sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Feb 24 19:41:19 2005

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

Enter user-name: system
Enter password:
/usr/lib/pa20_64/dld.sl: Unable to find library 'libodm9.sl'.
ERROR:
ORA-12547: TNS:lost contact

Thanks
Sreejith M

Re: Oracle error

Peter Godron — Thu, 24 Feb 2005 09:40:09 GMT

Hi,
please check your path environment variables.
LD_LIB_PATH,SHLIB_PATH etc.
Can you also try to log on from the oracle unix account. If you do not get the same problem, look at the path variables and copy them to the problem user.
Regards

Re: Oracle error

TwoProc — Thu, 24 Feb 2005 09:40:11 GMT

The file you're looking for is in the ORACLE_HOME/lib directory - so it's not in the shared library paths...

Make sure that environment variables:
SHLIB_PATH is pointing to $ORACLE_HOME/lib32
and LD_LIBRARY_PATH is pointing to $ORACLE_HOME/lib .

The file you're looking for is in the ORACLE_HOME/lib directory - so it's not in the shared library paths...

Re: Oracle error

B. Hulst — Thu, 24 Feb 2005 14:17:54 GMT

Hi,

Try

#su - oracle
% sqlplus -version

If it still complains about missings libraries
then the setup is not correct for either the variables ORACLE_HOME or the shared library called libodm9.sl cannot be found in the search path or is not installed correctly.

The TNS error should not appear during sqlplus -version since it does not connect to the DB instance.

Do a

# find / -name 'libodm9.sl' -print | xargs what

and check if the versions found and printed are for oracle 9.2.0.1.0 ...

Regards,
Bob

Re: Oracle error

Indira Aramandla — Thu, 24 Feb 2005 19:58:39 GMT

Hi Sreejith,

The erro could be due to the setting SHLIB_PATH and LD_LIBRARY_PATH on HP-UX. However, even with the correct settings of these environment variables, dynamic loading of shared libraries can still fail.

Firstly, ensure the library in question exists in the location given. If the library
does not exist, but the location given is correct (ie, it is $ORACLE_HOME), then
take corrective action.

Attached is a document form metalink explains the steps to diagnose the error.

Indira A

Re: Oracle error

sreejith_4 — Fri, 25 Feb 2005 08:56:09 GMT

Hi,

I am able to install and connect to oracle after setting LIB PATH's. Now there is a new issue.
My oracle version is 9.2.0.1. Now i have applied 9.2.0.4 patch and i am getting following error during installation

"error in invoking target oracle of makefile "/oracle/rdbms/lib/ins_rdbms.mk"

I ignored it and completed the installation.
But now i am unable to connect to the oracle using sqlplus. It gives the following error.

# sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Feb 25 19:31:50 2005

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

ERROR:
ORA-12547: TNS:lost contact

Enter user-name:

Please help

Thanks
Sreejith M

Re: Oracle error

B. Hulst — Fri, 25 Feb 2005 10:02:25 GMT

Hi,

If you pasted like that it should be

su - oracle
sqlplus "/ as sysdba"

Regards,
Bob

Re: Oracle error

sreejith_4 — Fri, 25 Feb 2005 10:05:16 GMT

You are correct

I am running it as oracle user only

Re: Oracle error

TwoProc — Fri, 25 Feb 2005 10:10:23 GMT

Try running the following...

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk install

This should get you out of your spot.

Re: Oracle error

B. Hulst — Fri, 25 Feb 2005 10:23:27 GMT

note the space after the / char...

Re: Oracle error

Jean-Luc Oudart — Fri, 25 Feb 2005 11:27:27 GMT

Hi

have you checked the Oracle installation pre-requisites such as kernel parameters, OS patches ?

then you will have to relink the binaries (as mentioned in another post).
What are the rights on the oracle binary
$ORACLE_HOME/bin/oracle ?

Regards
Jean-Luc

Re: Oracle error

Peter Godron — Mon, 28 Feb 2005 11:23:29 GMT

Sreejith,
as to your new problem:
sqlplus /nolog
connect / as sysdba

Regards

Re: Oracle error

sreejith_4 — Wed, 02 Mar 2005 03:25:40 GMT

Hi,

Can anyone tell me the prerequisites for installing Oracle 9.2.0.4 in Hp-UX 11.00
I mean patches...

Thanks
Sreejith M

Re: Oracle error

Fred Ruffet — Wed, 02 Mar 2005 04:41:37 GMT

Place for requirements is here :

http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=169706.1&p_showHeader=1&p_showHelp=1

Note that 9.2.0.4 is *Really* bad choice on 11.00. Have a look at how many patches available for this version on this OS... This will show you how many bugs you can encounter. It is probably safer to go for 9.2.0.5.

Other point, is that you shouldn't run Oracle until your linkage is good. Your error on /oracle/rdbms/lib/ins_rdbms.mk makefile means your oracle kernel is only partially linked. You should hava look in OUI's inventory logs to see what was the error. My 2 cents for a too low maxdsiz kernel parameter :)

Regards,

Fred

Re: Oracle error

Indira Aramandla — Thu, 03 Mar 2005 23:34:32 GMT

Hi Sreejith,

Attached is a document which describes the patches required, kernel parameters for Oracle 9.2. on HP_UX 11.0

And the other thing to consider when installing Oracle 9i on HP-UX 11 are as follows:-

Due to a known HP bug (Doc. id: KBRC00003627), the default HP-UX (64-bit) operating system installation does not create a few required X library symbolic links. These links must be created manually before starting Oracle9i Release 2 installation. To create these links, you must have superuser privileges, as the links are to be created in the /usr/lib directory.

When installing Oracle 9i on HP, the linker will look for libXm.sl,libXt.sl and libX11.sl when compiling the binary 'ctxhx'.

The attached document describes the steps to manually creating the links

Indira A

Re: Oracle error

Indira Aramandla — Thu, 03 Mar 2005 23:36:45 GMT

Here is the linking issue document.

IA

Re: Oracle error

Yogeeraj_1 — Thu, 03 Mar 2005 23:54:32 GMT

hi Sreejith,

this is from metalink note 169706.1 ("HP Patches/Packages")
===========
Per HP Bug (Doc ID: KBRC00003627)
NOTE: This bug is not applicable to 11.22,11.23 The default 64bit OS installation does not create a few required X library symbolic links. The following symbolic links need to be created:
cd /usr/lib
ln -s /usr/lib/libX11.3 libX11.sl
ln -s /usr/lib/libXIE.2 libXIE.sl
ln -s /usr/lib/libXext.3 libXext.sl
ln -s /usr/lib/libXhp11.3 libXhp11.sl
ln -s /usr/lib/libXi.3 libXi.sl
ln -s /usr/lib/libXm.4 libXm.sl
ln -s /usr/lib/libXp.2 libXp.sl
ln -s /usr/lib/libXt.3 libXt.sl
ln -s /usr/lib/libXtst.2 libXtst.sl

HP-UX 11.0(64 bit) Operating System Patches:
Sept 2001 Quality Pack
o PHCO_23792 s/b PHCO_26960
o PHCO_24148 s/b PHCO_25707 s/b PHCO_27608
o PHKL_24268 s/b PHKL_27178 (has been recalled by HP may destroy logical volumes on PVGs - more info
o PHKL_24729 s/b PHKL_29256
o PHKL_25475 s/b PHKL_27510 s/b PHKL_30553
o PHKL_25525 s/b PHKL_27364 s/b PHKL_31867
o PHNE_24715 s/b PHNE_26771 s/b PHNE_29473
o PHSS_23670 s/b PHSS_26138 s/b PHSS_27858
o PHSS_24301 s/b PHSS_26273 s/b PHSS_28433 (only needed for C++ compiler and Pro*C++)
o PHSS_24303 s/b PHSS_26559
o PHSS_24627
o PHSS_22868 (only needed for C++ compiler and Pro*C++)

HP-UX 11i (64 Bit) Operating System Patches:
Support Plus Bundle 'December 2002 SP-0212' or later JDK 1.3.1.02
PHCO_24402 s/b PHCO_25569
PHCO_28427 s/b PHCO_29029 s/b PHCO_31903
PHKL_25506
PHNE_27745 s/b PHNE_30580 (For RAC systems)
PHNE_28568 s/b PHNE_30378
PHSS_26560 s/b PHSS_30966
PHSS_26946
PHSS_28849 (For ServiceGuard 11.13 systems)

hope this helps too!

regards
Yogeeraj

Re: Oracle error

sreejith_4 — Fri, 04 Mar 2005 00:50:56 GMT

Hi,

Linking of the libraries are done already.
But that didn't helped me.

But i have found the solution myself.

I have increased thre maxssize to double of the default value, this is not mentioned in any of the document.

Thanks to all of you for great help

Sreejith M

Re: Oracle error

sreejith_4 — Fri, 04 Mar 2005 00:52:26 GMT

The problem has been resolved after increasing the maxssize