Home » SQL & PL/SQL » Client Tools » Can't run SQL Plus from non administrator windows user
icon5.gif  Can't run SQL Plus from non administrator windows user [message #304148] Tue, 04 March 2008 05:20 Go to next message
SilverChi
Messages: 17
Registered: September 2006
Junior Member
Hi members..

I've facing some problem to run sql plus. When I log on as Users (not as Administrator(s)) on my Windows XP, i can't run the sql plus tool which installed from oracle client installation. Then, i try to run it from command line, but it still doesn't work.
In my machine, the Oracle Home was set to d:\Oracle\ora92; which PATH variable containts :
- D:\oracle\ora92\bin
- C:\Program Files\Oracle\jre\1.3.1\bin
- C:\Program Files\Oracle\jre\1.1.8\bin

I haven't found this problem when i log on my machine as Administrators.
Is it something wrong with my machine setting or somthing else?


Regards..
Re: Can't run SQL Plus from non administrator windows user [message #304150 is a reply to message #304148] Tue, 04 March 2008 05:31 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What type of error are you getting?

What is the output of the following when you are logged in as a non-administrator:

C:\>path
C:\>echo %oracle_home%
Re: Can't run SQL Plus from non administrator windows user [message #304164 is a reply to message #304148] Tue, 04 March 2008 06:48 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
SilverChi wrote on Tue, 04 March 2008 12:20
but it still doesn't work.

Are you a developer?
If your customer comes up to you and he says "your application, it doesn't work", what's the first thing you ask?
Re: Can't run SQL Plus from non administrator windows user [message #304165 is a reply to message #304150] Tue, 04 March 2008 06:48 Go to previous messageGo to next message
SilverChi
Messages: 17
Registered: September 2006
Junior Member
The output is :

C:>path
PATH=D:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;
etc..

C:>echo %oracle_home%
%oracle_home%


is there any privillege setting on windows XP to allow Users to run standard oracle tools?

regards..
Re: Can't run SQL Plus from non administrator windows user [message #304166 is a reply to message #304165] Tue, 04 March 2008 06:53 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You still haven't told us the error message you get.........
Re: Can't run SQL Plus from non administrator windows user [message #304167 is a reply to message #304164] Tue, 04 March 2008 06:57 Go to previous messageGo to next message
SilverChi
Messages: 17
Registered: September 2006
Junior Member
to Frank

Are you a developer?
nope..

If your customer comes up to you and he says "your application, it doesn't work", what's the first thing you ask?
i'm not sure.., maybe i'll ask the is system specification met the application requirements..


to ThomasG

when i try to run sql plus using start menu, the err msg are :
"The application failed to initialize properly (0xc00000222)"

[Updated on: Tue, 04 March 2008 07:03]

Report message to a moderator

Re: Can't run SQL Plus from non administrator windows user [message #304168 is a reply to message #304167] Tue, 04 March 2008 07:02 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
SilverChi wrote on Tue, 04 March 2008 13:57
to Frank

Are you a developer?
nope..

If your customer comes up to you and he says "your application, it doesn't work", what's the first thing you ask?
i'm not sure.., maybe i'll ask the is system specification met the application requirements..

Nope.
You'd ask him what exactly happens. What error message he gets, you ask him to define "doesn't work".
I wanted to show you that you have to be clear in your problem-report.
Re: Can't run SQL Plus from non administrator windows user [message #304172 is a reply to message #304168] Tue, 04 March 2008 07:16 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The "The application failed to initialize properly (0xc00000222)" error seems to be a general Windows error that mostly happens when the user hasn't got read/execute permissions on the needed *.exe and *.dll files.

Like this Google turned up.
Re: Can't run SQL Plus from non administrator windows user [message #304452 is a reply to message #304172] Wed, 05 March 2008 04:46 Go to previous message
SilverChi
Messages: 17
Registered: September 2006
Junior Member
Nice advice..,

i've assumed that access permisions was set by ora client installation, but it's not.
i set those permision for Users group, and my problem solved.


Regards..
Previous Topic: externaly identified
Next Topic: Access violation
Goto Forum:
  


Current Time: Thu Dec 08 16:40:21 CST 2016

Total time taken to generate the page: 0.06386 seconds