Quick Search:
 Oracle Database Error: ORA-01017      [Return To Oracle Error Index] Jump to:  
Oracle Error: ORA-01017

Error Description:
Invalid username/password; login denied

Error Cause:
An invalid username or password was entered in an attempt to log on to Oracle.

The username and password must be the same as was specified in a GRANT CONNECT statement. If the username and password are entered together, the format is: username/password.

Enter a valid username and password combination in the correct format.

If this error is encountered when no username or password have been specified (i.e. when trying to use operating system authentication) then operating system authentication may not have been set-up correctly. In this case, consult the notes for ORA-01004: default username feature not supported.

Also check that the initialization parameter 'REMOTE_OS_AUTHET' has been explicitly set to 'TRUE'.

If this error is encountered when a username and/or password have been specified then the cause is likely to be one of the following:

  • Check that an Oracle account has been created for the specified username.
  • Check that the Oracle account is not 'OPS$...'. If it is then Oracle is using operating system authentication for the account. Try logging in specifying no username or password. In this case the NT account name must be the same as the Oracle account name (less the 'OPS$').
  • If the Oracle account exists and the account is not named 'OPS$...' then the password must be incorrect.

There haven't been any comments added for this error yet. You may add one if you like.  Add a comment 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org