cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle error

sreejith_4
Frequent Advisor

Oracle error

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

18 REPLIES
Peter Godron
Honored Contributor

Re: Oracle error

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

Re: Oracle error

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...
We are the people our parents warned us about --Jimmy Buffett
B. Hulst
Trusted Contributor

Re: Oracle error

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

Re: Oracle error

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


Never give up, Keep Trying
sreejith_4
Frequent Advisor

Re: Oracle error

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

Re: Oracle error

Hi,

If you pasted like that it should be

su - oracle
sqlplus "/ as sysdba"

Regards,
Bob
sreejith_4
Frequent Advisor

Re: Oracle error

You are correct

I am running it as oracle user only
TwoProc
Honored Contributor

Re: Oracle error

Try running the following...

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

This should get you out of your spot.
We are the people our parents warned us about --Jimmy Buffett
B. Hulst
Trusted Contributor

Re: Oracle error

note the space after the / char...
Jean-Luc Oudart
Honored Contributor

Re: Oracle error

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
fiat lux
Peter Godron
Honored Contributor

Re: Oracle error

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

Regards
sreejith_4
Frequent Advisor

Re: Oracle error

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

Re: Oracle error

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

"Reality is just a point of view." (P. K. D.)
Indira Aramandla
Honored Contributor

Re: Oracle error

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
Never give up, Keep Trying
Indira Aramandla
Honored Contributor

Re: Oracle error

Here is the linking issue document.


IA
Never give up, Keep Trying
Yogeeraj_1
Honored Contributor

Re: Oracle error

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

Re: Oracle error

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

Re: Oracle error

The problem has been resolved after increasing the maxssize