Resolving ORA-01017 Error: invalid username/password; logon denied (KBA4082)
KBA
KBA# 4082The page describes how to resolve ORA-01017: invalid username/password; logon denied.
At a Glance
ORA Error: | ORA-01017: invalid username/password; logon denied |
---|---|
OERR: | 01017, 00000, "invalid username/password; logon denied" // *Cause: // *Action: |
Affects ME versions: | This issue affects all Masking Versions: 4.x, 5.x, 6.x |
Root Cause: | 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. |
Solution: | Test the Connector using the UI and verify the username and password. If required, enter a valid username and password. |
Issue
The masking engine failed to connect to the database due to an invalid username or password.
Resolution
In the masking UI, open the Environment and then the Connector page and select the connector for this masking job. Use the Test Connector at the bottom of the screen.
Please verify that:
- SID is correct.
- Username is correct.
- Use SQLPlus and test the username and password for this database.
- Re-enter the password on the connector page.
If there are any errors above that can't be resolved you might need to contact your DBA.