OraFAQ Forum: Client Tools » Can't run SQL Plus from non administrator windows user

Home » Other » Client Tools » Can't run SQL Plus from non administrator windows user

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

Can't run SQL Plus from non administrator windows user [message #304148]

Tue, 04 March 2008 05:20

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..

Report message to a moderator

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

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%

Report message to a moderator

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

Frank
Messages: 7901
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?

Report message to a moderator

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

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..

Report message to a moderator

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

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

You still haven't told us the error message you get.........

Report message to a moderator

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

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

Frank
Messages: 7901
Registered: March 2000

Senior Member

SilverChi wrote on Tue, 04 March 2008 13:57

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.

Report message to a moderator

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

ThomasG
Messages: 3211
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.

Report message to a moderator

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

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..

Report message to a moderator

Previous Topic:	externaly identified
Next Topic:	Access violation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 01:12:44 CDT 2024