1748179 Members
4016 Online
108759 Solutions
New Discussion юеВ

Re: 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 18
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...