Hi,
I created an "always free" autonomous db + VCN + compute node. on autonomous db, I disabled mTLS and enabled access control list to point my only VCN. compute node is a linux VM and it is in that VCN. now, I am expecting to be able to connect to database from this VM but every time I got “ORA-12506, TNS:listener rejected connection based on service ACL filtering” error.
adding private ip to access control list of ATD is not working but if I add public IP of VM to access control list, then I am able to connect to the database.
I don't understand that. I should be able to connect to db without adding puplic ip address of VM, am I wrong? I created the VCN with defaults. it has Service Gateway, nat, IGW etc. as far as I understand from reading the docs, service gateway will be used to access autonomous db but why I cannot? wht should I check?
thanks.