Hana database issue troubleshooting Popular 1

By kssaplearning

Published on:

Follow Us
Hana database issue

Hana database issue Part1

Hana database issue Part1 :
In this blog,  we have explained the few Hana Database issue  in Hana Database issue Part1.

Issue:

• Unable to login Hana database through Any user
• Hana database schema password update –After DB restore

1.Unable to login Hana database through Any user:

Issue : Unable to login Hana database through Any user:
In this case, we will unable to connect Hana database using Hana studio and Hana Cockpit.
Only option to reset the System user password in OS level using index server.

Hana System user Reset through Index server:

We are unable to login Hana database through system user or other users and we don’t have credentials for other users id. In This case we will reset the SYSTEM user id password using index server for emergency mode. This process depending on Hana database version. We can perform the Hana database SYSTEM user id password reset in HANA1.0 and HANA2.0 Version. Both process is similar but we need to understand the Hana1.0 and Hana2.0.
Hana Database System user id password reset using index server in emergency mode:                                              Hana database 2 version has released.

1. Hana Database 1.0
2. Hana Database2.0

Hana1.0: Single container DB:

• Stop the SAP Application
• Stop the Hana database
• Start the Hana database nameserver
• Start the Hana Compiler server
• Reset the passwords using index server

Hana2.0: Multi container:

• Stop the SAP Application
• Stop the Hana database
• Reset the passwords using index server.

HANA1.0 System user password reset using index server:

Steps:

• Stop the sap application using below command.
• Login to the sap application SID and execute the below command
• Command:
#sapcontrol –nr xx function StopSystem ALL
• Once Application has stopped then stop the Hana database using the below command
• Command:
#sapcontrol –nr xx function StopSystem DBSID or
• We can stop the hana database using DB SID.
• Login to the Hana db sid user
• #Su – sidadm
• Execute the below command for stop the database.
• #HDB stop.

Once Application and database has stopped then we can perform the below command for further process.

Start the nameserver

• Login to the Hana database DBSID user
• # su – sidadm
• Goto the below path and execute the command for start the nameserver.
• Path: 1. /usr/sap/SID/HDBXX/
            2./usr/sap/SID/HDBXX/exe                                                                                                           Based on path, execute the commands.
• #su – sidadm
• #cd /usr/sap/SID/HDBXX
• # ./hdbenv.sh
• # cd /usr/sap/SID/HDBXX/exe
• # ./hdbnameserver

Start the compiler Server:

• Open the another terminal on putty abd start the compiler server.
• #su – sidadm
• #cd /usr/sap/SID/HDBXX
• # ./hdbenv.sh
• # cd /usr/sap/SID/HDBXX/exe
• # ./hdbcompileserver

Once started the name server and compile server then execute the password reset option. Open another terminal on putty then reset the system user using the index server.

Hana db password reset using index server:

Execute the following command:
• #su – sidadm
• #cd /usr/sap/SID/HDBXX
• # ./hdbenv.sh
• # cd /usr/sap/SID/HDBXX/exe
• # ./hdbindexserver –resetUserSystem

After execute the command, then enter the new password and confirm the password.
System user password updated successfully. The stop the all services or kill the process and start the Hana database and check the password in Hana studio or Hana cockpit.
We have successfully reset the SYSTEM user ID in Hana 1.0 database.

HANA2.0 System user password reset using index server:

Steps:

• Stop the sap application using below command.
• Login to the sap application SID and execute the below command
• Command:
#sapcontrol –nr xx function StopSystem ALL
• Once Application has stopped then stop the Hana database using the below command
• Command:
#sapcontrol –nr xx function StopSystem DBSID or
• We can stop the hana database using DB SID.
• Login to the Hana db sid user
• #Su – sidadm
• Execute the below command for stop the database.
• #HDB stop.

Hana database password reset using index server:

Hana database issue

Execute the following command:
• #su – sidadm
• #cd /usr/sap/SID/HDBXX
• # ./hdbenv.sh
• # cd /usr/sap/SID/HDBXX/exe
• # ./hdbindexserver –resetUserSystem

Enter the new password and confirm the password.
System user password updated successfully. The stop the all services or kill the process and start the Hana database and check the password in Hana studio or Hana cockpit.
We have successfully reset the SYSTEM user ID in Hana 2.0 database.

2. Hana database schema password update –After DB restore
After DB restore activity, we have started the SAP Application but sap application has not started and R3Trans getting RC12 error. As per trans.log , we have identify the authentication error for the Hana database.
In This case we need to update the schema password in Hana database.

Command:
• Login sap sidadm in OS level
• # su – sidadm
• Execute the below command for update the schema password/update the port/key details
• Command:
# Hdbuserstore SET DEFAULT localhost:3xx15 schemauser Password

Once executed the above command then schema password has updated in hdbuserstore.
Check R3trans -d command getting RC=0 status and Application has been started successfully . we have explained 2 issues in Hana database issue blog. 

Conclusion:

We have explained the few Hana database issue. Next Blog we have explained the more Hana database issue and Hana database performance issue.

Hana database issue

Hana database issue

Other posts:

SAP HANA Cockpit installation steps

 

 

 

2 thoughts on “Hana database issue troubleshooting Popular 1”

Leave a Comment