ORA-01017 Invalid Username/Password Error in Oracle – Complete Step-by-Step Fix

ORA-01017 Invalid Username/Password Error in Oracle – Complete Fix

If you are facing the ORA-01017: invalid username/password; logon denied error in Oracle Database, don’t worry. This is one of the most common login errors, and it can be resolved with the right steps.

In this guide, we will explain the causes of this error and provide step-by-step solutions to fix it in Oracle 11g, 12c, and higher versions.

Error Message

ORA-01017: invalid username/password; logon denied

What Causes ORA-01017 Error?

This error occurs when Oracle cannot authenticate the user. Below are the most common reasons:

• Incorrect username or password
• Case-sensitive password mismatch
• User account is locked
• Password has expired
• Wrong connection string or service name
• Using incorrect authentication method

Step-by-Step Solutions

1. Verify Username and Password

The first and most obvious step is to check your login credentials.

conn username/password

Make sure:

• No typing mistakes
• No extra spaces
• Correct username

2. Check Case Sensitivity

Oracle passwords are case-sensitive. If your password was created using uppercase or lowercase letters, you must enter it exactly the same.

Example:

conn scott/Tiger   -- Wrong
conn scott/tiger   -- Correct

3. Unlock User Account

If the account is locked due to multiple failed login attempts, you need to unlock it.

ALTER USER username ACCOUNT UNLOCK;

You can check account status using:

SELECT username, account_status FROM dba_users;

4. Reset User Password

If you are unsure about the password, reset it:

ALTER USER username IDENTIFIED BY new_password;

After resetting, try logging in again.

5. Check Password Expiry

If the password is expired, Oracle will not allow login.

Reset it using:

ALTER USER username IDENTIFIED BY new_password;

6. Verify Connection String

If you are connecting using TNS or a connection string, ensure it is correct.

Example:

sqlplus username/password@ORCL

Make sure:

• Service name is correct
• Listener is running

7. Check Authentication Method

If your database uses OS authentication or external authentication, ensure you are using the correct login method.

Real-World Example

A user tried to connect using:

conn hr/HR123

But the password was actually hr123. Since Oracle is case-sensitive, login failed with ORA-01017.

After correcting the password, the issue was resolved.

Common Mistakes to Avoid

• Using uppercase instead of lowercase passwords
• Forgetting to unlock user account
• Not checking password expiry
• Incorrect TNS/service name

Best Practices

• Always store credentials securely
• Avoid multiple failed login attempts
• Regularly update passwords
• Monitor user account status

Frequently Asked Questions (FAQ)

Q1: Why does ORA-01017 occur?
It occurs due to incorrect username or password or account-related issues.

Q2: Can I bypass this error?
No, you must correct credentials or unlock/reset the account.

Q3: How do I check if the account is locked?
Use: SELECT username, account_status FROM dba_users;

Related Oracle Errors

• ORA-01194 File 1 needs more recovery – Solution
• ORA-01555 Snapshot Too Old – Solution
• ORA-28001: Password Expired in Oracle

👉 Check our complete guide: Oracle Error Codes Guide