Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do you run SQL+ with Ansible to run a SQL script on all Oracle databases?

Dear DBA FrankSep 7 2020 — edited Sep 9 2020
Help please: How do you run SQL+ with Ansible to run a SQL script on all Oracle databases? I mean, when Ansible SSHs to the DB server, ORACLE_BASE, ORACLE_HOME, ORACLE_SID etc are not set, so how can it run my SQL script on all databases of that machine?


Comments
Post Details
Added on Sep 7 2020
2 comments
11,012 views