cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Environment Setup

Zeng Qing yong
Occasional Contributor

Oracle Environment Setup

I'm trying to setup a new user to be able to access the database. Under this
user, when run "TNSPING ", it returns the error message:

tnsping: error in loading shared libraries: libclntsh.so.8.0: cannot open
shared object file: No such file or directory

But I've set
LD_LIBRARY_PATH=${ORACLE_HOME}/lib
and the file 'libclntsh.so.8.0' is accessable by the user in ${ORACLE_HOME}/lib
directory.

Who can help?

Queyon
8 REPLIES
Willaim Hart
Advisor

Re: Oracle Environment Setup

is your tns listener running?

you can check this using the command lsnrctl

at prompt type status

if not running type start.

then exit to quit.

regards,

bill
Zeng Queyon
Occasional Visitor

Re: Oracle Environment Setup

Thank you, Willaim. But when I tried 'lsnrctl', it returned the same error as
'tnsping'.

Who can help?

Queyon
Amran Bin Md Said
Occasional Visitor

Re: Oracle Environment Setup

try giving the user dba group. I think maybe it could be ue to permission
Steven Sim Kok Leong
Honored Contributor

Re: Oracle Environment Setup

Hi,

Perhaps you would want to try relinking the executables again.

Regards.

STeven Sim.
Email: steven@beepz.com. Homepage: https://www.beepz.com
Nagaraj Dandeboyina
Occasional Advisor

Re: Oracle Environment Setup

Hi,
try to setup the following envinronment variables in user profile
ORACLE_HOME=
export ORACLE_HOME
ORACLE_BASE=/oracle/app/oracle
export ORACLE_BASE
ORACLE_SID=ORCL
export ORACLE_SID
SHLIB_PATH=$ORACLE_HOME/lib
export SHLIB_PATH
PATH=$PATH:$ORACLE_HOME/bin/
export PATH

Can you check the following.

1.oratab file under /etc
2.::N
by default it is no,if you make yes by putting Y in place of N,and setting the above variables you can start listner.

3.First check whether ur database is running or not.
4.If it running OK,then setup all the above and try,with this you can use dbstart and dbshut to start and ahutdown the database.OK.

Hope this will solve ur problem.

HAPPY ADMIN.

-Nagaraj
Everybody is ignorant, only on different subjects
Anthony_4
Advisor

Re: Oracle Environment Setup

Hi, maybe you'd better relink executables for oracle, I met such error before.
Carl Roberts
Occasional Visitor

Re: Oracle Environment Setup

Those libraries are the client libraries that can get re-created at install. You can regenerate them, then link the listener again.

Carl

Re: Oracle Environment Setup

I went out to Oracle Metalink and found that there exists a patch for this problem. You must contact your local Oracle Support Center. You will see two separate threads I copied from the metalink. In this is the bug no. is 1102548 and you must request a patch for this bug. I hope this helps.



Thread Status: Closed

From: Roopa Seshadri 03-Dec-99 21:32
Subject: lsnrctl error in loading shared libraries


lsnrctl error in loading shared libraries

I'm getting:

sqlplus: error in loading shared libraries:
/home/oracle/product/8.1.5./lib/libclntsh.so.8.0: undefined symbol: nauzaoss

I installed Oracle 8.i on a fresh install of SUSE 6.2 (glibc 2.1) and the install of Oracle went
fine. The svrmgrl program works but SQL*Plus (and I suspect other Oracle modules) is reporting the

above error.





--------------------------------------------------------------------------------

From: Oracle, Chandra Adithya 06-Dec-99 11:38
Subject: Re : lsnrctl error in loading shared libraries


Hi,
Can you please post the version of sql*plus you are trying to install ??
This will be helpful in simulating and working on this problem.
regards,
Adithya.





--------------------------------------------------------------------------------

From: Roopa Seshadri 06-Dec-99 15:32
Subject: Re : lsnrctl error in loading shared libraries


The version of SQL Plus is "SQL*Plus: Release 8.1.5.0.0 ".
We are not having a problem with SQL Plus.

I am unable to start the listener in the server.

It reports the foll. error :
lsnrctl: error in loading shared libraries: libclntsh.so.8.0: cannot open shared object file: No such file or directory.

All the ORACLE variables and PATH are set. svrmgrl and sqlplus work fine.





--------------------------------------------------------------------------------

From: Oracle, Chandra Adithya 07-Dec-99 07:17
Subject: Re : Re : lsnrctl error in loading shared libraries


Hi,
You are hitting bug #1102548 and fix is available.
Please contact your local support center for the patch.

regards,
Adithya



Thread Status: Closed

From: jboix@baf.es 14-Jul-00 15:57
Subject: nauzaoss


nauzaoss

I work whith PHP3, APACHE, ORACLE 8i 8.1.5 For linux Suse 6.2. And i have a problem, someone tels me that i need the PATCH number #1102548 And y don`t find it.

In sqlplus i have the message :
Sqlplus: error in loading shared libraries
/opt/oracle/product/8.1.5/lib/libclntsh.so.8.0:
undefined simbols : nauzaoss.




--------------------------------------------------------------------------------

From: madhumathi nalla 14-Jul-00 18:17
Subject: Re : nauzaoss


I think its something related to PATH variable in UNIX,
check whether PATH variable has $ORACLE_HOME/lib, if not include it and try again.


HTH




--------------------------------------------------------------------------------

From: Oracle, Anil Shenoy 17-Jul-00 06:42
Subject: Re : nauzaoss


Hi,
Please refer a document below which addresses some of the issues
related to Oracle8i Enterprise Edition under LINUX platform.


Oracle 8i Standard Edition for LINUX FAQ

For further assistance please please in "Unix Installation/OS: RDBMS Technical Forum" as questions related to Installation are handled
in that forum.

Thanks & Regards,
Anil





--------------------------------------------------------------------------------

From: jboix@baf.es 17-Jul-00 12:43
Subject: Re : nauzaoss


it seems that we need a patch for the bug #1102548.



--------------------------------------------------------------------------------

From: Oracle, Anil Shenoy 17-Jul-00 13:08
Subject: Re : nauzaoss


Hi,
If you require patch for the bug 1102548 please contact local
support center by giving reference to the bug no.

Regards,
Anil