Hi
The error is pretty self explanatory. You need to make sure you can connect to the RDS Oracle instance by SSH.
Check out https://docs.ansible.com/ansible/latest/user_guide/intro_getting_started.html#connecting-to-remote-nodes