Skip to main content
Delphix

Resolving ORA-01017 Error: invalid username/password; logon denied (KBA 4082)

 

KBA

KBA# 4082

The 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.0, 5.1, 5.2, and 5.3.
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. 


 

 


Related Articles

The following articles may provide more information or related information to this article:

  • link