Question

Not able to connect IFS Dev DB from SQLDeveloper

  • 10 November 2023
  • 3 replies
  • 109 views
A
Rank
Userlevel 2
Badge +5
  • Alex
  • Do Gooder (Employee)
  • 12 replies

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.

3 replies

K
Rank
Userlevel 4
Badge +9

@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 

 

K
Rank
Badge +5

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
A
Rank
Userlevel 2
Badge +5

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