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

Breadcrumb

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

Hi,

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
(CONNECTION_ID=XuDEQk4nQUGBhm/R+5Uuvg==)

I also asked the same in : https://stackoverflow.com/questions/73259314/ora-12529-for-connecting-to-oracle-atp-database?noredirect=1#comment129381369_73259314

I really appreciate any help.
Thanks

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:

https://docs.oracle.com/en-us/iaas/autonomous-database-shared/doc/network-access-control-list-configure.html#GUID-B6389402-3F4D-45A2-A4DE-EAF1B31D8E50

Rating

  (1 rating)

Comments

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.

https://blogs.oracle.com/opal/post/writing-nodejs-apps-for-oracle-autonomous-json-database

https://blogs.oracle.com/opal/post/how-to-connect-to-oracle-autonomous-cloud-databases

Hope those helps you.