Follow me on Twitter at Twitter.com/wbm
FYI, I'm blogging most of my stuff over at More Wally now.
You might want to add my rss feed to your reader at:http://morewally.com/cs/blogs/wallym/rss.aspx
"RemoteOperationException: ERROR: wrong password for user" with Oracle 10g - Wallace B. McClure

Wallace B. McClure

All About Wally McClure - The musings of Wallym on .NET, Sql, ASP.NET, and other crazy shenanigans

News

Personal Blog

Work Blog

.NET

Book Authors

Business

Family

Friends

Georgia Tech Bloggers

Personal

"RemoteOperationException: ERROR: wrong password for user" with Oracle 10g

Have you gotten the error; "RemoteOperationException: ERROR: wrong password for user" with Oracle 10g?  If so, it is probably because the OS user that you are trying to login to the Oracle Enterprise Manager with has not been setup to allow the user to logon as a "Batch Job."  To resolve this issue:

  1. Go to "Control Panel" -> "Admin Tools" -> "Local Security Policy."
  2. Within "Local Policies", go to user "Right Assignment."
  3. Add the user to "Logon as a Batch Job."

The logon problem should now be resolved.  This is for trying to run Oracle 10g on Windows 2003 Server.

Wally

Posted: Jan 03 2005, 10:57 AM by Wallym | with 94 comment(s)
Filed under:

Comments

Tony Mendicino said:

I had this same issue. Your solution worked perfectly. Thanks.
# January 6, 2005 1:46 PM

charles said:

Yes, guy, thanks a lot.
# October 27, 2006 4:12 PM

Rahul Chaudhari said:

Hi All Gurus, RemoteOperationException: ERROR: Wrong password for user I'm getting the above error while connecting ORACLE 10G database through "Oracle Enterprise Manager" trying to connect to sys user and Host Credentials Please tell me how should i set "Specify the OS user name and password to login to target database machine." it's very urgent me mail to RahulC@infonox.com Thanks and Regards Rahul Chaudhari
# November 7, 2006 1:04 AM

Elliott said:

I don't belive it! I have been trying to sort this problem for 1.5 days!!! It's fixed now. You're a star!!!
# November 7, 2006 6:11 AM

vishal said:

Man you are great...that solved my problem

# November 17, 2006 4:47 AM

Walter said:

Bingo!

Thanks for the fix.

# November 27, 2006 5:16 PM

Si said:

worked for me too.  many thanks

# December 13, 2006 4:40 AM

ashcan said:

I pasted the error into google.  You're page came up.  Perfect Directions and I got that wonderful warm feeling you get from instant gratification.  Bless you.  This dumbfounded me.  I am aware now.  Thx.

trash

# December 15, 2006 12:28 AM

Mariano said:

Beautiful. Thanks a lot, you saved me a lot of time.

# December 27, 2006 3:34 PM

hj said:

My computer is connecting by domanin,I installed the oracle 10g on my local pc but wheb I try to start/shut down the db I get this error:RemoteOperationException: ERROR: Wrong password for user.

I tried few times what you wrote but it dosent work.

if someone can help...

# January 18, 2007 10:47 AM

Gilles said:

THanks alot works for XP too

# January 26, 2007 3:05 AM

Jeff said:

Thanks, this helped me a lot. I was really worried there was something more obscure or difficult happening. But does this fix only work when accessing 10g from the same computer? What about when accessing remotely?

# February 1, 2007 5:45 PM

Prasshant said:

Thanks for the tip. this baled me out of the error

# February 7, 2007 9:30 AM

jlee said:

Great solution. Thanks a lot.

# February 12, 2007 3:16 PM

morbac said:

THANKS ALOT FOR THIS TRICK !!

YOU'RE MY HERO !!!!

# February 14, 2007 11:48 AM

ERROR said:

first time something worked so quick

# February 27, 2007 10:07 AM

joydeep said:

Thanks wally your suggestion worked like charm.

# February 28, 2007 11:58 AM

core said:

i have the same probelm.. i done the local policy settings.. while i trying to recover the databse then it shows the error

Error in Restoring Control File

Recovery Manager: Release 10.1.0.2.0 - Production Copyright (c) 1995, 2004, Oracle. All rights reserved. RMAN> connected to target database: orcl (not mounted) using target database controlfile instead of recovery catalog RMAN> executing command: SET CONTROLFILE AUTOBACKUP FORMAT RMAN> 2> 3> 4> allocated channel: oem_restore channel oem_restore: sid=160 devtype=DISK Starting restore at 04-DEC-07 recovery area destination: D:\oracle\product\10.1.0\flash_recovery_area database name (or lock name space) used for search: ORCL channel oem_restore: no autobackups found in the recovery area autobackup ���������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������search outside recovery area not attempted because DBID was not set released channel: oem_restore RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 12/04/2007 18:49:12 RMAN-06172: no autobackup found or specified handle is not a valid copy or piece RMAN> Oracle instance shut down RMAN> connected to target database (not started) Oracle instance started database mounted Total System Global Area 171966464 bytes Fixed Size 787988 bytes Variable Size 145488364 bytes Database Buffers 25165824 bytes Redo Buffers 524288 bytes RMAN> Recovery Manager complete. ������������������������������������������������������������������������������������������������������������������������������

plz help..

# March 13, 2007 9:25 AM

kv said:

great help..... was really upset with thiis error... the solution worked so smooth ...

# March 20, 2007 9:09 AM

Roman said:

thanks, this worked perfectly!

# March 27, 2007 10:29 AM

This does not work! said:

It makes no difference if the user name is defined or not

# April 5, 2007 3:48 AM

Stephanie Beach said:

It was a good try but it does not work for me either.

I also made sure my user was a member of the ORA groups....all of them actually.

Any further clues?

# May 7, 2007 2:03 PM

njsden said:

Simple and effective!  My local database (10g R2) runs on Windows XP and the solution you described resolved the issue in a snap.

Thanks so much!

# May 27, 2007 12:07 AM

M. Ramesh kumar said:

I had the same err. With your I solved the problem. I indeed thank you so much.
# May 28, 2007 10:28 PM

abbie said:

pls can you tell me how to solve this problem on redhat 3.

# June 7, 2007 10:24 AM

EM ile veri taban?? a??ma kapatma i??lemi « Oracle Kamp?? said:

Pingback from  EM ile veri taban?? a??ma kapatma i??lemi « Oracle Kamp??

# July 3, 2007 5:23 PM

Naveen said:

Hi I have installed Oracle 10g Enterprise edition on Windows XP Professional... and i dont find Local Security Policies.... please guide to solve this issue

# July 30, 2007 8:06 PM

Dan said:

Still I am getting:

Error Message

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 31 12:24:12 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> SQL> ERROR: ORA-12560: TNS:protocol adapter error  

# July 31, 2007 6:30 AM

Mayur said:

You are a genious...hats off to you. I am no DBA, but this helped real good. Thank you very much

# August 2, 2007 10:05 AM

yoga said:

Thanks a lot wally

# August 3, 2007 5:54 AM

smith said:

Great!Your posting helped me to solve my issue.

Smith

# August 7, 2007 9:51 PM

honnee said:

thanks a lot! i solve the problem now.

# August 9, 2007 10:51 AM

Daryll said:

Thank you, this fix worked perfectly!

# August 12, 2007 9:36 PM

Kevin said:

fantastic.. couldn't work this out for a long time.. worked perfectly!

# August 14, 2007 4:08 PM

Loga said:

Its working .Thanks a lot.

# August 16, 2007 5:55 AM

sayeed said:

great! worked for me! you rock!

# August 22, 2007 4:24 PM

raghu said:

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Aug 28 11:54:12 2007

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Enter user-name: system

Enter password: ******

ERROR:

ORA-01034: Message 1034 not found; No message file for product=RDBMS,

facility=ORA

ORA-27101: Message 27101 not found; No message file for product=RDBMS,

facility=ORA

i have installed 10g in vista and i couldnt login into sql plus as it says the above message when i was dng my installation i set my password as oracle so plz et me know wats the username and wats the password to do my queries in sql i even tried scott n tiger,sys n system with oracle i couldntget that plz help me out bya raghu

# August 28, 2007 11:57 AM

Dan said:

Talk about a confidence-building reply section...oh yeah...it worked for me too, and you rock!

# September 12, 2007 5:18 PM

raj said:

I have windowx XP Professional and I installed Oracle 10g. I got the same problem. I did the same thing as you explained above. But, it does not work. Do you have any other solution, please?

# September 15, 2007 8:25 AM

raj said:

I can not connect to the database through the Enterprises Manager in Oracle 10g. The error is 'cannot find the server or DNS error'. How can I resolve  this problem? Please advise me if you know this problem

# September 15, 2007 8:33 AM

Bin said:

Brilliant, well deserved google ranking!

# September 20, 2007 5:02 AM

Bodya said:

Thanks a lot!!! it's working!!!

# October 1, 2007 5:08 AM

Martin said:

Perfect! Tanks from Italy!!!

# October 6, 2007 2:07 PM

Uma said:

Great!!! Just couldn't any info from metalink!! It said this is a 10g Release 1 issue and has been solved in Release 2, just a lie!! It happened on release 2 for me, not sure why.

You r a genious, had spent about three fourth of a day trying to resolve this, your tips, just worked in a tick. Thank you so much, saved a lot of time.

# October 7, 2007 9:46 PM

Kunjan Pandey said:

its working.

thanks lot

# October 16, 2007 5:33 AM

MaxK said:

Thanks a lot!!!!!!!

# October 18, 2007 8:41 PM

zubairi said:

great man............... i had been trying to resolve it long long time........ cheersssssssss

# November 28, 2007 4:56 AM

abdelrahamn said:

thank you very mush

i have no words to express my happienss

# November 29, 2007 7:58 AM

Koya said:

Thanks a lot :)

u r the champ...!!!

# November 30, 2007 8:29 AM

tanthuyhoang said:

thank to Wally so much

# December 7, 2007 4:10 AM

juhi said:

hey im facing same problem on vista home edition

welll im not able to find the local security policy section anywhere here on vista ,,,,,many forum say it is already enabled on vista

but still not working

welll can u help

# January 3, 2008 7:13 AM

Martin Novacheck said:

Great help, thank you :-)

# January 10, 2008 7:10 AM

rtm said:

Worked straight off, why didn't i find this 2 days ago. Wally, I love you and want to have your babies.

# January 23, 2008 6:20 PM

Ghawas said:

Thx Buddy. You reminded me.

# January 27, 2008 12:51 PM

ms said:

Thank You. I was stuck , and this solved my issue

# February 9, 2008 7:40 PM

hlhamduc said:

Ok my God,

Thank you so much

# February 27, 2008 3:03 AM

Krishna said:

Excellent! It was like finding an oasis when you are left in Sahara :-).

Thanks a lot!

# February 28, 2008 7:11 AM

E said:

Wow - nice job on this.  Pooped up in google as the first response and it worked great.  I added my domain user name to the windows 2003 server and no problems.

# February 28, 2008 10:36 AM

Joy said:

Thank you for posting this... I was in agony until I saw it. Solved my problem...

# March 1, 2008 7:04 PM

Prinal said:

Excellent stuff...worked like magic mate! You are a star!!

# March 9, 2008 8:50 PM

mlastra said:

Thanks very much, I lost a whole morning dealing with that issue, god bless you and google.

# March 10, 2008 12:05 PM

Andreas said:

yep it worked for me too.

but don't forget to add your domain name before your login name, like this

DOMAINNAME\LOGINNAME

otherwise it won't work

# April 9, 2008 4:42 AM

david said:

raj

this solution works well, pls make sure your account name is accordance with the name in domain and with domain\acount name.

-David.

# April 14, 2008 5:44 AM

Sumit said:

Hi,

I am facing same problem on vista home edition.

I am not able to find the local security policy section anywhere here on vista home edition.

Pls help me in this....

Thanks..

# April 15, 2008 1:16 PM

Garry said:

Will this user be for the full domain name and username?

# April 18, 2008 12:36 PM

flux-wizard said:

yup, it works for me too!!thanks!

# April 21, 2008 4:41 AM

John said:

Heh, come to DC, and I'll buy ya a beer.  Worked 3 hours on this damn thing right after a server hardening.  Gotta watch for GPO's that will prevent it even though they are allowed in the Local Policy.

# April 25, 2008 4:49 PM

William Sim said:

Thx for the solution.. saved me alot of time to troubleshoot why my instance cant start.

cheers..

# May 20, 2008 10:56 PM

kris said:

Thanks Wally!

Your solution saved a lot of time.

# May 28, 2008 4:18 AM

ravi said:

great....good solution...thx a lot.....

# May 29, 2008 4:59 PM

Alper DAGLI said:

Thank you so much.

# June 9, 2008 10:46 AM

mannoj said:

re: "RemoteOperationException: ERROR: wrong password for user" with Oracle 10g

and i had done adding my user name to 'log on as batch jobs', Still the same issue...

I can even pay if some one rectifies it...

mannoj87@hotmail.com

Regards,

Mannoj

# July 10, 2008 6:19 AM

Chris I said:

Blimey, it worked!

# July 29, 2008 5:56 PM

Vaibhav said:

Hey .. Thanks a lot .. I was wondering how to get this work .. After searching a lot, i was finally able to find this solution .. Thanks !!!!

# August 1, 2008 3:07 AM

abosede talabi said:

it works perfectly well.

thanks.

# August 1, 2008 11:57 AM

Garfield said:

Thanx a million this worked perfectly.

# August 5, 2008 8:48 AM

Chau Huynh said:

Thanks so much for your advice.

# August 12, 2008 6:11 AM

Carlo Henrico said:

Thanks Waly, you're a star!!!

# August 13, 2008 9:09 AM

BP said:

It's amazing. You're super star.Woaaaaa.....

# September 10, 2008 11:38 PM

PCM said:

It worked!!!

Many many many thanks!!

# September 13, 2008 3:19 AM

Kenosi said:

Wow! Thanks.Works perfectly

# September 29, 2008 11:36 AM

4hourswrongpassword said:

muchos gracias.  we got it fixed because of this.  took me 4 hrs to realize i should just search for the error online.

# October 2, 2008 8:19 PM

Jose (Brazil) said:

TERRIFIC !!! Thank you very much !

# October 3, 2008 10:03 AM

Caesar W. Were Auma said:

Thanks a big deal.  Has worked so smoothly, unbelievable.  Uve solved a problem ave been havin for the last two weeks...

# October 10, 2008 8:13 AM

Radu - ecommy.com said:

Thank you for your solution. I was struggling to get it work since yesterday.

# November 11, 2008 8:54 AM

bil123 said:

merci, cela m'a économisé beaucoup du temps.

# November 19, 2008 8:43 AM

Sanat KUmar said:

I had done

Go to "Control Panel" -> "Admin Tools" -> "Local Security Policy."

Within "Local Policies", go to user "Right Assignment."

Add the user to "Logon as a Batch Job."

but it is giving me the same error.

please cooperate

thanks in advance

# November 22, 2008 12:07 AM

Sanat KUmar said:

many many thanks

I t worked for me.

regards

s k swain

# November 22, 2008 1:47 AM

Milan said:

I`ll repeat most of people which commented this solution and i`ll say BIG THANKS!!

# December 11, 2008 9:28 AM

abdel-khaliq zubaidi said:

Daaaaamn

a lot of thanks to u man

u help me a lot in the company ...uuuuuuuuuuu

# December 27, 2008 1:51 PM

SUNNY said:

Thank you for your help!It worked well

# January 14, 2009 4:41 AM

Tony said:

Dude, you are life saver.

# February 18, 2009 9:33 AM

Unknown said:

This works great for WIndows XP Professional too with 10.2 Oracle DB. Thanks a lot for providing the solution.

# February 22, 2009 1:22 AM

Yaw said:

I tried it but it doesn't work for me.  I've installed oracle 10g on a DC.  I've added my account to the 'log on as batch job' but still doesn't work.

While login in I used domainname\username with password but still doesn't work.

Is there a way out or oracle is just not okay on windows.

Please help!!

# May 15, 2009 12:20 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)