OraFAQ Forum: SQL & PL/SQL » SQLPLUS login problem URGENT !!!

Home » SQL & PL/SQL » SQL & PL/SQL » SQLPLUS login problem URGENT !!!

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

SQLPLUS login problem URGENT !!! [message #206685]

Fri, 01 December 2006 01:49

ramesh_samane
Messages: 63
Registered: May 2006

Member

I am trying to login to SQLPLUS from unix command prompt. I am in /oracle/product/10.2.0/bin directory where I have sqlplus.

$ ls -l sqlplus
-rwxr-xr-x 1 oracle dba 8816 Aug 29 21:36 sqlplus

$ file sqlplus
sqlplus: ELF 64-bit MSB executable SPARCV9 Version 1, dynamically linked, not stripped

But when I try to invoke sqplus, I get following message:

$ sqlplus /nolog
ksh: sqlplus: not found

Any ideas why this is happening.

Thanks,

Ramesh.

Report message to a moderator

Re: SQLPLUS login problem URGENT !!! [message #206686 is a reply to message #206685]

Fri, 01 December 2006 02:05

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

type the "env" command
And see that you really have every path set correctly

Report message to a moderator

Re: SQLPLUS login problem URGENT !!! [message #206688 is a reply to message #206685]

Fri, 01 December 2006 02:11

ramesh_samane
Messages: 63
Registered: May 2006

Member

I am in the directory where sqlplus executable is located and I am invoking sqlplus from there itself. Do I need to set ORACLE_HOME or any other variable?

Report message to a moderator

Re: SQLPLUS login problem URGENT !!! [message #206700 is a reply to message #206685]

Fri, 01 December 2006 02:58

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Well i guess, you have to set up it someting like this

export ORACLE_HOME=/u01/app/oracle/product/9.2.0
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32
export ORACLE_SID=mysid

might be diffrent for you like depeding on 32 or 64 bit
lib32 or lib

LD_LIBRARY_PATH or LD_LIBRARY_PATH_64

[Updated on: Fri, 01 December 2006 03:01]

Report message to a moderator

Re: SQLPLUS login problem URGENT !!! [message #206717 is a reply to message #206700]

Fri, 01 December 2006 03:48

Frank
Messages: 7901
Registered: March 2000

Senior Member

This is not an Oracle question!
type ./sqlplus

. is (often) not in the path

Report message to a moderator

Re: SQLPLUS login problem URGENT !!! [message #206729 is a reply to message #206717]

Fri, 01 December 2006 04:55

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Frank wrote on Fri, 01 December 2006 10:48

This is not an Oracle question!
type ./sqlplus

. is (often) not in the path

Ok, well I belive that all the paths has to be set correctly.
Otherwise you should get somethin like this
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory, even if you're standing in the bin dir.

[Updated on: Fri, 01 December 2006 04:56]

Report message to a moderator

Re: SQLPLUS login problem URGENT !!! [message #206737 is a reply to message #206685]

Fri, 01 December 2006 05:28

ramesh_samane
Messages: 63
Registered: May 2006

Member

I have set ORACLE_HOME, ORACLE_SID, LD_LIBRARY_PATH but still I am getting the error. Also I verified that .msb file is there at proper location.

The message I am getting is as below:

Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Any guess????

Report message to a moderator

Re: SQLPLUS login problem URGENT !!! [message #206745 is a reply to message #206737]

Fri, 01 December 2006 05:54

Frank
Messages: 7901
Registered: March 2000

Senior Member

To what value did you set ORACLE_HOME?

Report message to a moderator

Re: SQLPLUS login problem URGENT !!! [message #206746 is a reply to message #206737]

Fri, 01 December 2006 05:59

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Are you logged in as Oracle or as a differnt user ?
if not .. have you checked the file permissions?

Report message to a moderator

Re: SQLPLUS login problem URGENT !!! [message #206755 is a reply to message #206685]

Fri, 01 December 2006 06:30

ramesh_samane
Messages: 63
Registered: May 2006

Member

ORACLE_HOME is set to 10.x.x.x directory under oracle directory. That could not be a problem. I am not logging in as "oracle" user. I am logging in as some other unix user but all the permissions are proper. .msb file is readable. sqlplus is executable etc. for the user I am logging in.

Report message to a moderator

Re: SQLPLUS login problem URGENT !!! [message #206759 is a reply to message #206685]

Fri, 01 December 2006 06:48

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Hmm im not convinced

Are you sure that the rights are

chmod -R 755 $ORACLE_HOME/sqlplus ?

Anyway to verfy that ?

Also
As the non-Oracle user, run the truss utility to find out which files are being accessed. Sample command:
truss -aefo /tmp/truss_sqlplus.out sqlplus username/password

Use this truss_sqlplus.out trace file to see what files have error "EACCES" when attempting to access

[Updated on: Fri, 01 December 2006 06:50]

Report message to a moderator

Re: SQLPLUS login problem URGENT !!! [message #206764 is a reply to message #206685]

Fri, 01 December 2006 06:59

ramesh_samane
Messages: 63
Registered: May 2006

Member

I will try that tahpush on Monday. Leaving for the day now.

Thank you very much all you Guys for the suggestions. I really appreciate.

Have an exciting weekend. CHEERS !!!

Report message to a moderator

Re: SQLPLUS login problem URGENT !!! [message #206781 is a reply to message #206764]

Fri, 01 December 2006 07:41

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Yupps Have a nice One Cool

Cool

Report message to a moderator

Re: SQLPLUS login problem URGENT !!! [message #206789 is a reply to message #206685]

Fri, 01 December 2006 08:19

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

This is so urgent that it can now wait until Monday? Me thinks that this really is not so urgent.

Report message to a moderator

Re: SQLPLUS login problem URGENT !!! [message #207074 is a reply to message #206685]

Mon, 04 December 2006 01:38

ramesh_samane
Messages: 63
Registered: May 2006

Member

I tried once again today and am successful. Thanks again all of you for your time and suggestions.

- Ramesh.

Report message to a moderator

Re: SQLPLUS login problem URGENT !!! [message #207077 is a reply to message #207074]

Mon, 04 December 2006 01:49

Frank
Messages: 7901
Registered: March 2000

Senior Member

You just tried, without changing anything and it worked ?!

Report message to a moderator

Re: SQLPLUS login problem URGENT !!! [message #207116 is a reply to message #207077]

Mon, 04 December 2006 03:45

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

I suspect a PEBKAC problem.

Report message to a moderator

Re: SQLPLUS login problem URGENT !!! [message #207119 is a reply to message #207116]

Mon, 04 December 2006 03:55

Frank
Messages: 7901
Registered: March 2000

Senior Member

sounds suspiciously so..

Report message to a moderator

Previous Topic:	how to dynamically access members of a record structure..
Next Topic:	Getting OS info in PLSQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 02 06:36:45 CDT 2026