How to troubleshoot SAP router connectivity issue and renew of the SAP router Certificate

In this example it will shown the steps on how to troubleshoot the SAP router connectivity issue and the way to renew the SAP router certificate.

A) Issue: SAP global support unable to connect into the SAP system.

Steps to verify the SAP router connectivity at the SAP systems level

1) Execute TCODE: SM59 -> "ABAP Connections" -> double click "SAPOSS"

2) Click "Connection Test"

3) Sample error on the SAP router connectivity

B) Steps to check the SAP router validity and how to renew the certificate

Steps to check the SAP router certificate validity

1) Login to the system where the sap router been install with the <SID>adm account
    Execute: sapgense get_my_name -v -n Issuer, sapgenpse get_my_name
    Expired certificate that cause the SAP system connectivity failed.

Steps to renew the SAP router certificate

1) Login to the SAP support portal -> Maintenance & Services -> SAP Trust Center Services -> SAProuter certificates

2) Click "Apply Now"

3) Ensure the SAP router details been created and click "Continue"

4) Copy the "Distinguished name" to be use for certificate creation process later.

5) Login to the system where the sap router been install with the <SID>adm account
    Backup these files: certreq, cred_v2, local.pse, srcert

6) Stop the SAP router service

7) Execute: sapgenpse get_pse -v -r certreq1 -p local.pse
    Create a new PIN when prompt that will be use later in the certificate creation process
    Paste the distinguished name that copy from the SAP support portal previously

8) Examine that the "certreq1" file that been created. Copy all the contents of the file.

9) Paste the "certreq1" file contents into the SAP portal text box and click "Request Certificate"

10) Again copy all the contents generated from the portal.

11) Paste the copied contents into notepad and save in as "srcert" file in the SAP router folder

12) Install the certificate, execute: sapgenpse.exe import_own_cert -c srcert -p local.pse

13) Create the "cred_v2" file, execute: sapgenpse seclogin -p local.pse with the PIN created earlier (Step 7)

14) Check the newly created certificate and the validity date been updated
       Execute: sapgense get_my_name -v -n Issuer, sapgenpse get_my_name

15) Start the SAP router service

16) Test the connectivity with TCODE: SM59

How to open SAP system connection for SAP Global Support

There will be circumstances where the SAP systems required to be accessed by SAP Global Support team for troubleshooting ex: for system assessment, performance tuning and etc.

Steps:

1) Login to SAP support portal -> Help & Support -> Connect to SAP -> Maintain Connections

2) Select the SAP system to be connect by SAP global support.

3) Click on the R/3 Support hyperlink to configure to connections (if this is not appear, it required to create a new link from the "Set up Connections types" area at the bottom)

4) Click "Maintain Access Data" to save the SAP system login details

5) Enter the relevant SAP system login details

6) Enter the duration of the connection and click the "Start Service Connector" button

7) Wait until the service connector screen shown successful and click the "Yes" button

8) The SAP router status will shown connected

9) Use the "logbook" button to trace the connectivity details or TCODE: ST04 on the SAP System

Running SAP Load Generator SGEN after new installation or upgrade

What is SGEN?
- In new SAP Systems no ABAP is compiled until it is called for the first time.
- Each time a user starts an uncompiled ABAP he has to wait quite a long time for the ABAP to compile, seen as an "Compiling hourglass" in the SAPGUI.
- All used ABAPs are saved in the table "REPOLOAD“.
- SGEN is used to regenerate existing loads, which are compiled ABAPs.
- Each time an ABAP or its dependency is changed, it needs to be compiled again.
- SGEN should be run after every Support Package or upgrade, because the ABAP sources have been changed
- SGEN needs a lot of performance, recommend to run it when few users are accessing the system e.g. on the weekend
- The runtime of SGEN depends on your SAP-System.
- It is recommended to restart the system after SGEN is finished.

By running TCODE: SGEN (SAP Load Generator) to generate the ABAP loads of a number of programs, function groups, classes, and so on after new installation or upgrade.

Steps:

1) After installation or upgrade, program execution would require it to be compile or load as shown below and it take time to startup the program for the first time

2) Execute TCODE: SGEN (Select all for new installation or any other required option)

3) Select all or the relevant software components and click "Continue" button

4) Click "Continue" button

5) Use the Job monitor to view the running status

6) Example of the Job Monitor screen

7) Execute TCODE: SM50 to view the batch job processing details

8) Sample of the batch job details

9)  Sample of the batch job details

10) The process would normally required couple hours to be complete....

How to change the message in SAP GUI logon screen

Scenario: To customize the SAP GUI logon screen message after new installation / upgrade.

Steps to customize the SAP GUI logon screen:

1) The default logon message

2) Execute TCODE: SE61 -> Select Document Class as General text (TX) -> select preferable language -> Document Name as "ZLOGIN_SCREEN_INFO". Create a new one if it not exist or select Change to modified an existing one.

3) Change the message accordingly and once complete save and activate it. For insertion of icon refer to step 5 for getting the list of available icons in SAP system.

4) Click save and it will prompt for transport request creation.

5) For a list of all the icon available in SAP, execute the report "RSTICON" with TCODE: SE38

6) Select Icons as ABAP List.

7) All the icons available will be shown and use the "Code" in the message modification. Ex: @76@

8) Sample of the modified logon screen.

Simple isn't ...

Oracle: How to determine total memory assigned for SGA and PGA

By using SQLPlus or TCODE: DBACOCKPIT to determine the total memory assigned for System Global Area (SGA) and Program Global Area (PGA)

Steps for SGA:

Option 1: By using SQLPlus, 

Execute SQL Command: show sga (sample show ~4GB for SGA)

Option 2: TCODE: DBACOCKPIT

Tcode: DBACOCKPIT -> Performance -> Statistical information -> SGA Monitor -> SGA tab

Steps for PGA:

Tcode: DBACOCKPIT -> Performance -> Statistical information -> PGA Monitor -> PGA Status tab (Parameter: Total PGA allocated)