search

oravirt / ansible-oracle-modules

Oracle modules for Ansible
MIT License
214 stars 159 forks source link

New module oracle_sqldba for "sqlplus / as sysdba" and catcon.pl #124

Open duhlig opened 4 years ago

duhlig commented 4 years ago

This PR should contain commit 031b16a only. But it contains other unrelated commits covered by PR #122 and #123. Sorry for that.

There were some requests for oracle_sql connecting password-less, i.e. "/ as sysdba". I see these requests in a wider context. I needed to group post-installation (and up to DB 12.1 also post-patch) tasks. They are a mixture of sql scripts, sql commands, and catcon calls. So I created a new module "oracle_sqldba". This module contains a loosely related feature: to execute a sql query and return the results in a python dict. Examples are in the module's comments section.

The module definitely needs testing. But at least it workes for my purposes.

oravirt commented 4 years ago

Hi, I'm sorry I haven't gotten back to you regarding this PR.

I really appreciate you taking the time to contribute, and I'll look at this as soon as I can but I'm completely swamped at the moment (and have been for a while).

I'll get back to you as soon as I can.

Thanks!

duhlig commented 4 years ago

No problem. There's no rush.

KR, Dietmar