After Upgrade to 11g: Client or DBLink Connections Yield ORA-12504
Last updated on OCTOBER 19, 2017
Applies to:Oracle Net Services - Version 22.214.171.124 to 126.96.36.199 [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.
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