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 1000+ 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)

Is this answer out of date? If it is, please let us know via a Comment

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.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.