Skip to main content

I can sucessfully connect with PLSQLDeveloper or SQLPlus, not SQLDeveloper.

Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  (CONNECTION_ID=miLJAuX5S8iZ5pBkt7BbRQ==)

 

or

 

Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
  (CONNECTION_ID=CbkJWaHyQPCS5Y84Pun2ww==)

 

Any hints? My Azure VPN is Connected and GlobalProtect Disconnected.

@Alex  two possible issues:

  • you should fill in the Service name as just : alepdb 
    • So nothing in SID only in service name

  • If possible do a ping to your server  j9s71 5g-dev 1-db.build. ifsdemoworld.com to see if you can reach it over your connection. If not, your vpn is not working correctly 

 

Hi @Alex ,

This error can occur due to following reasons.

  1. Sometime, we may go for the wrong destination of the listener, either host or port was incorrect.
  2. Mismatched service name

Service name is wrong I believe but the first screen shot should connect me the same way as PLSQLDeveloper or sqlplus does. Could it be SQLDeveloper is being deliberately blocked?

Reply


Terms & ConditionsCookie settings