Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

New questions about Oracle

Wang,MinJie
Super Advisor

New questions about Oracle

Hey, it's me again.
I've installed Oracle Client on one system.
Please have a look at the following stuff:
$ sqlplus /nolog
/usr/lib/pa20_64/dld.sl: Unable to find library 'libclntsh.sl.10.1'.
Memory fault(coredump)
$

and I found that I got 'libclntsh.sl.10.1' in another directory
What can I do now and how can I connect to the server which is running now

PS:When I "conn / as sysdba" on the server,who on earth do I log as? ( sys as default?)

Thankyou
10 REPLIES
Peter Godron
Honored Contributor

Re: New questions about Oracle

Hi,
welcome back.
For starters check your env:
env | grep ORA
for ORACLE_HOME and ORACLE_SID.
Then check your PATHS
env | grep PATH
The important ones are something like:
SHLIB_PATH=/u01/app/oracle/product/10g/lib:/usr/dt/lib:/usr/lib
LD_LIBRARY_PATH=/u01/app/oracle/product/10g/lib:/usr/dt/lib:/usr/lib

You nomally would use the conn / as sysdba as the oracle user.
Warren_9
Honored Contributor

Re: New questions about Oracle

hi,

Please check the following env variables is configured correctly.

LD_LIBRARY_PATH
SHLIB_PATH

it should point to the $ORACLE_HOME/lib

GOOD LUCK!!
Wang,MinJie
Super Advisor

Re: New questions about Oracle

OK,
then the problems came:
$ sqlplus
/usr/lib/pa20_64/dld.sl: Unsatisfied code symbol 'gethrtime' in load module '/or
acle/u01/app/oracle/product/lib/libclntsh.sl.10.1'.
Abort(coredump)

???
Peter Godron
Honored Contributor

Re: New questions about Oracle

Hi,
could you please provide output from:

which sqlplus
echo $ORACLE_HOME
env | grep SHLIB_PATH
env | grep LD_LIBRARY_PATH

Yogeeraj_1
Honored Contributor

Re: New questions about Oracle

hi,

when you connect as "/ as sysdba", is it ok?

revert

kind regards
yogeeraj

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Wang,MinJie
Super Advisor

Re: New questions about Oracle

Hey Peter
Here is the information you want
I hope it will help you solve my problem
# echo $ORACLE_HOME
/oracle/u01/app/oracle/product
# echo $SHLIB_PATH
/oracle/u01/app/oracle/product/lib:/usr/dt/lib:/usr/lib
# echo $LD_LIBRARY_PATH
/oracle/u01/app/oracle/product/lib:/usr/dt/lib:/usr/lib
#
Yogeeraj_1
Honored Contributor

Re: New questions about Oracle

hi,

your env is as required, i.e.

LD_LIBRARY_PATH=/lib:/usr/dt/lib:/usr/lib; export LD_LIBRARY_PATH

SHLIB_PATH=/lib:/usr/dt/lib:/usr/lib; export SHLIB_PATH

can you confirm your sqlplus version?

As a last recourse, i would suggest that you relink your oracle executables

regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Ed Ulfers
Frequent Advisor

Re: New questions about Oracle

If running HP-UX 11.XX, simple item to check (from HP Document KBRC00013432 and Oracle Installation documents).
Several operating system libraries are not fully accessable, and soft links are needed.
Here is a list of the libraries I typically add to having their "*.sl" extensions soft-linked in /usr/lib : libX11.3, libXIE.2, libXext.3, libXhp11.3, libXi.3, libXm.4, libXp.2, libXt.3, libXtst.2 .
I would also suggest relinking the Oracle.
Best luck,
-- Ed
Put a smile on your users face, offer them a kiss (Hershey's Kiss).
Victor Fridyev
Honored Contributor

Re: New questions about Oracle

Hi,

May be, you have installed 64-bit Oracle on 32-bit machine.
Check this by
#> getconf KERNEL_BITS

If this is OK, try to relink ORACLE by
Enter the following Unix commands:
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk install

From Oracle 8i one can also use the "relink" command in the $ORACLE_HOME/bin directory.

HTH
Entities are not to be multiplied beyond necessity - RTFM
Peter Godron
Honored Contributor

Re: New questions about Oracle

Hi,
could you please update the thread with the latest status.