SAP HANA Database Creation

The creation of the database must be made by the SAP HANA UNIX user, on the machine where SAP HANA is installed. The SAP HANA UNIX user is assumed to perform the installation steps below.

Create the SAP HANA database instance. The working directory is saphana.
./saphana_create_instance.sh [<SAP HANA SYSTEMDB admin user>] [<SAP HANA SYSTEMDB admin password>]

Example - SAP HANA database instance

$ ./saphana_create_instance.sh SYSTEM p\@ssword1

The script ./saphana_create_instance.sh requires special handling for passwords that contain special characters. For example, you must use a backslash ‘\' to escape the '@’ character in the password above.

If no error occurs, the database creation is now complete, and the rest of this section can be ignored.

Hint!
After the instance creation script is executed, a log file will be created in the /tmp directory, which can be used for troubleshooting. The mz_db.log file contains SAP HANA responses from the database creation.

If the script fails, clean up the system before the next try:
1. Stop DB (this is needed to drop it):
  hdbsql -i 90 -d SystemDB -u SYSTEM -p QAmzadm1n "ALTER SYSTEM STOP DATABASE MZ"
2. Drop DB:
  hdbsql -i 90 -d SystemDB -u SYSTEM -p QAmzadm1n "DROP DATABASE MZ"

If you need to change any installation parameter defined in the install.xml, the installation must be restarted from the generation step. For further information, seeSAP 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. Search “Auditing activity in SAP HANA” in the https://help.sap.com/docs/ for more information.