oravirt / ansible-oracle-modules

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

oracle_db: fixed ORA-00904: invalid identifier sql: select SUPPLEMENTAL_LOG_DATA_MIN #147

Closed Rendanic closed 2 years ago

jschampera commented 3 years ago

In the current structure it sets slcomp/alter respecting the module parameter, but it never compares the slcomp to the current state. Result is that it force-sets the state regardless of the current config in the database.

The fix would be to compare supp_logcheck[0][0] to YES/NO in the if/else supplemental_logging == True part to set/execute the alter sql. And removing the slcomp stuff everywhere.

Sorry for not writing a patch.