ansible-oracle-modules icon indicating copy to clipboard operation
ansible-oracle-modules copied to clipboard

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

Open duhlig opened this issue 5 years ago • 2 comments

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.

duhlig avatar Jan 17 '20 10:01 duhlig

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!

oravirt avatar Jan 28 '20 17:01 oravirt

No problem. There's no rush.

KR, Dietmar

duhlig avatar Jan 28 '20 19:01 duhlig