feat: sap_swpm Possibility to use tenant sid different then HANA-DB #1066
Description
Ansible Role
sap_swpm
OS Family
RHEL
Feature/Enhancement request
It would be nice, to have the possibility to specify the sid for the hana tenant.
For use in multi tenant systems this would be very helpful.
Possible solution:
add sap_swpm_sid_tenant in defaults/main.yml
########################################
# SWPM Ansible Role variables
# for Default Mode
# - SAP NetWeaver
########################################
sap_swpm_sid: ""
sap_swpm_sid_tenant: ""
sap_swpm_ascs_instance_nr: ""
sap_swpm_ascs_instance_hostname: ""
sap_swpm_ers_instance_nr: ""
sap_swpm_ers_instance_hostname: ""
sap_swpm_pas_instance_nr: ""
sap_swpm_pas_instance_hostname: ""
sap_swpm_aas_instance_nr: ""
sap_swpm_aas_instance_hostname: ""
change templates/inifile_params.j2:
- NW_HDB_getDBInfo.dbsid = {{ sap_swpm_sid_tenant | d(sap_swpm_db_sid) }}
- NW_Recovery_Install_HDB.extractLocation = /usr/sap/{{ sap_swpm_db_sid }}/HDB{{ sap_swpm_db_instance_nr }}/backup/data/DB_{{ sap_swpm_sid_tenant | d(sap_swpm_db_sid) }}
###################################################################
# BEGIN section db_connection_nw_hana #
# #
NW_HDB_getDBInfo.dbhost = {{ sap_swpm_db_host }}
NW_HDB_getDBInfo.dbsid = {{ sap_swpm_sid_tenant | d(sap_swpm_db_sid) }}
NW_HDB_getDBInfo.instanceNumber = {{ sap_swpm_db_instance_nr }}
NW_HDB_getDBInfo.systemid = {{ sap_swpm_db_sid }}
NW_HDB_getDBInfo.systemPassword = {{ sap_swpm_db_system_password }}
# NW_HDB_getDBInfo.systemDbSid = SystemDB
NW_HDB_getDBInfo.systemDbPassword = {{ sap_swpm_db_systemdb_password }}
NW_HDB_DB.abapSchemaName = {{ sap_swpm_db_schema_abap }}
NW_HDB_DB.abapSchemaPassword = {{ sap_swpm_db_schema_abap_password }}
NW_HDB_DB.javaSchemaName = {{ sap_swpm_db_schema_java }}
NW_HDB_DB.javaSchemaPassword = {{ sap_swpm_db_schema_java_password }}
NW_Recovery_Install_HDB.extractLocation = /usr/sap/{{ sap_swpm_db_sid }}/HDB{{ sap_swpm_db_instance_nr }}/backup/data/DB_{{ sap_swpm_sid_tenant | d(sap_swpm_db_sid) }}
NW_Recovery_Install_HDB.extractParallelJobs = {{ sap_swpm_parallel_jobs_nr }}
NW_Recovery_Install_HDB.sidAdmName = {{ sap_swpm_db_sid | lower }}adm
NW_Recovery_Install_HDB.sidAdmPassword = {{ sap_swpm_db_sidadm_password }}
# NW_HDB_getDBInfo.dbadmin = SYSTEM
# NW_HDB_getDBInfo.tenantOsGroup = {{ sap_swpm_db_sid | lower }}grp
# NW_HDB_getDBInfo.tenantOsUser = {{ sap_swpm_db_sid | lower }}usr
# NW_HDB_getDBInfo.tenantPort =
# #
# END section db_connection_nw_hana #
###################################################################
Community participation
Happy to help with this feature, but may need help (e.g. first time contributing to open-source using git)
Optional - Attempted solutions or manual steps
No response