OraFAQ Forum: Client Tools » connect sql developer without the tns file

Home » Other » Client Tools » connect sql developer without the tns file (SQL Developer 19.2.1.247.2212)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

connect sql developer without the tns file [message #677929]

Thu, 24 October 2019 03:51

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

Report message to a moderator

Re: connect sql developer without the tns file [message #677933 is a reply to message #677929]

Thu, 24 October 2019 06:37

EdStevens
Messages: 1376
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.

Report message to a moderator

Re: connect sql developer without the tns file [message #678641 is a reply to message #677929]

Mon, 23 December 2019 13:26

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.

Report message to a moderator

Re: connect sql developer without the tns file [message #678643 is a reply to message #678641]

Mon, 23 December 2019 14:34

EdStevens
Messages: 1376
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!

Report message to a moderator

Previous Topic:	sql developer connection using jdbc:vjdbc:servlet connection url
Next Topic:	sqlplus && DBMS_OUTPUT.PUT_LINE doesn't work ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 25 15:58:04 CDT 2025