Home » SQL & PL/SQL » SQL & PL/SQL » SQLPLUS login problem URGENT !!!
SQLPLUS login problem URGENT !!! [message #206685] Fri, 01 December 2006 01:49 Go to next message
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.
Re: SQLPLUS login problem URGENT !!! [message #206686 is a reply to message #206685] Fri, 01 December 2006 02:05 Go to previous messageGo to next message
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
Re: SQLPLUS login problem URGENT !!! [message #206688 is a reply to message #206685] Fri, 01 December 2006 02:11 Go to previous messageGo to next message
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?
Re: SQLPLUS login problem URGENT !!! [message #206700 is a reply to message #206685] Fri, 01 December 2006 02:58 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
This is not an Oracle question!
type ./sqlplus

. is (often) not in the path
Re: SQLPLUS login problem URGENT !!! [message #206729 is a reply to message #206717] Fri, 01 December 2006 04:55 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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????
Re: SQLPLUS login problem URGENT !!! [message #206745 is a reply to message #206737] Fri, 01 December 2006 05:54 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
To what value did you set ORACLE_HOME?
Re: SQLPLUS login problem URGENT !!! [message #206746 is a reply to message #206737] Fri, 01 December 2006 05:59 Go to previous messageGo to next message
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?
Re: SQLPLUS login problem URGENT !!! [message #206755 is a reply to message #206685] Fri, 01 December 2006 06:30 Go to previous messageGo to next message
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.
Re: SQLPLUS login problem URGENT !!! [message #206759 is a reply to message #206685] Fri, 01 December 2006 06:48 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 !!!
Re: SQLPLUS login problem URGENT !!! [message #206781 is a reply to message #206764] Fri, 01 December 2006 07:41 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Yupps Have a nice One Cool
Re: SQLPLUS login problem URGENT !!! [message #206789 is a reply to message #206685] Fri, 01 December 2006 08:19 Go to previous messageGo to next message
joy_division
Messages: 4643
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.
Re: SQLPLUS login problem URGENT !!! [message #207074 is a reply to message #206685] Mon, 04 December 2006 01:38 Go to previous messageGo to next message
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.
Re: SQLPLUS login problem URGENT !!! [message #207077 is a reply to message #207074] Mon, 04 December 2006 01:49 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You just tried, without changing anything and it worked ?!
Re: SQLPLUS login problem URGENT !!! [message #207116 is a reply to message #207077] Mon, 04 December 2006 03:45 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I suspect a PEBKAC problem.
Re: SQLPLUS login problem URGENT !!! [message #207119 is a reply to message #207116] Mon, 04 December 2006 03:55 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
sounds suspiciously so..
Previous Topic: how to dynamically access members of a record structure..
Next Topic: Getting OS info in PLSQL
Goto Forum:
  


Current Time: Fri Dec 09 11:32:21 CST 2016

Total time taken to generate the page: 0.11028 seconds