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

Last updated on MAY 21, 2015

Applies to:

Oracle Net Services - Version 11.1.0.6 to 11.2.0.3 [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.


Symptoms

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. 

Changes

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.

Cause

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 hundreds of Community platforms