Certificates Expiring check report in ABAP system

 Steps:

1.Go to SE38/SA38

2.Execute the report : SSF_ALERT_CERTEXPIRE

3.Mention the Number of Days until Expiry and execute 

4.The certificates that will expire within 30 days have the expiration date in RED

STRUST data is stored in the tables:

SSF_PSE_D

SSF_PSE_H

TWPSSO2ACL

SAP Note: 2507235 - How to configure Expiring Certificates metrics in System Monitoring

How to connect to HDBSQL for System DATABASE and Tenant DATABASE

HDBSQL connection using Database name

System DB

                hdbsql -i XX -u USERNAME -p PASSWORD -d systemDB

Tenant DB

If you have one tenant DATABASE then connect using below command.

                

                hdbsql -i XX -u USERNAME -p PASSWORD

If you have more than one tenant DATABASE then connect using below command

                hdbsql -i XX -u USERNAME -p PASSWORD -d <database name>

HDBSQL connection using SQL/MDX port

System DB

                hdbsql -n localhost:3XX13 -u <user> -p <password>

Tenant DB

                

                hdbsql -n localhost:3XXXX -u <user> -p <password>

                

                

SAP HANA User Administration Activities

Depending on business needs and configuration of HANA system, there are different user activities that can be performed using user administration tool like HANA studio.

 Most common activities include −

 ·          Create Users

·          Grant roles to users

·          Define and Create Roles

·          Deleting Users

·          Resetting user passwords

·          Reactivating users after too many failed logon attempts

·          Deactivating users when it is required

Create Users in HANA Studio

  Database users can be created with either using the SAP HANA Studio /cockpit, or the             CREATE USER or CREATE RESTRICTED USER statement

 Standard Users

Standard users correspond to users created with the CREATE USER statement. By default they can create objects in their own schema and read data in system views. Read access to system views is granted by the PUBLIC role, which is granted to every standard user.

 Restricted Users

Restricted users are intended for provisioning users who access SAP HANA through client applications and who are not intended to have full SQL access via an SQL console. If the privileges required to use the application are encapsulated within an application-specific role, then it is necessary to grant the user only this role. In this way, it can be ensured that users have only those privileges that are essential to their work.

When you expand security tab, it gives option of User and Roles. To create a new user right click on User and go to New User. New window will open where you define User and User parameters

Enter User name and in Authentication field enter password. Password is applied, while saving password for a new user. You can also choose to create a restricted user.

Different Authorization methods can be configured like SAML, X509 certificates, SAP Logon ticket, etc. Users in the database can be authenticated by varying mechanisms Internal authentication mechanism using a password.

External mechanisms such as Kerberos, SAML, SAP Logon Ticket, SAP Assertion Ticket or X.509

Some users that are, by default, delivered with the SAP HANA database are − SYS, SYSTEM,

_SYS_REPO, _SYS_STATISTICS

Once this is done, the next step is to define privileges for user profile. There are different types of privileges that can be added to a user profile

Configure “Session client”

Create SAP HANA information models (attribute views, analytic views, and calculation views), it is possible to filter the data according to the client specified in table fields such as MANDT or CLIENT. You can specify the client relevant for the user here

Granted Roles to a User

SAP.HANA roles to user profile or to add custom roles created under Roles tab. Custom roles allow you to define roles as per access requirement and you can add these roles directly to user profile. This removes need to remember and add objects to a user profile every time for different access types

There are different types of privileges that can be added to a user profile. To add a system privileges to a user profile, click on + sign

System privileges are used for Backup/Restore, User Administration, Instance start and stop, etc

Several privilege types are used in SAP HANA (system, object, analytic, package, and application).

HANA Savepoint Mechanism

        

Automatic: 

During normal operation savepoint are automatically triggered when a predefined time since last savepoint is passed.

The timeline of savepoint is configured by following parameter:

Global.ini > persistence > savepoint _interval_s

Manual:

 To execute a manual Savepoint use this command.

ALTER SYSTEM SAVEPOINT;

Soft Shutdown:

A soft shutdown invokes savepoint. Hard shutdown does not invoke savepoint.

Backup:

A global Savepoint is invoked before a backup is started. A Savepoint is also performed after backup finishes.

How to extend Tablespace in oracle using BR tools

Open new cmdàrunàbrtools

Select option 2: (press 2)

Select option 1: (press 1)

Select option c: (press c)

Selection option c: (press c)

Selection option 1: (press 1)

Then select the table we need to extend:

Select option 1: (press 1)

Automatically it will take 10GB else we need to give size in option 5

Select option c(thrice):

Table space extended successfully.

How to Deploy XPI-Inspector tool

Deploy XPI-Inspector tool for Tracing PI issues.

XPI_Inspector:

The XPI Inspector tool was developed by SAP for collecting information about the configuration and traces and to improve the troubleshooting of PI issues.

Using XPI Inspector application you will be able to collect a lot of information about your system that will help you to learn about problems in the past, to analyze new and detect such at an early stage

Open the start page of the application by using the following url address: 

http(s)://<host>:<port>/xpi_inspector 

Before Deploy XPI inspector tool.

1.Download the xpi_inspector_x.ear file from service market place.

You can deploying the tool using telnet.

Open telnet. For this, use putty system or call the command telnet <host> <http port + 8>

Login as admin user.

Insert the following commands:
add deploy

deploy <xpi_inspector_ear.ear file path> version_rule=all

Deploy completed successfully.!!

After Deploy the XPI inspector tool.

How to Trace:

1. Select relevant Example 

2. Activate the relevant options:

• Collect debug traces from Messaging System
• Collect debug trace from XI Module Processor

3. Press Start

4. Reproduce the issue

5. Wait until the issue occurs

6. Press Stop

7. Result Page will appear