Skip to Content

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.
To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. 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

    (0) 

Leave a Reply