3.5.3 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 be used for the installation steps below.

1. Create the SAP HANA database instance. The working directory is saphana.

   $ ./saphana_create_instance.sh

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

   Hint!

   When the instance creation script has been executed, there is a log file in the /tmp directory that can be used for trouble shooting. The mz.log file contains SAP HANA responses from the database creation. 

2. If the script fails, clean up the system before the next try:
   
   

   • Stop DB (Needed to drop it):

     hdbsql -i 90 -d SystemDB -u SYSTEM -p QAmzadm1n "ALTER SYSTEM STOP DATABASE MZ"

   • Drop DB:

     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 3.5.1 Generation of SAP HANA Database Definition Files.