Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Oracle: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA"
oracbeg
post Jul 26 2017, 06:05 AM
Post #1


Newbie
*

Group: Members
Posts: 2
Joined: 11-July 17
From: india
Member No.: 52,070



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.gif
Go to the top of the page
 
+Quote Post
burleson
post Jul 26 2017, 10:20 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,492
Joined: 26-January 04
Member No.: 13



Hi,

It looks like your tnsnames.ora is missing some entries!

Try this example:

http://www.dba-oracle.com/t_ora_12504_tns_...t_given_sid.htm

Good luck!


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 22nd August 2017 - 02:22 AM