topic Re: Oracle Environment Setup in Operating System - HP-UX

Oracle Environment Setup

Zeng Qing yong — Tue, 28 Mar 2000 08:32:28 GMT

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

Re: Oracle Environment Setup

Willaim Hart — Tue, 28 Mar 2000 12:50:33 GMT

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

Re: Oracle Environment Setup

Zeng Queyon — Wed, 29 Mar 2000 07:42:33 GMT

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

Who can help?

Queyon

Re: Oracle Environment Setup

Amran Bin Md Said — Tue, 13 Jun 2000 07:08:07 GMT

try giving the user dba group. I think maybe it could be ue to permission

Re: Oracle Environment Setup

Steven Sim Kok Leong — Tue, 13 Jun 2000 07:57:09 GMT

Hi,

Perhaps you would want to try relinking the executables again.

Regards.

STeven Sim.

Re: Oracle Environment Setup

Nagaraj Dandeboyina — Fri, 30 Jun 2000 12:28:59 GMT

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

Re: Oracle Environment Setup

Anthony_4 — Thu, 10 Aug 2000 04:53:41 GMT

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

Re: Oracle Environment Setup

Carl Roberts — Thu, 10 Aug 2000 14:58:24 GMT

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

Jennifer LaFene — Thu, 10 Aug 2000 23:10:33 GMT

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