New Role: SAP on Oracle DB - SBP Update

[nsolthe]

It would be great if the SAP Bundle Patch updates delivered by SAP could be applied using ansible. This would be great to make updates during non-working hours.

[sean-freeman]

@nsolthe Good use case, but there is very limited Oracle DB experience within the core development team, it is unlikely automation of MOPatch will be a priority.

For your use case, can you make something work from the existing Ansible Role sap_anydb_install_oracle ?

It includes the following sample code inserting into the response files:

• /assistants/dbca/dbca.rsp Default sample of automated response (config) file for Oracle Database Configuration Assistant (DBCA)
• /assistants/netca/netca.rsp Default sample of automated response (config) file for Oracle Net Configuration Assistant (NetCA)
• /install/response/db_install.rsp Default sample of automated response (config) file for Oracle DB Installation
• /inventory/response/oracle.server_EE.rsp Default sample of automated response (config) file for Oracle DB Installation Enterprise Edition (EE)

And there is an empty file waiting for someone to contribute Ansible Tasks for MOPatch: sap_anydb_install_oracle/tasks/oracledb_install_post_mopatch.yml

[nsolthe]

@sean-freeman Thanks for giving me some hints on this. I will try to look into it further and make some changes as soon as possible.