Home » Infrastructure » Unix » sqlplus: Permission denied (Oracle 10g, Sun 5.10)
sqlplus: Permission denied [message #379717] Wed, 07 January 2009 14:42 Go to next message
prashanthgs
Messages: 83
Registered: May 2005
Location: chennai
Member
Hello

I have installed Oracle Client 10.2.0.1.0 in SUN OS 5.10.

Logged in as Oracle user

While I am trying to execute sqlplus in oracle home I am getting below error.

cnc.sop.com% cd $ORACLE_HOME
cnc.sop.com% sqlplus
sqlplus: Permission denied

But while trying from $ORACLE_HOME/bin I am able to do so

cnc.sop.com% cd $ORACLE_HOME/bin
cnc.sop.com% sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jan 7 15:40:08 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name:

Whats the problem?

Thanks

Prashanth




Re: sqlplus: Permission denied [message #379718 is a reply to message #379717] Wed, 07 January 2009 14:46 Go to previous messageGo to next message
Michel Cadot
Messages: 59293
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try "which sqlplus" in first case.

Regards
Michel
Re: sqlplus: Permission denied [message #379719 is a reply to message #379718] Wed, 07 January 2009 15:00 Go to previous messageGo to next message
prashanthgs
Messages: 83
Registered: May 2005
Location: chennai
Member
I am getting the below one.


cnc.sop.com%% which sqlplus
no sqlplus in /usr/bin .

Re: sqlplus: Permission denied [message #379720 is a reply to message #379719] Wed, 07 January 2009 15:10 Go to previous messageGo to next message
joy_division
Messages: 4520
Registered: February 2005
Location: East Coast USA
Senior Member
That should answer your question.

Note that when you try to execute a command in unix and there is a directory with that name, this is the error message you will get.

-

Oh, I left out that it looks like you never set up (at least some of) your environment variables (ie. PATH).

[Updated on: Wed, 07 January 2009 15:13]

Report message to a moderator

Re: sqlplus: Permission denied [message #379729 is a reply to message #379719] Wed, 07 January 2009 16:00 Go to previous messageGo to next message
prashanthgs
Messages: 83
Registered: May 2005
Location: chennai
Member
But I set the path in .login as below and executed.

/opt/oracle/product/10.2.0.1.0/bin:/opt/oracle/product/10.2.0.1.0/OPatch:/usr/bin:/usr/local/bin:/usr/ccs/bin:/usr/sbin:/usr/openwin/ bin:/bin:/usr/dt/bin:/usr/sbin/X11:/usr/java14/bin:.


But still I am getting same error.

Re: sqlplus: Permission denied [message #379737 is a reply to message #379717] Wed, 07 January 2009 17:02 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
post the results from the following commands
env | sort
back here after getting the error in the title.
Re: sqlplus: Permission denied [message #379739 is a reply to message #379737] Wed, 07 January 2009 17:22 Go to previous message
prashanthgs
Messages: 83
Registered: May 2005
Location: chennai
Member
Thanks for your reply.

I have modified the PATH as

setenv PATH /opt/oracle/product/10.2.0.1.0/bin:/usr/bin:/usr/sbin:/sbin

Now it worked.
Previous Topic: Problem while installing Oracle 9i on Solaris 10
Next Topic: Substitute a variable inside a variable
Goto Forum:
  


Current Time: Thu Oct 02 01:57:21 CDT 2014

Total time taken to generate the page: 0.06288 seconds