调整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)
post SAP-Garson
原文链接:https://blog.csdn.net/weixin_37768201/article/details/123250188文章来自于网络,如果侵犯了您的权益,请联系站长删除!