My Oracle Support Banner

Change in Password and Remote Connection Suddenly Yields : ORA-12154 TNS: Unable to Resolve Service Name (Doc ID 291709.1)

Last updated on MARCH 31, 2022

Applies to:

Oracle Net Services - Version 9.2.0.8 to 18.3.0.0.0 [Release 9.2 to 18.1]
Information in this document applies to any platform.

Symptoms

Following a password change or after creating a new user, the following error is thrown repeatedly when attempting to connect:

ORA-12154: TNS: Could not resolve the connect identifier specified

There appears to be no issue with the tnsnames entry and a tnsping of the same service is successful.

It is also possible to connect with a different set of credentials or username/password@alias.

Changes

This is likely the result of the creation of a new user OR the password for the user has been changed recently.
There is an @ symbol in the user's password.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.