The creation of the database must be made by the SAP HANA UNIX user, on the machine where SAP HANA is installed. The SAP The SAP HANA UNIX user is assumed to be used for perform the installation steps below.
Create the SAP HANA database instance. The working directory is saphana.
Code Block $ ./saphana_create_instance.sh [<SAP HANA admin user>] [<SAP HANA admin password>]
If no error occurs, the database creation will is now be completed complete and the rest of this section can be ignored.
Tip title Hint!When After the instance creation script has been is executed, there is will be a log file in the/tmp
directory that can be used for trouble shootingtroubleshooting. Themz_db.log file
contains SAP HANA responses from the database creation.If the script fails, clean up the system before the next try:
Stop DB (Needed this is needed to drop it):
Code Block hdbsql -i 90 -d SystemDB -u SYSTEM -p QAmzadm1n "ALTER SYSTEM STOP DATABASE MZ"
Drop DB:
Code Block hdbsql -i 90 -d SystemDB -u SYSTEM -p QAmzadm1n "DROP DATABASE MZ"
If you require to change any installation parameter defined in the install.xml
, the installation must be restarted from the generation step. For further information, see SAP HANA Preparations.
...
Hint!
...
The SAP HANA audit policy
...
only
...
works for the user ‘SYSTEM
’ due to the parameter ‘FOR SYSTEM
’.
...
To use a different user,
...
change ‘SYSTEM
’ to the desired username. For further information,
...
refer to Auditing Activity in SAP HANA.