Skip to Main Content
  • Questions
  • Error in connecting to ATP from SQL Developer ORA-12529: TNS:connect request rejected based on current filtering rules


Question and Answer

Chris Saxon

Thanks for the question, Pavel.

Asked: August 07, 2022 - 12:58 am UTC

Last updated: August 08, 2022 - 12:57 pm UTC

Version: 19c

Viewed 100+ times

You Asked


I created my free tier ATP database. For connecting it from SQLDeveloper I downloaded the wallet file.
However I allways get this error when try to connect from SQLDeveloper:

Estado: Fallo:Fallo de la prueba: Listener refused the connection with the following error:
ORA-12529, TNS:connect request rejected based on current filtering rules

I also asked the same in :

I really appreciate any help.

and Chris said...

The network is denying you access to the database.

This could be because the wallet has been rotated - try downloading the wallet again to check it works.

If that doesn't solve it, check if any network access control lists have been configured that prevent you connecting:


  (1 rating)


Few more inputs from OCI team.

Rajeshwaran, Jeyabal, August 08, 2022 - 2:51 pm UTC

Here are the few links from the OCI team about establishing the connection using wallet (mTLS) & wallet less connections (1-way TLS) and EZconnect too.

Hope those helps you.