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

99 Comments

• I had this same issue. Your solution worked perfectly. Thanks.
  

• Yes, guy, thanks a lot.
  

• 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
  

• 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!!!
  

• Man you are great...that solved my problem
  

• Bingo!
  Thanks for the fix.
  

• worked for me too. many thanks
  

• 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
  

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

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

• THanks alot works for XP too
  

• 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?
  

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

• Great solution. Thanks a lot.
  

• THANKS ALOT FOR THIS TRICK !!
  
  YOU'RE MY HERO !!!!
  

• first time something worked so quick
  

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

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

• thanks, this worked perfectly!
  

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

• 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?
  

• 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!
  

• I had the same err. With your I solved the problem. I indeed thank you so much.
  

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

• 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
  

• 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
  

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

• Thanks a lot wally
  

• Great!Your posting helped me to solve my issue.
  Smith
  

• thanks a lot! i solve the problem now.
  

• Thank you, this fix worked perfectly!
  

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

• Its working .Thanks a lot.
  

• 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
  
  

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

• 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?
  

• 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
  

• Brilliant, well deserved google ranking!
  

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

• Perfect! Tanks from Italy!!!
  

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

• its working.
  thanks lot
  

• Thanks a lot!!!!!!!
  

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

• thank you very mush
  i have no words to express my happienss
  

• Thanks a lot :)
  u r the champ...!!!
  

• thank to Wally so much
  

• 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
  

• Great help, thank you :-)
  

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

• Thx Buddy. You reminded me.
  

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

• Ok my God,
  
  Thank you so much
  

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

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

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

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

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

• 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
  

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

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

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

• yup, it works for me too!!thanks!
  

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

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

• Thanks Wally!
  Your solution saved a lot of time.
  

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

• Thank you so much.
  

• 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
  

• Blimey, it worked!
  

• 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 !!!!
  

• it works perfectly well.
  thanks.
  

• Thanx a million this worked perfectly.
  

• Thanks so much for your advice.
  

• Thanks Waly, you're a star!!!
  

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

• It worked!!!
  Many many many thanks!!
  

• Wow! Thanks.Works perfectly
  

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

• TERRIFIC !!! Thank you very much !
  

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

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

• many many thanks
  
  I t worked for me.
  
  regards
  
  s k swain
  

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

• Daaaaamn
  a lot of thanks to u man
  u help me a lot in the company ...uuuuuuuuuuu
  

• Thank you for your help!It worked well
  

• Dude, you are life saver.
  

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

• 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!!
  

• thanks, you are a genius!!
  

• Hey,
  
  Thanks! Helped me a lot.
  
  Regards,
  Kaarthiik
  

• Thanks a zillion. It solved the problem
  

• Great hint you have given Wally.. I appreciate the effort that you have taken !!! Kudos!!!
  

• Yes this works. Thankx for this great help. Pls continue such type of articales........!
  

• Thanks. that worked!
  

• Just one word.... WONDERFUL
  

• thanx a tonnnnnnnnnnn it works
  

• Appeared first in the search & exact solution..BINGO.. Worked for 100s of ppl..
  
  Thanks A Lot..
  
  Asutosh Rout
  

• Thanks for the solution. Bang on target!!!