Oracle error

[sreejith_4]

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

[Peter Godron]

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

[TwoProc]

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...

[B. Hulst]

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

[Indira Aramandla]

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

[sreejith_4]

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

[B. Hulst]

Hi,

If you pasted like that it should be

su - oracle
sqlplus "/ as sysdba"

Regards,
Bob

[sreejith_4]

You are correct

I am running it as oracle user only

[TwoProc]

Try running the following...

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

This should get you out of your spot.

[B. Hulst]

note the space after the / char...

[Jean-Luc Oudart]

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

[Peter Godron]

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

Regards

[sreejith_4]

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

[Fred Ruffet]

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

[Indira Aramandla]

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

[Indira Aramandla]

Here is the linking issue document.


IA

[Yogeeraj_1]

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

[sreejith_4]

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

[sreejith_4]

The problem has been resolved after increasing the maxssize