OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » sqlplus error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlplus error [message #8610]

Wed, 03 September 2003 20:57

Dushm
Messages: 11
Registered: September 2002

Junior Member

I am am unable to connect to sqlplus i get the following Error :
ld.so.1: /net/srjcd-dev/opt/oracle8/bin/sqlplus: fatal: libjava.so: open failed: No such file or directory

I have set my LD_LIBRARY_PATH,ORACLE_HOME and TNS_ADMIN paths correctly.

% echo $ORACLE_HOME
/net/srjcd-dev/opt/oracle8
% echo $LD_LIBRARY_PATH
/net/srjcd-dev/opt/oracle8/lib
% echo $TNS_ADMIN
/net/srjcd-dev/opt/oracle/network/admin

Any help is greatly appreciated.

Thanks.

Report message to a moderator

Re: sqlplus error [message #8616 is a reply to message #8610]

Thu, 04 September 2003 07:06

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

try these
export SHLIB_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/jdbc/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32:$SHLIB_PATH

Report message to a moderator

Re: sqlplus error [message #8622 is a reply to message #8616]

Thu, 04 September 2003 12:39

Dushm
Messages: 11
Registered: September 2002

Junior Member

Thanks Mahesh for your suggestion. I got this working after adding $ORACLE_HOME/jre/1.1.8/lib/sparc/native_threads to the LD_LIBRARY_PATH .

Report message to a moderator

Previous Topic:	How to do display a 'SELECT *' in a PL/SQL ?
Next Topic:	ORA-03113: end-of-file on communication channel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 07:02:59 CDT 2024