SAP Database Start and Stop Steps:

SAP Database Start and Stop Steps Process:
In This Blog, we have explained the sap Database start and stop steps commands on OS level.
SAP ECC System run on Oracle database, DB2 Database, Max db Database, ASE Database & Hana Database.
SAP S/4 Hana System run on only Hana Database.

We have explained the SAP database  start and stop steps process on OS Level.

• OS Version: SUSE LINUX
• DATABASES:
• 1. SAP ASE16 –SYBASE
• 2. Db2 Database
• 3. Max db database
• 4. Oracle database
• 5. MS-SQL Database
• 6. Hana Database

1. SAP HANA Database:

SAP Hana Database Stop Process:
Sap hana database, we can stop and start the database multiple ways.

• OS Level using db SIDADM
• OS Level using SAP SIDADM
• OS Level using hdbsql level
• Hana Studio level
• Hana Cockpit level.

OS Level using db SIDADM:

• Login to DB sidadm
• su – sidadm
• Stop the hana database using below command.
• #HDB STOP

• Login to DB sidadm
• su – sidadm
• Start the hana database using below command.
• #HDB START

OS Level using SAP SIDADM:

• Login to SAP sidadm
• su – sidadm
• Stop the hana database using below command.
• #sapcontrol –nr xx –function StopSystem SID

• Login to DB sidadm
• su – sidadm
• Start the hana database using below command.
• ##sapcontrol –nr xx –function StopSystem SID

OS Level using hdbsql level (Tenant db) -Stop

• Login to DB sidadm
• su – sidadm
• Execute the below command for connect to hdbsql
• #hdbsql
• Stop the tenant database using below command.
• #Alter system stop database SID;
• After execute the above command , then only tenant db has stop.

OS Level using hdbsql level (Tenant db) -Start

• Login to DB sidadm
• su – sidadm
• Execute the below command for connect to hdbsql
• #hdbsql
• Stop the tenant database using below command.
• #Alter system start database SID;
• After execute the above command , then only tenant db has started
Sap hana databse also will start and stop using the Hana studio and hana cockpit..

How to check the Hana Database Status:

OS Level:
Sapconrol –nr xx –function GetProcessList
Hdbsql Level:
Select * from m_databases;

After execute the above command, if database is running then status showing Active. If database is not running then status No.

2.SAP ASE16 SYBASE:
SAP ASE –SYBASE DB Stop Process:

• Login to the DB sidadm
• Su – sidadm
• # cd /sybase/SID/ASE16.0/install
• #./STOP_SID command for start the db

SAP ASE –SYBASE DB Start Process:

• Login to the DB sidadm
• Su – sidadm
• # cd /sybase/SID/ASE16.0/install
• #./RUN_SID command for start the db

3.DB2 Database:
SAP DB2 Database Stop Process:

• Login to the DB sidadm
• Su – sidadm
• Execute the below command for stop the database.
• #db2stop

SAP DB2 Database Start Process:

• Login to the DB sidadm
• Su – sidadm
• Execute the below command for start the database.
• #db2start

4.MAX DB Database:

SAP Max db Database Stop Process:

• Login to the DB sidadm
• Su – sidadm
• Execute the below command for Connect the database.
• #dbmcli –d SID –u userid,password
• Once connected the database then execute the below command for stop the database
• #db_offline

SAP Max db Database Start Process:

• Login to the DB sidadm
• Su – sidadm
• Execute the below command for Connect the database.
• #dbmcli –d SID –u userid,password
• Once connected the database then execute the below command for start the database
• #db_online

5.Oracle database:
SAP Oracle Database Stop Process:

• Login to the DB orasid user
• Su – orasid
• Execute the below command for stop the lsnrctl
• Lsnrctl>stop or ./lsnrctl stop
• Execute the $ sqlplus /as sysdba
• execute the below command for stop the database
• #SQL>SHUTDOWN IMMEDIATE

SAP Oracle Database Stop Process:

• Login to the DB orasid user
• Su – orasid
• Execute the below command for start the lsnrctl
• Lsnrctl>start or ./lsnrctl start command
• Execute the $ sqlplus /as sysdba
• execute the below command for start the database
• #SQL>STARTUP
• Oracle database has started.

6.MS SQL Database:
SAP MS-SQL Database Stop Process:

• Execute the below for stop the ms-sql database.
• Systemctl stop mssql-server
SAP MS-SQL Database Start Process:
• Execute the below for start the ms-sql database.
• Systemctl start mssql-server
Command:
• Systemctl ACTION Service_name
• Using above command we can check the below details.
• ACTION: start , stop, restart, status.

Conclusion:

We have explained the sap database start and stop steps process on hana database, oracle database, DB2 database, mssql database & Sybase database.

Other Posts:

SAP HANA DB installation
SAP ASE DB OS Commands
SAP BO start and stop

FAQ for SAP DATABASE Start and Stop steps Process: