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?

Added on Sep 7 2020

#general-database-discussions

2 comments

11,012 views