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

The error appears when I tried to connect to the database. And it suggest me to use PING and TNSPING button on the toolbar. But I did not see these buttons.

Session–new connection.

Click tnsnames editor button.

Select an alias in the list to your left side.

Click the yellow “lightning bolt” button - it’s next to the free circle with a white tick in it.

HTH

Cheers,

Norm.

Green circle, not free!

I’m suffering from auto-incorrect!

Sorry.

The dialog that pops up with that suggestion has a toolbar with buttons. One of them should be for Ping and another for tnsping. Mouse over them to read the tool tips so you can see which is which. If that is not what you see please post a screenshot of what it is you see.

Michael

Thanks! That solves my problem.