My Oracle Support Banner

Discoverer Plus / Viewer 11g Fails With Error TNS error, ORA-12154 or ORA-12504 or ORA-12170 (Doc ID 870422.1)

Last updated on JANUARY 26, 2018

Applies to:

Oracle Discoverer - Version and later
Oracle Net Services - Version to [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 10-Feb-2019***


Discoverer Plus/Viewer 11g (11.1.1.X) connection fails with a TNS error similar to those listed below.

These errors is displayed on the Discoverer connection page even though a TNSNAMES alias is defined in the tnsnames.ora file located in the $ORACLE_HOME/network/admin directory.


A connection error.
- Failed to connect to database - ORA-12154: TNS:could not resolve the connect identifier specified


A connection error.
- Failed to connect to database - ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA


A connection error.
- Failed to connect to database - ORA-12170:TNS:Connect time out occurred




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.