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 messageGo to next message
EdStevens
Messages: 1282
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.
Re: connect sql developer without the tns file [message #678641 is a reply to message #677929] Mon, 23 December 2019 13:26 Go to previous messageGo to next message
wvu1999
Messages: 40
Registered: April 2007
Member

Yes.https://stackoverflow.com/questions/49337989/how-can-i-connect-to-oracle-database-with-sqlcl-and-sqlplus-but-without-a-tnsna

Use the basic connection type and just define your connection manually.
Re: connect sql developer without the tns file [message #678643 is a reply to message #678641] Mon, 23 December 2019 14:34 Go to previous message
EdStevens
Messages: 1282
Registered: September 2013
Senior Member
wvu1999 wrote on Mon, 23 December 2019 13:26
Yes.https://stackoverflow.com/questions/49337989/how-can-i-connect-to-oracle-database-with-sqlcl-and-sqlplus-but-without-a-tnsna

Use the basic connection type and just define your connection manually.
Which is pretty much what I told the OP two months ago!
Previous Topic: sql developer connection using jdbc:vjdbc:servlet connection url
Next Topic: sqlplus && DBMS_OUTPUT.PUT_LINE doesn't work ?
Goto Forum:
  


Current Time: Sun Nov 29 02:13:51 CST 2020