Last post Feb 02, 2014 04:43 AM by Franklin Chen - MSFT
Jan 31, 2014 04:51 AM|vsp.santu|LINK
This is PL\SQL Issue.
When we want connect to toad, we are getting an error as below. Anybody have an idea on this. Please share your ideas.
Error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Thanks in advance for your help.
Feb 01, 2014 04:13 AM|rajesh93180|LINK
In your TNSNAMES.Ora file, is the connection you want to connect in this way?
Feb 02, 2014 04:43 AM|Franklin Chen - MSFT|LINK
You can try this solution:
I had this issue and the fix was to make sure in tnsnames.ora the SERVICE_NAME is a valid service name in your database. To find out valid service names, you can use the following query in oracle:
select value from v$parameter where name='service_names'
Once I updated tnsnames.ora to:
(ADDRESS = (PROTOCOL = TCP)(HOST = *<validhost>*)(PORT = *<validport>*))
(SERVER = DEDICATED)
(SERVICE_NAME = *<servicenamefromDB>*)
then I ran: