Failed to connect to database instance: Failed to connect: java.sql.SQLException: ORA-28040: No matching authentication protocol

Issue:

While configuring a database (12.2) from OEM 12c, the database was added to the monitoring but the status of DB was showing down. And observed below error; also observed “INVALID USERNAME/PASSWORD” sometimes.

Failed to connect to database instance: Failed to connect: java.sql.SQLException: ORA-28040: No matching authentication protocol .

Cause:

The monitoring password in DB could be an issue.

Resolution:

The resolution looks very strange. The username, password of DBSNMP were working fine, able to connect and access from OEM. Tried resetting DBSNMP password to the same password; but didnt help. Tried removing the target from OEM, clearing the state of em agent, emagent bounce etc didnt help. Observed that the user DBSNMP has a profile tagged; Thanks to my colleague Ameer for trying out in the below order and it fixed,

  1. Removed target from OEM
  2. Setting the profile of DBSNMP to default
  3. Password change (to the same pwd) and reassigned the original profile to user
  4. Added back the target to OEM and secure the agent
Advertisements
This entry was posted in Oracle Database. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s