调整SUSE系统资源&&安装HANA

虚拟机资源

CPU	内存	磁盘空间
16C	64G	1.5T

localhost:~ # df -h
Filesystem               Size  Used Avail Use% Mounted on
devtmpfs                 4.0M  8.0K  4.0M   1% /dev
tmpfs                     49G     0   49G   0% /dev/shm
tmpfs                     13G  9.0M   13G   1% /run
tmpfs                    4.0M     0  4.0M   0% /sys/fs/cgroup
/dev/mapper/system-root   60G  3.9G   55G   7% /
/dev/mapper/system-root   60G  3.9G   55G   7% /.snapshots
/dev/mapper/system-root   60G  3.9G   55G   7% /boot/grub2/i386-pc
/dev/mapper/system-root   60G  3.9G   55G   7% /boot/grub2/x86_64-efi
/dev/mapper/system-root   60G  3.9G   55G   7% /usr/local
/dev/mapper/system-root   60G  3.9G   55G   7% /tmp
/dev/mapper/system-root   60G  3.9G   55G   7% /opt
/dev/mapper/system-root   60G  3.9G   55G   7% /home
/dev/mapper/system-root   60G  3.9G   55G   7% /srv
/dev/mapper/system-root   60G  3.9G   55G   7% /root
/dev/mapper/system-root   60G  3.9G   55G   7% /var
tmpfs                    6.3G   36K  6.3G   1% /run/user/0

localhost:~ # fdisk -l
Disk /dev/vda: 1.5 TiB, 1649267441664 bytes, 3221225472 sectors
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: gpt
Disk identifier: 3D766163-8DFF-4EB7-A363-4FDCDD152BA2

Device     Start       End   Sectors Size Type
/dev/vda1   2048     10239      8192   4M BIOS boot
/dev/vda2  10240 171978751 171968512  82G Linux LVM


Disk /dev/mapper/system-root: 60 GiB, 64424509440 bytes, 125829120 sectors
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes


Disk /dev/mapper/system-swap: 2 GiB, 2147483648 bytes, 4194304 sectors
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes

划分新区vda3

localhost:~ # fdisk /dev/vda

Welcome to fdisk (util-linux 2.36.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.


Command (m for help): n
Partition number (3-128, default 3): 
First sector (171978752-3221225438, default 171978752): 
Last sector, +/-sectors or +/-size{K,M,G,T,P} (171978752-3221225438, default 3221225438): 

Created a new partition 3 of type 'Linux filesystem' and of size 1.4 TiB.

Command (m for help): p
Disk /dev/vda: 1.5 TiB, 1649267441664 bytes, 3221225472 sectors
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: gpt
Disk identifier: 3D766163-8DFF-4EB7-A363-4FDCDD152BA2

Device         Start        End    Sectors  Size Type
/dev/vda1       2048      10239       8192    4M BIOS boot
/dev/vda2      10240  171978751  171968512   82G Linux LVM
/dev/vda3  171978752 3221225438 3049246687  1.4T Linux filesystem

Command (m for help): w
The partition table has been altered.
Syncing disks.

localhost:~ # lsblk
NAME            MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT
sr0              11:0    1 1024M  0 rom  
vda             253:0    0  1.5T  0 disk 
├─vda1          253:1    0    4M  0 part 
├─vda2          253:2    0   82G  0 part 
│ ├─system-root 254:0    0   60G  0 lvm  /
│ └─system-swap 254:1    0    2G  0 lvm  [SWAP]
└─vda3          253:3    0  1.4T  0 part 
localhost:~ # mkfs.xfs /dev/vda3                        #格式化分区
meta-data=/dev/vda3              isize=512    agcount=4, agsize=95288959 blks
         =                       sectsz=512   attr=2, projid32bit=1
         =                       crc=1        finobt=1, sparse=0, rmapbt=0
         =                       reflink=0
data     =                       bsize=4096   blocks=381155835, imaxpct=5
         =                       sunit=0      swidth=0 blks
naming   =version 2              bsize=4096   ascii-ci=0, ftype=1
log      =internal log           bsize=4096   blocks=186111, version=2
         =                       sectsz=512   sunit=0 blks, lazy-count=1
realtime =none                   extsz=4096   blocks=0, rtextents=0
localhost:~ # lsblk
NAME            MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT
sr0              11:0    1 1024M  0 rom  
vda             253:0    0  1.5T  0 disk 
├─vda1          253:1    0    4M  0 part 
├─vda2          253:2    0   82G  0 part 
│ ├─system-root 254:0    0   60G  0 lvm  /
│ └─system-swap 254:1    0    2G  0 lvm  [SWAP]
└─vda3          253:3    0  1.4T  0 part 
localhost:~ # mkdir /hana
localhost:~ # mount /dev/vda3 /hana         
localhost:~ # df -h
Filesystem               Size  Used Avail Use% Mounted on
devtmpfs                 4.0M  8.0K  4.0M   1% /dev
tmpfs                     49G     0   49G   0% /dev/shm
tmpfs                     13G  9.0M   13G   1% /run
tmpfs                    4.0M     0  4.0M   0% /sys/fs/cgroup
/dev/mapper/system-root   60G  3.9G   55G   7% /
/dev/mapper/system-root   60G  3.9G   55G   7% /.snapshots
/dev/mapper/system-root   60G  3.9G   55G   7% /boot/grub2/i386-pc
/dev/mapper/system-root   60G  3.9G   55G   7% /boot/grub2/x86_64-efi
/dev/mapper/system-root   60G  3.9G   55G   7% /usr/local
/dev/mapper/system-root   60G  3.9G   55G   7% /tmp
/dev/mapper/system-root   60G  3.9G   55G   7% /opt
/dev/mapper/system-root   60G  3.9G   55G   7% /home
/dev/mapper/system-root   60G  3.9G   55G   7% /srv
/dev/mapper/system-root   60G  3.9G   55G   7% /root
/dev/mapper/system-root   60G  3.9G   55G   7% /var
tmpfs                    6.3G   36K  6.3G   1% /run/user/0
/dev/vda3                1.5T  1.5G  1.5T   1% /hana
localhost:~ # vi /etc/fstab
localhost:~ # cat /etc/fstab
/dev/system/root  /                       btrfs  defaults                      0  0
/dev/system/root  /var                    btrfs  subvol=/@/var                 0  0
/dev/system/root  /usr/local              btrfs  subvol=/@/usr/local           0  0
/dev/system/root  /tmp                    btrfs  subvol=/@/tmp                 0  0
/dev/system/root  /srv                    btrfs  subvol=/@/srv                 0  0
/dev/system/root  /root                   btrfs  subvol=/@/root                0  0
/dev/system/root  /opt                    btrfs  subvol=/@/opt                 0  0
/dev/system/root  /home                   btrfs  subvol=/@/home                0  0
/dev/system/root  /boot/grub2/x86_64-efi  btrfs  subvol=/@/boot/grub2/x86_64-efi  0  0
/dev/system/root  /boot/grub2/i386-pc     btrfs  subvol=/@/boot/grub2/i386-pc  0  0
/dev/system/swap  swap                    swap   defaults                      0  0
/dev/system/root  /.snapshots             btrfs  subvol=/@/.snapshots          0  0
/dev/vda3         /hana                   xfs    defaults                      0  0

配置本地源并安装gcc

localhost:/hana # mkdir /iso
localhost:/hana # mount -o loop SLE-15-SP3-Full-x86_64-GM-Media1.iso /iso
mount: /iso: WARNING: source write-protected, mounted read-only.
localhost:/etc/zypp/repos.d # mv Basesystem-Module_15.3-0.repo Basesystem-Module_15.3-0.repo.bak
localhost:/etc/zypp/repos.d # vi Basesystem-Module_15.3-0.repo
localhost:/etc/zypp/repos.d # cat Basesystem-Module_15.3-0.repo
[Basesystem-Module_15.3-0]
name=sle-module-basesystem
enabled=1
autorefresh=1
baseurl=/iso
path=/Module-Basesystem
type=rpm-md
keeppackages=0
localhost:/etc/zypp/repos.d # zypper lr
Repository priorities are without effect. All enabled repositories share the same priority.

# | Alias                              | Name                            | Enabled | GPG Check | Refresh
--+------------------------------------+---------------------------------+---------+-----------+--------
1 | Basesystem-Module_15.3-0           | sle-module-basesystem           | Yes     | (r ) Yes  | Yes
2 | Desktop-Applications-Module_15.3-0 | sle-module-desktop-applications | No      | ----      | ----
3 | SAP-Applications-Module_15.3-0     | sle-module-sap-applications     | No      | ----      | ----
4 | SLE-15-SP3-SAP-15.3-0              | SLE-15-SP3-SAP-15.3-0           | No      | ----      | ----
5 | SLEHA15-SP3_15.3-0                 | sle-ha                          | No      | ----      | ----
6 | Server-Applications-Module_15.3-0  | sle-module-server-applications  | No      | ----      | ----
localhost:/etc/zypp/repos.d # zypper in gcc
Building repository 'sle-module-basesystem' cache .................................................................................................................................................................................................................[done]
Loading repository data...
Reading installed packages...
Resolving package dependencies...

The following 14 NEW packages are going to be installed:
  gcc gcc7 glibc-devel libasan4 libatomic1 libcilkrts5 libitm1 liblsan0 libmpx2 libmpxwrappers2 libtsan0 libubsan0 libxcrypt-devel linux-glibc-devel

14 new packages to install.
Overall download size: 22.5 MiB. Already cached: 0 B. After the operation, additional 82.8 MiB will be used.
Continue? [y/n/v/...? shows all options] (y): y
Retrieving package libasan4-7.5.0+r278197-4.25.1.x86_64                                                                                                                                                                            (1/14), 360.1 KiB (  1.3 MiB unpacked)
Retrieving package libatomic1-10.2.1+git583-1.3.4.x86_64                                                                                                                                                                           (2/14),  21.5 KiB ( 26.1 KiB unpacked)
Retrieving package libcilkrts5-7.5.0+r278197-4.25.1.x86_64                                                                                                                                                                         (3/14),  63.5 KiB (120.1 KiB unpacked)
Retrieving package libitm1-10.2.1+git583-1.3.4.x86_64                                                                                                                                                                              (4/14),  37.9 KiB ( 94.4 KiB unpacked)
Retrieving package liblsan0-10.2.1+git583-1.3.4.x86_64                                                                                                                                                                             (5/14), 151.5 KiB (361.1 KiB unpacked)
Retrieving package libmpx2-8.2.1+r264010-1.3.7.x86_64                                                                                                                                                                              (6/14),  19.7 KiB ( 18.3 KiB unpacked)
Retrieving package libmpxwrappers2-8.2.1+r264010-1.3.7.x86_64                                                                                                                                                                      (7/14),  18.4 KiB ( 14.2 KiB unpacked)
Retrieving package libtsan0-10.2.1+git583-1.3.4.x86_64                                                                                                                                                                             (8/14), 316.3 KiB (  1.1 MiB unpacked)
Retrieving package libubsan0-7.5.0+r278197-4.25.1.x86_64                                                                                                                                                                           (9/14), 136.7 KiB (305.3 KiB unpacked)
Retrieving package libxcrypt-devel-4.4.15-2.51.x86_64                                                                                                                                                                             (10/14),  32.3 KiB ( 31.2 KiB unpacked)
Retrieving package linux-glibc-devel-5.3-1.75.x86_64                                                                                                                                                                              (11/14),   1.0 MiB (  4.4 MiB unpacked)
Retrieving package glibc-devel-2.31-7.30.x86_64                                                                                                                                                                                   (12/14), 594.2 KiB (  2.5 MiB unpacked)
Retrieving package gcc7-7.5.0+r278197-4.25.1.x86_64                                                                                                                                                                               (13/14),  19.7 MiB ( 72.7 MiB unpacked)
Retrieving package gcc-7-3.3.22.x86_64                                                                                                                                                                                            (14/14),  12.6 KiB (    0   B unpacked)

Checking for file conflicts: ......................................................................................................................................................................................................................................[done]
( 1/14) Installing: libasan4-7.5.0+r278197-4.25.1.x86_64 ..........................................................................................................................................................................................................[done]
( 2/14) Installing: libatomic1-10.2.1+git583-1.3.4.x86_64 .........................................................................................................................................................................................................[done]
( 3/14) Installing: libcilkrts5-7.5.0+r278197-4.25.1.x86_64 .......................................................................................................................................................................................................[done]
( 4/14) Installing: libitm1-10.2.1+git583-1.3.4.x86_64 ............................................................................................................................................................................................................[done]
( 5/14) Installing: liblsan0-10.2.1+git583-1.3.4.x86_64 ...........................................................................................................................................................................................................[done]
( 6/14) Installing: libmpx2-8.2.1+r264010-1.3.7.x86_64 ............................................................................................................................................................................................................[done]
( 7/14) Installing: libmpxwrappers2-8.2.1+r264010-1.3.7.x86_64 ....................................................................................................................................................................................................[done]
( 8/14) Installing: libtsan0-10.2.1+git583-1.3.4.x86_64 ...........................................................................................................................................................................................................[done]
( 9/14) Installing: libubsan0-7.5.0+r278197-4.25.1.x86_64 .........................................................................................................................................................................................................[done]
(10/14) Installing: libxcrypt-devel-4.4.15-2.51.x86_64 ............................................................................................................................................................................................................[done]
(11/14) Installing: linux-glibc-devel-5.3-1.75.x86_64 .............................................................................................................................................................................................................[done]
(12/14) Installing: glibc-devel-2.31-7.30.x86_64 ..................................................................................................................................................................................................................[done]
(13/14) Installing: gcc7-7.5.0+r278197-4.25.1.x86_64 ..............................................................................................................................................................................................................[done]
(14/14) Installing: gcc-7-3.3.22.x86_64 ...........................................................................................................................................................................................................................[done]

安装hana

拷贝安装包到/hana目录

localhost:/hana # scp 192.168.3.189:/hana/hxe.tgz ./
The authenticity of host '192.168.3.189 (192.168.3.189)' can't be established.
ECDSA key fingerprint is SHA256:a47k3Zp7+mCwrATEfWPJWWXveebCjzFUBkItLgY1oWY.
Are you sure you want to continue connecting (yes/no/[fingerprint])? yes    
Warning: Permanently added '192.168.3.189' (ECDSA) to the list of known hosts.
Password: 
hxe.tgz                                                                                                                              100% 1873MB   2.9MB/s   10:40    

解压

localhost:/hana # tar -zxf hxe.tgz 
localhost:/hana # ll
total 1917520
drwxr-xr-x 3 root    root         247 Jan 20 17:48 HANA_EXPRESS_20
-rw-r--r-- 1 root    root  1963468936 Jan 20 17:47 hxe.tgz
-rwxr-xr-x 1 3312651 10102      65610 Jun  3  2021 setup_hxe.sh

安装，基本都是默认下一步

localhost:/hana # ./setup_hxe.sh 
Enter HANA, express edition installer root directory:
    Hint: <extracted_path>/HANA_EXPRESS_20
HANA, express edition installer root directory [/hana/HANA_EXPRESS_20]: 

The SAP HANA system ID (SID) is three uppercase alphanumeric characters to identify the SAP HANA system.

Enter SAP HANA system ID [HXE]: 

An instance number is a two-digit numeric identifier for the SAP HANA instance.

Enter instance number [90]: 

Enter local host name [localhost]: 

Password must be at least 8 characters in length.  It must contain at least
1 uppercase letter, 1 lowercase letter, and 1 number.  Special characters
are allowed, except \ (backslash), ' (single quote), " (double quotes),
` (backtick), and $ (dollar sign).

Enter HDB master password:          #Asdf123.
Confirm "HDB master" password: 


##############################################################################
# Summary before execution                                                   #
##############################################################################
HANA, express edition installer : /hana/HANA_EXPRESS_20
  Component(s) to install                   : HANA server, Application Function Library, SAP HANA EPM-MDS
  Host name                                 : localhost
  HANA system ID                            : HXE
  HANA instance number                      : 90
  Master password                           : ********
  Log file                                  : /var/tmp/setup_hxe_2022-01-20_18.58.03.log

Proceed with installation? (Y/N) : y

Installing HDB server...


SAP HANA Lifecycle Management - SAP HANA Express Edition 2.00.054.00.1611906357
*******************************************************************************


Start reading from input channel...
... Done.

Summary before execution:
=========================

SAP HANA Express Edition System Installation
   Installation Parameters
      Remote Execution: ssh
      Use single master password for all users, created during installation: Yes
      Database Isolation: low
      Install Execution Mode: optimized
      Installation Path: /hana/shared
      Local Host Name: localhost
      SAP HANA System ID: HXE
      Instance Number: 90
      Local Host Worker Group: default
      System Usage: development
      Location of Data Volumes: /hana/shared/data/HXE
      Location of Log Volumes: /hana/shared/log/HXE
      Directory containing custom configurations: /hana/HANA_EXPRESS_20/DATA_UNITS/HDB_SERVER_LINUX_X86_64/configurations/custom
      SAP HANA Database secure store: ssfs
      Certificate Host Names: localhost -> localhost
      System Administrator Home Directory: /usr/sap/HXE/home
      System Administrator Login Shell: /bin/bash
      System Administrator User ID: 1001
      ID of User Group (sapsys): 79
      Restart system after machine reboot?: Yes
      Inter Service Communication Mode: ssl
   Software Components
      SAP HANA Database
         Install version 2.00.054.00.1611906357
         Location: /hana/HANA_EXPRESS_20/DATA_UNITS/HDB_SERVER_LINUX_X86_64/server
      SAP HANA AFL (incl.PAL,BFL,OFL)
         Install version 2.00.054.0000.1611928859
         Location: /hana/HANA_EXPRESS_20/DATA_UNITS/HDB_AFL_LINUX_X86_64/packages
      SAP HANA EPM-MDS
         Install version 2.00.054.0000.1611928859
         Location: /hana/HANA_EXPRESS_20/DATA_UNITS/SAP_HANA_EPM-MDS_10/packages
   Log File Locations
      Log directory: /var/tmp/hdb_HXE_hdblcm_install_2022-01-20_18.58.17
      Trace location: /var/tmp/hdblcm_2022-01-20_18.58.17_11030.trc
Installing components...
Installing SAP HANA Database...
  Preparing package 'Saphostagent Setup'...
  Preparing package 'Python Support'...
  Preparing package 'Python Runtime'...
  Preparing package 'Product Manifest'...
  Preparing package 'Binaries'...
  Preparing package 'Krb5 Runtime'...
  Preparing package 'Installer'...
  Preparing package 'Ini Files'...
  Preparing package 'Documentation'...
  Preparing package 'Delivery Units'...
  Preparing package 'Offline Cockpit'...
  Preparing package 'DAT Languages (EN, DE)'...
  Preparing package 'DAT Configfiles (EN, DE)'...
  Creating System...
  Extracting software...
  Installing package 'Saphostagent Setup'...
  Installing package 'Python Support'...
  Installing package 'Python Runtime'...
  Installing package 'Product Manifest'...
  Installing package 'Binaries'...
  Installing package 'Krb5 Runtime'...
  Installing package 'Installer'...
  Installing package 'Ini Files'...
  Installing package 'Documentation'...
  Installing package 'Delivery Units'...
  Installing package 'Offline Cockpit'...
  Installing package 'DAT Languages (EN, DE)'...
  Installing package 'DAT Configfiles (EN, DE)'...
  Creating instance...
Installing Resident hdblcm...
Installing SAP HANA AFL (incl.PAL,BFL,OFL)...
  Preparing package 'AFL'...
  Installing SAP Application Function Libraries to /hana/shared/HXE/exe/linuxx86_64/plugins/afl_2.00.054.0000.1611928859_9ce1799fc4f949856d57dac71e1da498972d676f...
  Installing package 'AFL'...
  Activating plugin...
Installing SAP HANA EPM-MDS...
  Preparing package 'Enterprise Performance Management and Multidimensional Services'...
  Installing SAP HANA EPM-MDS to /hana/shared/HXE/exe/linuxx86_64/plugins/epmmds_2.00.054.0000.1611928859_9ce1799fc4f949856d57dac71e1da498972d676f...
  Installing package 'Enterprise Performance Management and Multidimensional Services'...
  Activating plugin...
Configuring SAP HANA Database...
  Configuring System...
  Configuring instance...
  Installing SAP Host Agent version 7.21.47...
Starting instances...
  Starting 4 processes on host 'localhost' (worker):
    Starting on 'localhost' (worker): hdbdaemon, hdbcompileserver, hdbnameserver, hdbwebdispatcher
  Starting 5 processes on host 'localhost' (worker):
    Starting on 'localhost' (worker): hdbdaemon, hdbcompileserver, hdbnameserver, hdbwebdispatcher, hdbindexserver (HXE)
    Starting on 'localhost' (worker): hdbdaemon, hdbwebdispatcher, hdbindexserver (HXE)
    Starting on 'localhost' (worker): hdbdaemon, hdbwebdispatcher
  All server processes started on host 'localhost' (worker).
Finalizing installation of SAP HANA Database...
  Finalizing System Installation...
  Starting SAP HANA Database system...
Updating SAP HANA Express Edition Instance Integration on Local Host...
  Regenerating SSL certificates...
  Deploying SAP Host Agent configurations...
Creating Component List...
SAP HANA Express Edition System installed
You can send feedback to SAP with this form: https://localhost:1129/lmsl/HDBLCM/HXE/feedback/feedback.html
Log file written to '/var/tmp/hdb_HXE_hdblcm_install_2022-01-20_18.58.17/hdblcm.log' on host 'localhost'.
Enable AFL...


Collecting garbage...
Collect garbage on "hdbnameserver"...
Shrink resource container memory on "hdbnameserver"...
Collect garbage on "hdbindexserver"...
Shrink resource container memory on "hdbindexserver"...
Collect garbage on "hdbcompileserver"...
Shrink resource container memory on "hdbcompileserver"...

Total in use HANA processes heap memory (MB)
============================================
Before collection : 1727
After  collection : 1416

Free and used memory in the system
==================================
Before collection
-------------------------------------------------------------------------
              total        used        free      shared  buff/cache   available
Mem:           62Gi       4.2Gi        37Gi        53Mi        20Gi        57Gi
Swap:         2.0Gi          0B       2.0Gi
After  collection
-------------------------------------------------------------------------
              total        used        free      shared  buff/cache   available
Mem:           62Gi       3.8Gi        37Gi        53Mi        20Gi        58Gi
Swap:         2.0Gi          0B       2.0Gi

Installing XSC...
Importing delivery units...


SAP HANA Lifecycle Management - Update Repository 2.5.49
********************************************************


Start reading from input channel...
... Done.
Importing delivery units...
Importing delivery unit HCO_INA_SERVICE
Importing delivery unit HANA_DT_BASE
Importing delivery unit HANA_TA_CONFIG
Importing delivery unit HANA_UI_INTEGRATION_SVC
Importing delivery unit HANA_UI_INTEGRATION_CONTENT
Importing delivery unit HANA_XS_BASE
Importing delivery unit HANA_XS_DBUTILS
Importing delivery unit HANA_XS_LM
Importing delivery unit HDC_ADMIN
Importing delivery unit HDC_BACKUP
Importing delivery unit HDC_SEC_CP
Importing delivery unit HDC_XS_BASE
Importing delivery unit HDC_XS_LM
Importing delivery unit SAPUI5_1
Importing delivery unit HANA_SEC_CP
Importing delivery unit HANA_BACKUP
Importing delivery unit HANA_HDBLCM
Importing delivery unit HANA_SEC_BASE
Importing delivery unit HANA_ADMIN
Importing delivery unit HANA_WKLD_ANLZ
Update Repository done
Log file written to '/var/tmp/hdb_HXE_UpdateRepository_2022-01-20_19.05.34/hdbupdrep.log' on host 'localhost'.


SAP HANA Lifecycle Management - Update Repository 2.5.49
********************************************************


Start reading from input channel...
... Done.
Importing delivery units...
Importing delivery unit HDC_SYS_ADMIN
Importing delivery unit HANA_SYS_ADMIN
Update Repository done
Log file written to '/var/tmp/hdb_HXE_UpdateRepository_2022-01-20_19.06.55/hdbupdrep.log' on host 'localhost'.


Collecting garbage...
Collect garbage on "hdbnameserver"...
Shrink resource container memory on "hdbnameserver"...
Collect garbage on "hdbindexserver"...
Shrink resource container memory on "hdbindexserver"...
Collect garbage on "hdbcompileserver"...
Shrink resource container memory on "hdbcompileserver"...

Total in use HANA processes heap memory (MB)
============================================
Before collection : 3943
After  collection : 3052

Free and used memory in the system
==================================
Before collection
-------------------------------------------------------------------------
              total        used        free      shared  buff/cache   available
Mem:           62Gi        11Gi        29Gi        53Mi        20Gi        50Gi
Swap:         2.0Gi          0B       2.0Gi
After  collection
-------------------------------------------------------------------------
              total        used        free      shared  buff/cache   available
Mem:           62Gi       8.1Gi        33Gi        53Mi        20Gi        53Gi
Swap:         2.0Gi          0B       2.0Gi

Optimizing HDB server...


 
Start "HXE" tenant database. This may take a while...
Enable debugger in workbench...
Enable statistics server...
Enable diserver server...
Grant activated role "sap.hana.xs.admin.roles::HTTPDestViewer" to SYSTEM on SystemDB database...
Grant activated role "sap.hana.xs.admin.roles::SQLCCAdministrator" to SYSTEM on SystemDB database...
Grant activated role "sap.hana.xs.debugger::Debugger" to SYSTEM on SystemDB database...
Grant activated role "sap.hana.xs.admin.roles::HTTPDestViewer" to SYSTEM on HXE database...
Grant activated role "sap.hana.xs.admin.roles::SQLCCAdministrator" to SYSTEM on HXE database...
Grant activated role "sap.hana.xs.debugger::Debugger" to SYSTEM on HXE database...
Set system configuration wdisp/system_auto_configuration=true in webdispatcher.ini...
Do garbage collection...
Collect garbage on "hdbnameserver"...
Shrink resource container memory on "hdbnameserver"...
Collect garbage on "hdbindexserver"...
Shrink resource container memory on "hdbindexserver"...
Collect garbage on "hdbcompileserver"...
Shrink resource container memory on "hdbcompileserver"...
Collect garbage on "hdbdiserver"...
Shrink resource container memory on "hdbdiserver"...
Reclaim data volume on hdbnameserver...
Reclaim data volume on hdbindexserver...
Release free log segments on hdbnameserver...
Release free log segments on hdbindexserver...
HDB is successfully optimized.


#########################################################################
# Summary after execution 						#
#########################################################################
Server Installation...(OK)
XSC Installation...(OK)
HXE Optimization...(OK)


Congratulations! SAP HANA, express edition 2.0 is installed.
See https://www.sap.com/developer/tutorials/hxe-ua-getting-started-binary.html to get started.

安装成功，连接测试

localhost:/hana # su - hxeadm
hxeadm@localhost:/usr/sap/HXE/HDB90> hdbsql

Welcome to the SAP HANA Database interactive terminal.
                                           
Type:  \h for help with commands          
       \q to quit                         

hdbsql=> \c -i 90 -u system -p Asdf123.
Connected to HXE@localhost:39013
hdbsql HXE=> select * from tables;
962 rows selected (overall time 2267.000 msec; server time 33.034 msec)