Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 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.

Action:
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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 111 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?