Can we execute PLSQL programs in ansible ? If we can, how?

Question

PLSQL program execution in asnible ? is there any modules to execute to plsql programs in ansible

Answer 1

I'm absolutely not an oracle expert. But I recently worked with a team that had a project with an oracle database in their stack and helped them automating their deployment (mainly initializing dbs with bootstrap data on fresh deployment of their websphere application).

As you will see on the ansible database modules page, ansible does not (yet...?) provide any module to interact with oracle databases.

What we ended up doing for the project was installing sqlplus on the ansible control machine and other needed hosts, put the plsql scripts under version control as files or templates in our ansible git repo, copy the scripts where needed and play them running sqlplus through shell/command module.

There is an other SO question on the subject (with no upvoted/accepted answer at this time) where you may find more valuable information.