search

oravirt / ansible-oracle-modules

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

oracle_db fails with DB < 19c #140

Open duhlig opened 4 years ago

duhlig commented 4 years ago

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

Rendanic commented 4 years ago

Is fixed with PR #147