Home » SQL & PL/SQL » Client Tools » sqlplus doesn't work after revoking admin rights
sqlplus doesn't work after revoking admin rights [message #177573] Thu, 15 June 2006 09:23 Go to next message
J_2006
Messages: 9
Registered: May 2006
Location: claifornia
Junior Member
Hi,

we have an issue here with oracle client.Oracle clients are initially installed on windows xp client machines under user who had admin rights and were running fine.But we have now a situation to revoke all admin rights from the client machines.what steps we have to follow in order to work oracle client on those client machines which we don't have admin rights.

we tried on a single machine(windows xp), but got the following error when I tried a sqlplus from the command prompt,

'sqlplus' is not recognized as an internal or external command, operable program, or batch file


would anybody here helps me to resolve this situation or having me a step by step instruction for revoking admin rights?


Thanks in advance,

J_2006
Re: sqlplus doesn't work after revoking admin rights [message #177574 is a reply to message #177573] Thu, 15 June 2006 09:30 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
The first thing that can be - is that $ORACLE_HOME/bin is not included in PATH. Under command prompt see what PATH have user.
Re: sqlplus doesn't work after revoking admin rights [message #177581 is a reply to message #177573] Thu, 15 June 2006 10:45 Go to previous messageGo to next message
J_2006
Messages: 9
Registered: May 2006
Location: claifornia
Junior Member
Thanks for the quick response aciolac

I checked the path and ORACLE_HOME/bin is already there in the path.

below is the path,

C:\>path
PATH=C:\ClarifyCRM12.5SR1.13\Configurator\Common Files\CCAutomation;C:\ClarifyCR M12.5SR1.13\ClarifyClient;C:\orant_ora9i\bin;C:\Program Files\Oracle\jre\1.3.1\b in;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDO
WS\System32\Wbem;C:\Program Files\ATI Technologies\ATI Control Panel;C:\Program Files\QuickTime\QTSystem\

Re: sqlplus doesn't work after revoking admin rights [message #177582 is a reply to message #177581] Thu, 15 June 2006 11:03 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
As the user, can you simply change directories to that directory?

cd C:\orant_ora9i\bin

If so, do you get an error if you try to run sqlplus from c:\orant_ora9i\bin ?
Re: sqlplus doesn't work after revoking admin rights [message #177592 is a reply to message #177582] Thu, 15 June 2006 11:51 Go to previous messageGo to next message
J_2006
Messages: 9
Registered: May 2006
Location: claifornia
Junior Member
Hi ebrian,

There ya go!!

Got access denied error. looks like administrator has to give me all access for this directory,right?

But I checked on my windows xp professional machine, they are looking bit different

I did follow below steps,

1. Right Click on the Oracle Folder.
2. Select Properties
3. Remove any Read attributes

But didn't find any security tab to confirm that "Users(machinename\users)" is present and it has all rights except Full COntrol.

is this right or do I need to try something else to grant access for this folder?

anything else do i need to try here than giving access to this folder?


Thanks mucho

j_2006


Re: sqlplus doesn't work after revoking admin rights [message #177594 is a reply to message #177592] Thu, 15 June 2006 12:13 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Are you getting access denied simply trying to access the directory or when you actually try to run sqlplus?

Looks like they have the Security tab disabled. You won't need Full Control, but you will need atleast Read & Execute, List Folder Contents & Read permissions.
Re: sqlplus doesn't work after revoking admin rights [message #177606 is a reply to message #177594] Thu, 15 June 2006 13:41 Go to previous messageGo to next message
J_2006
Messages: 9
Registered: May 2006
Location: claifornia
Junior Member
the access denied message is trying to access the directory

thanks again for the updates.will let you know after I get all access to the folders


Thanks a lot,

J-2006
Re: sqlplus doesn't work after revoking admin rights [message #177954 is a reply to message #177606] Sun, 18 June 2006 08:33 Go to previous messageGo to next message
Peter D.
Messages: 19
Registered: June 2006
Location: Warsaw, Poland
Junior Member
Hi,
To enable Security tab you must:

Windows Explorer->Tools->Folder options->View

Disable Use simple file sharing (recommended) option.

Then Security tab should appear.

Peter D.
Re: sqlplus doesn't work after revoking admin rights [message #354903 is a reply to message #177573] Tue, 21 October 2008 23:16 Go to previous messageGo to next message
kili
Messages: 1
Registered: October 2008
Junior Member
It so easy :

Start > My Computer > Right Click Mouse > Properties

Then System Properties will been displayed.

At the System Propertie, click Advanced Tab > Environment Variable

Pop up Environment Variable will been displayed.

Then at the System Variable, search variable PATH and click Edit. Then paste the location bin file like this ;C:\oracle\product\10.2.0\db_1\bin

I was install Oracle 10g, and this is a location my folder bin. See that name is true for 1st before do editing.

[Updated on: Tue, 21 October 2008 23:17]

Report message to a moderator

Re: sqlplus doesn't work after revoking admin rights [message #355024 is a reply to message #354903] Wed, 22 October 2008 05:22 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You are responding to a post that is over 2 years old and apparently, you didn't even read the post.

The PATH variable has already been verified and that was NOT the problem.
Previous Topic: Does isqlplus come with Oracle 11g installation?
Next Topic: Connecting Mapics From Oracle
Goto Forum:
  


Current Time: Mon Dec 05 08:59:29 CST 2016

Total time taken to generate the page: 0.14470 seconds