Home » RDBMS Server » Networking and Gateways » Oracle: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA" (Windows 10 64 bit)
Oracle: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA" [message #664647] Wed, 26 July 2017 06:09 Go to previous message
oracbeg
Messages: 16
Registered: July 2017
Junior Member
I am posting this after searching whole internet and trying all the solutions getting from there but this error is not letting me go through. I am trying to connect excel 2016 32 bit with oracle 11gr2 64 bit on windows 10 64 bit.

When i connect i get this error

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

Things i have done before it are...

1) Installed oracle client (odbc drivers) 32 bit version
2)set up the tnsnames.ora as

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)


3) Set the environment variable as tns_admin till the directory client_1 as well as setting its path to client_1

4) made the odbc 32 bit connection with tns service name (orcl) and the connection gets successful.


still getting the same error. Please respond if i am missing something or can try anything else. Thanks Smile

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Lsnrctl stop -> database crashes
Next Topic: ORA - 01017 invalid username/password while creating a shared public database link
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 17:28:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.