SAP HANA

SAP HANA 설치 방법 (hdblcm 커맨드 사용)

덩덩 2020. 1. 19. 16:14

SAP HANA DB 2.0 SP4 설치 방법 (Full Script 포함)

- hdblcm 커맨드 사용

- Single Host 설치

- 운영체제 : openSUSE Leap 15.1

openSUSE OS Release SLES 둔갑?시키는 트릭이 필요

    : openSUSE 릴리즈 정보를 SLES 바꾸기(속이기) 포스팅 참고

단순 설치 테스트 용도로만 사용해야 하며, 실제로 이렇게 사용하면 안됌!

openSUSE에서는 Pacemaker 이용한 HANA DB 이중화 구성을 , SAPHanaTopology 리소스 에이전트와 SAPHana 리소스 에이전트를 사용할 없음

 

1. 필수 패키지 설치 파일시스템 준비

hanadb:~ # zypper install libgcc_s1 libstdc++6 libatomic1

 

hanadb:~ # df -h

Filesystem      Size  Used Avail Use% Mounted on

devtmpfs         12G     0   12G   0% /dev

tmpfs            12G     0   12G   0% /dev/shm

tmpfs            12G   26M   12G   1% /run

tmpfs            12G     0   12G   0% /sys/fs/cgroup

/dev/sda2        19G  5.6G   12G  33% /

/dev/sda2        19G  5.6G   12G  33% /tmp

/dev/sde1        79G  2.2G   73G   3% /hana/log

/dev/sdb1        98G   37G   57G  39% /hana/shared

/dev/sdd1       196G  277M  186G   1% /hana/data

/dev/sda2        19G  5.6G   12G  33% /root

/dev/sda2        19G  5.6G   12G  33% /var

/dev/sdc1        49G  255M   47G   1% /usr/sap

/dev/sda2        19G  5.6G   12G  33% /boot/grub2/i386-pc

/dev/sda2        19G  5.6G   12G  33% /.snapshots

/dev/sda2        19G  5.6G   12G  33% /usr/local

/dev/sdf1       147G   61M  140G   1% /hana/logbackups

/dev/sda2        19G  5.6G   12G  33% /home

/dev/sda2        19G  5.6G   12G  33% /opt

/dev/sda2        19G  5.6G   12G  33% /srv

/dev/sda2        19G  5.6G   12G  33% /boot/grub2/x86_64-efi

tmpfs           2.4G   28K  2.4G   1% /run/user/462

tmpfs           2.4G     0  2.4G   0% /run/user/0

 

2. SAP HANA DB 다운로드 압축해제

support.sap.com -> Software Download Center -> Installations and Upgrades -> SAP IN-MEMORY (SAP HANA ) -> HANA PLATFORM EDITION -> SAP HANA PLATFORM EDITION -> SAP HANA PLATFORM EDITION 2.0 -> SAP HANA Platform Edt. <Version> <Platform> 다운로드

 

hanadb:/hana/shared/sapcds/hanainst # ls

51053787.ZIP

 

hanadb:/hana/shared/sapcds/hanainst # unzip 51053787.ZIP

 

hanadb:/hana/shared/sapcds/hanainst # ls

51053787.ZIP  COPY_TM.HTM  LABEL.ASC     MD5FILE.DAT  VERSION.ASC

CDLABEL.ASC   COPY_TM.TXT  LABEL.EBC     MID.XML      VERSION.EBC

CDLABEL.EBC   DATA_UNITS   LABELIDX.ASC  SHAFILE.DAT

 

hanadb:/hana/shared/sapcds/hanainst # cd DATA_UNITS/

hanadb:/hana/shared/sapcds/hanainst/DATA_UNITS # ls

HANASPARK_CTRL_20              HDB_CLIENT_SOLARIS_SPARC

HANA_LSS_24_LINUX_X86_64       HDB_CLIENT_SOLARIS_X86_64

HANA_SPATIAL_MAP_CLIENT_10     HDB_CLIENT_WINDOWS_X86_64

HANA_TEST_TOOLS                HDB_EML_AFL_10_LINUX_X86_64

HCO_HANA_APPLICATION_LOG_1     HDB_LCM_LINUX_X86_64

HCO_HANA_HADOOP_CONTROLLER     HDB_MODELCOMPARE_20

HCO_HANA_SHINE                 HDB_SERVER_LINUX_X86_64

HCO_INA_FILELOAD_10            HDB_STUDIO_LINUX_X86_64

HCO_SAP_HANA_GRAPH_VIEWER_1.0  HDB_STUDIO_MACOSX_X86_64

HDB_AFL_LINUX_X86_64           HDB_STUDIO_WINDOWS_X86_64

HDB_CLIENT_AIX_PPC64           LABELIDX.ASC

HDB_CLIENT_HPUX_IA64           PAAPL4_H204_LINUX_X86_64

HDB_CLIENT_LINUXINTEL          SAP_HANA_EPM-MDS_10

HDB_CLIENT_LINUX_PPC64         SAP_HANA_HWCCT_LINUX_X86_64

HDB_CLIENT_LINUX_PPC64LE       SAP_HANA_RSA

HDB_CLIENT_LINUX_S390X_64      SAP_HANA_SDA_20_LINUX_X86_64

HDB_CLIENT_LINUX_X86_64        XSAC_HRTT_20

HDB_CLIENT_LINUX_X86_64_S9     XSAC_SAP_WEB_IDE_20

HDB_CLIENT_MACOS               XSA_CLIENT_10

HDB_CLIENT_MS_EXCEL            XSA_CONTENT_10

HDB_CLIENT_NTINTEL             XSA_RT_10_LINUX_X86_64

HDB_CLIENT_OS400_PPC64         XS_MIGRATION_1

 

hanadb:/hana/shared/sapcds/hanainst/DATA_UNITS # cd HDB_LCM_LINUX_X86_64

hanadb:/hana/shared/sapcds/hanainst/DATA_UNITS/HDB_LCM_LINUX_X86_64 # ls

SIGNATURE.SMF  filelist.hdblcm_remote_check  hdblcmgui    operations.d

adapters.d     filelist.resident             hdblcmweb    resources

descriptors.d  hdblcm                        instruntime

 

3. SAP HANA DB 설치 (hdblcm 사용)

hanadb:/hana/shared/sapcds/hanainst/DATA_UNITS/HDB_LCM_LINUX_X86_64 # ./hdblcm

 

 

SAP HANA Lifecycle Management - SAP HANA Database 2.00.040.00.1553674765

************************************************************************

 

 

Scanning software locations...

Detected components:

    SAP HANA Database (2.00.040.00.1553674765) in /hana/shared/sapcds/hanainst/DATA_UNITS/HDB_SERVER_LINUX_X86_64/server

    SAP HANA Local Secure Store (2.4.6.0) in /hana/shared/sapcds/hanainst/DATA_UNITS/HANA_LSS_24_LINUX_X86_64/packages

    SAP HANA AFL (incl.PAL,BFL,OFL) (2.00.040.0000.1553698248) in /hana/shared/sapcds/hanainst/DATA_UNITS/HDB_AFL_LINUX_X86_64/packages

    SAP HANA EML AFL (2.00.040.0000.1553698248) in /hana/shared/sapcds/hanainst/DATA_UNITS/HDB_EML_AFL_10_LINUX_X86_64/packages

    SAP HANA EPM-MDS (2.00.040.0000.1553698248) in /hana/shared/sapcds/hanainst/DATA_UNITS/SAP_HANA_EPM-MDS_10/packages

    SAP HANA Database Client (2.4.126.1551801496) in /hana/shared/sapcds/hanainst/DATA_UNITS/HDB_CLIENT_LINUX_X86_64/client

    SAP HANA Studio (2.3.43.000000) in /hana/shared/sapcds/hanainst/DATA_UNITS/HDB_STUDIO_LINUX_X86_64/studio

    SAP HANA Smart Data Access (2.00.4.000.0) in /hana/shared/sapcds/hanainst/DATA_UNITS/SAP_HANA_SDA_20_LINUX_X86_64/packages

    SAP HANA XS Advanced Runtime (1.0.114.14140) in /hana/shared/sapcds/hanainst/DATA_UNITS/XSA_RT_10_LINUX_X86_64/packages

    GUI for HALM for XSA (including product installer) Version 1 (1.013.2) in /hana/shared/sapcds/hanainst/DATA_UNITS/XSA_CONTENT_10/XSACALMPIUI13_2.zip

    XSAC FILEPROCESSOR 1.0 (1.000.36) in /hana/shared/sapcds/hanainst/DATA_UNITS/XSA_CONTENT_10/XSAC_FILE_PROC-1.0.36.zip

    SAP Enterprise Architecture Designer 1.0 for SAP HANA (1.005.11) in /hana/shared/sapcds/hanainst/DATA_UNITS/XSA_CONTENT_10/XSAC_HANA_EADESIGNER-1.5.11.zip

    SAP HANA tools for accessing catalog content, data preview, SQL console, etc. (2.009.23) in /hana/shared/sapcds/hanainst/DATA_UNITS/XSAC_HRTT_20/XSACHRTT09_23.zip

    XS Messaging Service 1 (1.004.2) in /hana/shared/sapcds/hanainst/DATA_UNITS/XSA_CONTENT_10/XSACMESSSRV04_2.zip

    Develop and run portal services for customer apps on XSA (1.004.0) in /hana/shared/sapcds/hanainst/DATA_UNITS/XSA_CONTENT_10/XSACPORTALSERV04_0.zip

    SAP Web IDE Web Client (4.004.0) in /hana/shared/sapcds/hanainst/DATA_UNITS/XSAC_SAP_WEB_IDE_20/XSACSAPWEBIDE04_0.zip

    XS Services 1 (1.007.8) in /hana/shared/sapcds/hanainst/DATA_UNITS/XSA_CONTENT_10/XSACSERVICES07_8.zip

    SAPUI5 FESV5 XSA 1 - SAPUI5 1.60 (1.060.8) in /hana/shared/sapcds/hanainst/DATA_UNITS/XSA_CONTENT_10/XSACUI5FESV560_8.zip

    SAPUI5 SERVICE BROKER XSA 1 - SAPUI5 Service Broker 1.0 (1.000.3) in /hana/shared/sapcds/hanainst/DATA_UNITS/XSA_CONTENT_10/XSACUI5SB00_3.zip

    XSA Cockpit 1 (1.001.13) in /hana/shared/sapcds/hanainst/DATA_UNITS/XSA_CONTENT_10/XSACXSACOCKPIT01_13.zip

 

 

 

Choose an action

 

  Index | Action             | Description

  -----------------------------------------------

  1     | install            | Install new system

  2     | extract_components | Extract components

  3     | Exit (do nothing)  |

 

신규 시스템 설치를 위해 1 인덱스 (Install new System) 입력

Enter selected action index [3]: 1

 

 

SAP HANA Database version '2.00.040.00.1553674765' will be installed.

 

Select additional components for installation:

 

  Index | Components | Description

  ---------------------------------------------------------------------------------------------

  1     | all        | All components

  2     | server     | No additional components

  3     | client     | Install SAP HANA Database Client version 2.4.126.1551801496

  4     | lss        | Install SAP HANA Local Secure Store version 2.4.6.0

  5     | studio     | Install SAP HANA Studio version 2.3.43.000000

  6     | smartda    | Install SAP HANA Smart Data Access version 2.00.4.000.0

  7     | xs         | Install SAP HANA XS Advanced Runtime version 1.0.114.14140

  8     | afl        | Install SAP HANA AFL (incl.PAL,BFL,OFL) version 2.00.040.0000.1553698248

  9     | eml        | Install SAP HANA EML AFL version 2.00.040.0000.1553698248

  10    | epmmds     | Install SAP HANA EPM-MDS version 2.00.040.0000.1553698248

 

필요한 컴포넌트 입력

콤마로 구분해서 다중 입력 가능하며, 필수적으로 2,3번은 필요

Enter comma-separated list of the selected indices [3]: 2,3

 

설치 경로 입력

Enter Installation Path [/hana/shared]: <Enter 입력>

 

호스트명 입력

Enter Local Host Name [hanadb]: <Enter 입력>

 

Single Host 설치이기 때문에 추가할 호스트 없음

Do you want to add hosts to the system? (y/n) [n]: <Enter 입력>

 

사용할 SID 입력

Enter SAP HANA System ID: THD

 

사용할 인스턴스 번호 입력

Enter Instance Number [00]: <Enter 입력>

 

Worker Group 입력

Enter Local Host Worker Group [default]: <Enter 입력>

 

  Index | System Usage | Description

  -------------------------------------------------------------------------------

  1     | production   | System is used in a production environment

  2     | test         | System is used for testing, not production

  3     | development  | System is used for development, not production

  4     | custom       | System usage is neither production, test nor development

 

서버 용도 선택

Select System Usage / Enter Index [4]: 4

 

Data Volume 디렉터리 입력

Enter Location of Data Volumes [/hana/data/THD]: <Enter 입력>

 

Log Volume 디렉터리 입력

Enter Location of Log Volumes [/hana/log/THD]: <Enter 입력>

 

최대 메모리 제한 설정 여부 선택

제한을 두고 싶을 경우 MB 단위로 입력

Restrict maximum memory allocation? [n]: <Enter 입력>

 

Cerfiticate Host Name 입력

Certificate host Name이란, SSL 인증서가 DB 통신할 사용할 이름으로 간단하게 네트워크에서 사용하는 이름 정도로 생각하면

Enter Certificate Host Name For Host 'hanadb' [hanadb]: <Enter 입력>

 

SAP Host Agent 계정 (sapadm) 패스워드 입력

Enter SAP Host Agent User (sapadm) Password: <Password 입력>

Confirm SAP Host Agent User (sapadm) Password: <Password 입력>

 

SAP System Admin 계정 (<SID>adm) 패스워드 입력

Enter System Administrator (thdadm) Password: <Password 입력>

Confirm System Administrator (thdadm) Password: <Password 입력>

 

System Admin 디렉터리 입력

Enter System Administrator Home Directory [/usr/sap/THD/home]: <Enter 입력>

 

System Admin 로그인 입력

Enter System Administrator Login Shell [/bin/sh]: <Enter 입력>

 

System Admin User ID 입력

Enter System Administrator User ID [1000]: <Enter 입력>

 

sapsys 사용자 그룹 ID 입력

Enter ID of User Group (sapsys) [79]: <Enter 입력>

 

System DB 계정 (SYSTEM) 패스워드 입력

Enter System Database User (SYSTEM) Password: <Password 입력>

Confirm System Database User (SYSTEM) Password: <Password 입력>

 

서버 재부팅 HANA DB 시작할 여부 선택

Restart system after machine reboot? [n]: <Enter 입력>

 

설정 내역 확인

Summary before execution:

=========================

 

SAP HANA Database System Installation

   Installation Parameters

      SAP HANA System ID: THD

      Instance Number: 00

      Local Host Worker Group: default

      System Usage: custom

      Location of Data Volumes: /hana/data/THD

      Location of Log Volumes: /hana/log/THD

      Certificate Host Names: hanadb -> hanadb

      System Administrator Home Directory: /usr/sap/THD/home

      System Administrator Login Shell: /bin/sh

      System Administrator User ID: 1000

      ID of User Group (sapsys): 79

      SAP HANA Database Client Installation Path: /hana/shared/THD/hdbclient

      Remote Execution: ssh

      Database Isolation: low

      Install Execution Mode: standard

      Installation Path: /hana/shared

      Local Host Name: hanadb

   Software Components

      SAP HANA Database

         Install version 2.00.040.00.1553674765

         Location: /hana/shared/sapcds/hanainst/DATA_UNITS/HDB_SERVER_LINUX_X86_64/server

      SAP HANA Local Secure Store

         Do not install

      SAP HANA AFL (incl.PAL,BFL,OFL)

         Do not install

      SAP HANA EML AFL

         Do not install

      SAP HANA EPM-MDS

         Do not install

      SAP HANA Database Client

         Install version 2.4.126.1551801496

         Location: /hana/shared/sapcds/hanainst/DATA_UNITS/HDB_CLIENT_LINUX_X86_64/client

      SAP HANA Studio

         Do not install

      SAP HANA Smart Data Access

         Do not install

      SAP HANA XS Advanced Runtime

         Do not install

   Log File Locations

      Log directory: /var/tmp/hdb_THD_hdblcm_install_2020-01-19_15.01.32

      Trace location: /var/tmp/hdblcm_2020-01-19_15.01.32_2684.trc

 

실행 여부 확인

Do you want to continue? (y/n): y

 

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 'Data Quality'...

  Preparing package 'Krb5 Runtime'...

  Preparing package 'Installer'...

  Preparing package 'Ini Files'...

  Preparing package 'HWCCT'...

  Preparing package 'Documentation'...

  Preparing package 'Delivery Units'...

  Preparing package 'Offline Cockpit'...

  Preparing package 'DAT Languages (EN, DE)'...

  Preparing package 'DAT Languages (other)'...

  Preparing package 'DAT Configfiles (EN, DE)'...

  Preparing package 'DAT Configfiles (other)'...

  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 'Data Quality'...

  Installing package 'Krb5 Runtime'...

  Installing package 'Installer'...

  Installing package 'Ini Files'...

  Installing package 'HWCCT'...

  Installing package 'Documentation'...

  Installing package 'Delivery Units'...

  Installing package 'Offline Cockpit'...

  Installing package 'DAT Languages (EN, DE)'...

  Installing package 'DAT Languages (other)'...

  Installing package 'DAT Configfiles (EN, DE)'...

  Installing package 'DAT Configfiles (other)'...

  Creating instance...

  Configuring instance...

  Installing SAP Host Agent version 7.21.41...

  Starting SAP HANA Database system...

    Starting 4 processes on host 'hanadb' (worker):

      Starting on 'hanadb' (worker): hdbdaemon, hdbcompileserver, hdbnameserver, hdbpreprocessor

    Starting 7 processes on host 'hanadb' (worker):

      Starting on 'hanadb' (worker): hdbdaemon, hdbcompileserver, hdbnameserver, hdbpreprocessor, hdbwebdispatcher, hdbindexserver (THD), hdbxsengine (THD)

      Starting on 'hanadb' (worker): hdbdaemon, hdbcompileserver, hdbpreprocessor, hdbwebdispatcher, hdbindexserver (THD), hdbxsengine (THD)

      Starting on 'hanadb' (worker): hdbdaemon, hdbwebdispatcher, hdbindexserver (THD), hdbxsengine (THD)

      Starting on 'hanadb' (worker): hdbdaemon, hdbwebdispatcher, hdbxsengine (THD)

      Starting on 'hanadb' (worker): hdbdaemon, hdbwebdispatcher

    All server processes started on host 'hanadb' (worker).

  Importing delivery units...

  Importing delivery unit HCO_INA_SERVICE

  Importing delivery unit HANA_DT_BASE

  Importing delivery unit HANA_IDE_CORE

  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_EDITOR

  Importing delivery unit HANA_XS_IDE

  Importing delivery unit HANA_XS_LM

  Importing delivery unit HDC_ADMIN

  Importing delivery unit HDC_BACKUP

  Importing delivery unit HDC_IDE_CORE

  Importing delivery unit HDC_SEC_CP

  Importing delivery unit HDC_SYS_ADMIN

  Importing delivery unit HDC_XS_BASE

  Importing delivery unit HDC_XS_LM

  Importing delivery unit SAPUI5_1

  Importing delivery unit SAP_WATT

  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_SYS_ADMIN

  Importing delivery unit HANA_ADMIN

  Importing delivery unit HANA_WKLD_ANLZ

Installing Resident hdblcm...

Installing SAP HANA Database Client...

  Preparing package 'Product Manifest'...

  Preparing package 'SQLDBC'...

  Preparing package 'REPOTOOLS'...

  Preparing package 'Python DB API'...

  Preparing package 'Python Machine Learning API'...

  Preparing package 'ODBC'...

  Preparing package 'R Machine Learning API'...

  Preparing package 'JDBC'...

  Preparing package 'HALM Client'...

  Preparing package 'DBCAPI'...

  Preparing package 'node.js Client'...

  Preparing package 'golang Client'...

  Preparing package 'Ruby Client'...

  Preparing package 'CommonCryptoLib'...

  Preparing package 'Environment Script'...

  Preparing package 'Client Installer'...

  Installing SAP HANA Database Client to /hana/shared/THD/hdbclient...

  Installing package 'Product Manifest'...

  Installing package 'SQLDBC'...

  Installing package 'REPOTOOLS'...

  Installing package 'Python DB API'...

  Installing package 'Python Machine Learning API'...

  Installing package 'ODBC'...

  Installing package 'R Machine Learning API'...

  Installing package 'JDBC'...

  Installing package 'HALM Client'...

  Installing package 'DBCAPI'...

  Installing package 'node.js Client'...

  Installing package 'golang Client'...

  Installing package 'Ruby Client'...

  Installing package 'CommonCryptoLib'...

  Installing package 'Environment Script'...

  Installing package 'Client Installer'...

Registering SAP HANA Database Components on Local Host...

  Regenerating SSL certificates...

  Deploying SAP Host Agent configurations...

Creating Component List...

SAP HANA Database System installed

You can send feedback to SAP with this form: https://hanadb:1129/lmsl/HDBLCM/THD/feedback/feedback.html

Log file written to '/var/tmp/hdb_THD_hdblcm_install_2020-01-19_15.01.32/hdblcm.log' on host 'hanadb'.

 

설치 완료

 

4. 설치 로그 확인

hanadb:/hana/shared/sapcds/hanainst/DATA_UNITS/HDB_LCM_LINUX_X86_64 # vi /var/tmp/hdb_THD_hdblcm_install_2020-01-19_15.01.32/hdblcm.log

 

5. HANA DB 상태 점검 시작/중지 방법

<SID>adm 계정으로 로그인 (Switch User)

hanadb:/hana/shared/sapcds/hanainst/DATA_UNITS/HDB_LCM_LINUX_X86_64 # su - thdadm

 

HANA DB 상태 점검

thdadm@hanadb:/usr/sap/THD/HDB00> HDB info

USER          PID     PPID  %CPU        VSZ        RSS COMMAND

thdadm       8043     8042   0.0      17628       7464 -sh

thdadm       8232     8043   0.0      13984       3860  \_ /bin/sh /usr/sap/THD/

thdadm       8263     8232   0.0      34600       3356      \_ ps fx -U thdadm -

thdadm       3746        1   0.0     666472      50044 hdbrsutil  --start --port

thdadm       3415        1   0.0     666472      48216 hdbrsutil  --start --port

thdadm       3282        1   0.0      22584       3108 sapstart pf=/hana/shared/

thdadm       3290     3282   0.0     408556      64608  \_ /usr/sap/THD/HDB00/ha

thdadm       3308     3290  18.2   10262100    7585316      \_ hdbnameserver

thdadm       3516     3290   0.6    1980104     325736      \_ hdbcompileserver

thdadm       3519     3290  95.7    3273136    2684720      \_ hdbpreprocessor

thdadm       3566     3290  19.3    9409424    6882708      \_ hdbindexserver -p

thdadm       3569     3290   1.3    3081840    1151556      \_ hdbxsengine -port

thdadm       3939     3290   0.7    2236468     408212      \_ hdbwebdispatcher

thdadm       3070        1   0.1     499744      34608 /usr/sap/THD/HDB00/exe/sa

 

HANA DB 중지

thdadm@hanadb:/usr/sap/THD/HDB00> HDB stop

hdbdaemon will wait maximal 300 seconds for NewDB services finishing.

Stopping instance using: /usr/sap/THD/SYS/exe/hdb/sapcontrol -prot NI_HTTP -nr 00 -function Stop 400

 

19.01.2020 15:52:44

Stop

OK

Waiting for stopped instance using: /usr/sap/THD/SYS/exe/hdb/sapcontrol -prot NI_HTTP -nr 00 -function WaitforStopped 600 2

 

 

19.01.2020 15:53:16

WaitforStopped

OK

hdbdaemon is stopped.

 

HANA DB 시작

thdadm@hanadb:/usr/sap/THD/HDB00> HDB start

 

 

StartService

Impromptu CCC initialization by 'rscpCInit'.

  See SAP note 1266393.

OK

OK

Starting instance using: /usr/sap/THD/SYS/exe/hdb/sapcontrol -prot NI_HTTP -nr 00 -function StartWait 2700 2

 

 

19.01.2020 15:53:20

Start

OK

 

19.01.2020 15:54:14

StartWait

OK

 

6. HANA Studio 접속

방화벽 포트 확인

hanadb:~ # firewall-cmd --list-all

public

  target: default

  icmp-block-inversion: no

  interfaces:

  sources:

  services: dhcpv6-client ssh

  ports: 30015/tcp 30013/tcp

  protocols:

  masquerade: no

  forward-ports:

  source-ports:

  icmp-blocks:

  rich rules:

 

System DB 접속 정보 추가

 

Tenant DB 접속 정보 추가

 

 

참고자료:

https://blogs.sap.com/2015/01/06/sap-hana-db-installation-steps-part-2/

https://launchpad.support.sap.com/#/notes/2593824

https://help.sap.com/viewer/2c1988d620e04368aa4103bf26f17727/2.0.04/en-US/2709fc9936d747c0861e4c633c761886.html