Home » SQL & PL/SQL » Client Tools » connect sql developer without the tns file (SQL Developer 19.2.1.247.2212)
connect sql developer without the tns file [message #677929] Thu, 24 October 2019 03:51 Go to next message
samhita
Messages: 1
Registered: October 2019
Junior Member
Hi,

I have SQL Developer 19.2.1.247.2212 with with Oracle 11.1.0 database client. I am trying to create a new connection but it keeps giving below error:

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

Is there any way to resolve this error without modifying the tnsnames.ora file?

I want to know if we can connect sql developer without the tns file.

Thanks
Re: connect sql developer without the tns file [message #677933 is a reply to message #677929] Thu, 24 October 2019 06:37 Go to previous message
EdStevens
Messages: 1148
Registered: September 2013
Senior Member
samhita wrote on Thu, 24 October 2019 03:51
Hi,

I have SQL Developer 19.2.1.247.2212 with with Oracle 11.1.0 database client. I am trying to create a new connection but it keeps giving below error:

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

Is there any way to resolve this error without modifying the tnsnames.ora file?

I want to know if we can connect sql developer without the tns file.

Thanks
Why do you not want to modify your tnsnames, whenit is obviously incorrect?
As to your question, make your connection type 'basic' instead of 'tns'. Then the input window changes and your input fields are 'host', 'port', and 'sid' or 'service'. You have to provide your own values to override the provided (and most likely incorrect) values. Use service name instead of sid.
Previous Topic: How to spool the data of a clob or long column
Next Topic: sql developer connection using jdbc:vjdbc:servlet connection url
Goto Forum:
  


Current Time: Mon Dec 09 08:45:18 CST 2019