SAP HANA XS stands for Extended Application Services
. These components are necessary to execute steps from option A.
From the an operating system console, switch to the root user with command:
sudo su -
As root, execute the following commands, replacing HXE_SID
with the System ID that you chose during setup. This is, most likely, HXE.
/hana/shared/<<HXE_SID>>/global/hdb/install/bin/hdbupdrep --content_directory=/hana/shared/<<HXE_SID>>/global/hdb/auto_content
/hana/shared/<<HXE_SID>>/global/hdb/install/bin/hdbupdrep --content_directory=/hana/shared/<<HXE_SID>>/global/hdb/auto_content/systemdb
For each command, the installer will ask for user SYSTEM and its password, which needs to update the installation. In this example, the system ID was set to HXE
during setup:
Second command:
Finally, log in to the database using command hdbsql
to enable the statistics server. Replace XX with the instance number below:
sudo su - hxeadm
hdbsql -i XX -n localhost:3XX13 -u SYSTEM -p <SYSTEM user password> "alter system alter configuration('nameserver.ini','SYSTEM') SET ('statisticsserver','active') = 'true' with reconfigure"
If you are having trouble with the password, you can also log in first and execute the command later:
Then cast the last set of commands:
CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::EditorDeveloper','SYSTEM');
CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::CatalogDeveloper','SYSTEM');
CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::SecurityAdmin','SYSTEM');
CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::TraceViewer','SYSTEM');
ALTER SYSTEM ALTER CONFIGURATION ('webdispatcher.ini', 'system') SET('profile', 'wdisp/system_auto_configuration') = 'true' WITH RECONFIGURE;
Type quit
to exit the SQL console.
You can check the installation by opening URL http://<<hostname>>:80XX/sap/hana/ide/
and logging in with user SYSTEM: