Display Schema List on SAP HANA Database

SAP users can get the list of all schemas created on SAP HANA database with the schema owner name by executing SQL query on SYS.Schemas view.

Here is the SQLScript SELECT statement for database developers to display and return the list of all schemas on the HANA database.


select
 schema_name,
 schema_owner
from sys.schemas;

-- or using the public synonym

select * from schemas;

SAP BASIS - Starting and stopping SAP system instances - startsap/stopsap are deprecated

Symptom

The scripts startsap and stopsap are deprecated and you need alternatives.

Environment

Systems based on SAP NetWeaver 7.0 or higher

Cause

The scripts startsap and stopsap used to start and stop SAP systems, are deprecated since April 2015.
These scripts are no longer maintained, and should not be used.

Resolution

Instead of using startsap or stopsap,  use the SAP Management Console (SAP MMC) or the SAP command sapcontrol

  • sapcontrol

    Scripts startsap/stopsap use internally sapcontrol command to start and stop the SAP system, hence it is possible to use it manually.
    Follow the syntax for sapcontrol call, corresponding to startsap/stopsap:

     - In order to start the system, instead of using startsap, use:

        sapcontrol -
    nr <instance_number> -function StartSystem
     - In order to stop the system, instead of using stopsap, use:

        sapcontrol -
    nr <instance_number> -function StopSystem
    For the complete option list of methods, run sapcontrol without any parameters options to see the available list.


Note: 763593 - Starting and stopping SAP system instances - startsap/stopsap are deprecated

Steps to retrive the SAP HANA Cockpit URLs

Steps to retrive the SAP HANA Cockpit URLs

1 . Use ssh to connect to the SAP HANA cockpit server as SIDADM

2 . Logon to the XS Advanced with the command xs login
User name: cockpit_admin
Password: <Installation master password>

3 . List the XS Advanced applications with the command xs apps
The SAP HANA cockpit manager is listed as cockpit-admin-web-app
Teh SAP HANA cockpit is listed as cockpit-web-app

SAP SPAM--How to cleanup new support packages list

Go to SPAM -> Environment -> Electronic Parcel Service -> Goto -> Inbox Then you can put a check mark next to the support packages that you want to delete. This removes the support package from the queue.