oravirt/ansible-oracle-modules

oracle_db fails with DB < 19c

Opened this issue · 1 comments

While running oradb-manage-db in a 12.2 home I get:

TASK [oradb-manage-db : manage-db | create/manage database] ******************** fatal: [server1012]: FAILED! => {"changed": false, "msg": "Something went wrong while executing sql_get - ORA-00904: \"SUPPLEMENTAL_LOG_DATA_SR\": invalid identifier sql: select SUPPLEMENTAL_LOG_DATA_MIN,SUPPLEMENTAL_LOG_DATA_PL,SUPPLEMENTAL_LOG_DATA_SR,SUPPLEMENTAL_LOG_DATA_PK,SUPPLEMENTAL_LOG_DATA_UI from v$database"}

See https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-DATABASE.html#fnsrc_d1671548e1705.

Could you please make oracle_db backward compatible to 12c again? Or did I miss something?

Kind Regards,
Dietmar

Is fixed with PR #147