My Oracle Support Banner

After Upgrade to 11g: Client or DBLink Connections Yield ORA-12504 (Doc ID 1442597.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Net Services - Version to [Release 11.1 to 11.2]
Information in this document applies to any platform.
The problem described in this document would arise after an upgrade of a client from any pre-11g release to 11g and where that client is using the HOSTNAME naming adapter to connect to a listener of an earlier version.
For example, an 11gR2 client using the HOSTNAME adapter method to connect to a 10gR2 listener.


Following an upgrade of a client to 11g, the following error is thrown at connect time:

ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

The client is using the HOSTNAME naming adapter to connect.

This error would also occur in the case of a DBLink where the origin or source database uses the HOSTNAME adapter and is connecting to a target listener that is 10g or earlier. 


An upgrade from a pre-11g client to 11gR1 or newer has taken place and that client is relying on  the HOSTNAME naming adapter for TNS resolution.


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

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

In this Document

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