Skip to Content
Author's profile photo Former Member

SAP HANA System copy – part 2/2 (SAP System Installation)

In this 2-part document, the steps of a new test server installation via system copy of development system are described. In the first part you find HANA DB installation steps. In the second part you find the SAP System installation steps and some main postprocessing steps. In our scenario, SAP System and HANA DB run on different servers. SAP System is based on NW 7.40. For the first part (HANA DB Installation) plese see : SAP HANA System copy – part 1/2 (HANA DB Installation)

Main SAP Note : http://service.sap.com/sap/support/notes/1844468

I’ve downloaded the main guide for the installation with S-User and password via that link: https://websmp104.sap-ag.de/~sapidb/011000358700000877172012E

Then please go through: SAP HANA Database->Unix.

For the filesystems, prerequisites and preparations for the system, you should look at the guide. The latest version of SWPM is strongly recommended.

Here are main steps and screenshots of primary instance installation on the new server:

  • Create a backup of the source system via SAP HANA DB Studio.

2016-04-13 12_49_27-HANA Systemkopie von KHD_KED auf KHQ_KEQ - OneNote.png

2016-04-13 12_49_42-HANA Systemkopie von KHD_KED auf KHQ_KEQ - OneNote.png

  • Copy the backup files to the target server. The name of the backup will be used as SWPM input.

2016-04-13 12_49_56-HANA Systemkopie von KHD_KED auf KHQ_KEQ - OneNote.png

  • SID is the system ID of application server (SAP System). It differs from DB SID. 7.40 Kernel DVD number is 51049350.

2016-04-13 12_50_05-HANA Systemkopie von KHD_KED auf KHQ_KEQ - OneNote.png

2016-04-13 12_50_13-HANA Systemkopie von KHD_KED auf KHQ_KEQ - OneNote.png

  • Hostname of the server where HANA DB is installed. Also DB SID and HANA system number (from part 1/2) should be given. All DB-related passwords MUST be same with the source system DB.

2016-04-13 12_50_22-HANA Systemkopie von KHD_KED auf KHQ_KEQ - OneNote.png

2016-04-13 12_50_34-HANA Systemkopie von KHD_KED auf KHQ_KEQ - OneNote.png

  • The name of the source system’s backup. And the location where the backup files have been moved in the first step above.

2016-04-13 12_50_42-HANA Systemkopie von KHD_KED auf KHQ_KEQ - OneNote.png

2016-04-13 12_51_51-HANA Systemkopie von KHD_KED auf KHQ_KEQ - OneNote.png2016-04-13 12_52_08-HANA Systemkopie von KHD_KED auf KHQ_KEQ - OneNote.png2016-04-13 12_52_23-HANA Systemkopie von KHD_KED auf KHQ_KEQ - OneNote.png

  • Latest kernel DVD has been downloaded and pointed to SWPM, in order to save time and effort. So we don’t need to patch default SWPM kernel.

2016-04-13 12_52_34-HANA Systemkopie von KHD_KED auf KHQ_KEQ - OneNote.png

  • Check your inputs once again and execute the installation.

2016-04-13 12_54_14-HANA Systemkopie von KHD_KED auf KHQ_KEQ - OneNote.png

  • ERROR DURING INSTALLATION and SOLUTION

Root cause was unsuccessful connection attempt to the database. The reason was that “.KEY” and “.DAT” files had not been created properly. R3trans -d testing was also unsuccessful.

sapinst_dev.log

WARNING 2016-04-04 17:34:57.434 (root/sapinst) id=modlib.jslib.childAppReturn

Execution of the command “/usr/sap/SID/SYS/exe/uc/linuxx86_64/saplikey pf=/usr/sap/SID/SYS/profile/SID_DVEBMGSSN_HOST -install_first_temp N1211111111 XXXXXX” finished with return code 2. Output:

saplikey: failed to connect to the database.

ERROR 2016-04-04 17:34:57.436 (root/sapinst) id=nw.processError errno=CJS-30023

Process call ‘/usr/sap/SID/SYS/exe/uc/linuxx86_64/saplikey pf=/usr/sap/SID/SYS/profile/SID_DVEBMGSSN_HOST -install_first_temp N1111111 XXXXXX’ exits with error code 2. For details see log file(s) saplikey.log, dev_slic.

ERROR 2016-04-04 17:34:57.583 (root/sapinst) id=controller.stepExecuted errno=FCO-00011

The step createTempLicense with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|onehost|0|NW_CI_Instance|ind|ind|ind|ind|ci|0|NW_Temp_License_ABAP|ind|ind|ind|ind|lic|0|createTempLicense was executed with

status ERROR ( Last error reported by the step: Process call ‘/usr/sap/SID/SYS/exe/uc/linuxx86_64/saplikey pf=/usr/sap/SID/SYS/profile/SID_DVEBMGSSN_HOST -install_first_temp N111111111 XXXXXX’ exits with error code 2. For details

see log file(s) saplikey.log, dev_slic.).

SOLUTION

The hdbuserstorelist command should give the following outputs on the servers where SAP Instance and HANA DB are installed:

<DB_HOST>:HDB:<DB_SID>adm /usr/sap/<DB_SID>/HDB<HANA_SN>> hdbuserstore set SYSTEM <DB_HOST>:3<HANA_SN>15 SYSTEM <PASSWORD>

<DB_HOST>:HDB:khqadm /usr/sap/<DB_SID>/HDB<HANA_SN>> hdbuserstore list

DATA FILE       : /home/khqadm/.hdb/<DB_SID>/SSFS_HDB.DAT

KEY FILE        : /home/khqadm/.hdb/<DB_SID>/SSFS_HDB.KEY

KEY DEFAULT

  ENV : <DB_HOST>:3<HANA_SN>15

  USER: SAPSR3

KEY SYSTEM

  ENV : <DB_HOST>:3<HANA_SN>15

  USER: SYSTEM

<PAS_HOST>:SAPSIDadm> hdbuserstore set SYSTEM <PAS_HOST>:3<HANA_SN>15 SYSTEM <PASSWORD>

<PAS_HOST>:SAPSIDadm> hdbuserstore list

DATA FILE       : /home/DBSIDadm/.hdb/PAS_HOST/SSFS_HDB.DAT

KEY FILE        : /home/DBSIDadm/.hdb/PAS_HOST/SSFS_HDB.KEY

KEY DEFAULT

  ENV : <DB_HOST>:3<HANA_SN>15

  USER: SAPSR3

KEY SYSTEM

  ENV : <DB_HOST>:3<HANA_SN>15

  USER: SYSTEM

  • After successful installation, install SAP HANA License via SAP HANA DB Studio. Right click DB there and select properties->licenses. License key is requested from service.sap.com.

2016-04-13 13_06_47-HANA Systemkopie von KHD_KED auf KHQ_KEQ - OneNote.png

  • Post system copy steps can be checked from the guide.

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Vladimir Kogan
      Vladimir Kogan

      Hi!

      Thank you for a guide.

      How can I copy , for example. DEV system to QAS, based on HANADB and change the ABAP SCHEMA from SAPDEV to SAPQAS?

      Regards

      Vladimir

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Vladimir,

      Have a look at Schema conversion after HANA refresh

      Actually you won't need to do this. If you must you can export/import your DB. There is some clues about HANA DB Studio in that link I've sent.

      Good luck,

      Serhat

      Author's profile photo Ashutosh Chaturvedi
      Ashutosh Chaturvedi

      Hi Serhat Yüceant,

      Very nice blog. learn something very new.

      With Regards

      Ashutosh Chaturvedi