Oracle Database Console Credential Failures on Windows

There is an error message in Oracle Database console:

Connection to host as user USER failed: ERROR: Wrong password for user

Usually you find this error when trying to connect to host, for example, you want to start/shutdown, or backup the database. It had confused me for a long time. Then I found an solution.

1. Provide the 'Log on as a batch job' privilege.

• Go to control panel/administrative tools
• click on "local security policy"
• click on "local policies"
• click on "user rights assignments"
• double click on "log on as a batch job"
• click on "add" and add the user(s) that you're going to use in database console.

2. Set credentials and test

• Go to the Preferences link in the database console page
• click on Preferred Credentials (link on the left menu)
• under "Target Type: Host" click on "set credentials"
• enter the OS user(s) for whom you have set "logon as a batch job" privilege
• click on "Test"

Then you should see the backup is working.