Wednesday, 22 January 2020

To save one time password for your SAP logon shortcut

This is not an SAP Best practices and could lead to compliance issue *******


It is possible to save password of each SAP system in GUI Logon, which is very useful for  Security or BASIS people for non production system

Don’t save password of production system in GUI logon .

How to Save password :

1-      Create a Shortcut in SAP logon , and provide all details like  system, client and user id.
2-      By default the password field will be inactive, you can save the password by activating the same field using Reg Edit as below.
3-      Once it enabled, enter password and save
4-      To login, click on the shortcut which open the system without prompting the password.

To Enable password Field:-

1-      Start -> Run -> type “REGEDIT”
2-      In the Registry navigate to HKEY_CURRENT_USER > SOFTWARE > SAP
3-      Right click on SAP folder, then use select NEW > Key and name it “SAPShortcut”
4-      Right click on SAPShortcut folder, then use select NEW > Key and name it “Security”
5-      Right click on Security then New > String Value. Name the string “EnablePassword”
6-      Double click on EnablePassword and enter ’1′ in the Value Data field, then press OK and close Registry

7-      The password field should be enable now.

Tuesday, 21 January 2020

Crontab six fields


Crontab file consists of command per line and have six fields actually and separated either of space or tab.
The beginning five fields represent time to run tasks and last field is for command.
1)Minute (hold values between 0-59)
2)Hour (hold values between 0-23)
3)Day of Month (hold values between 1-31)
4)Month of the year (hold values between 1-12 or Jan-Dec, you can use first three letters of each month’s name i.e Jan or Jun.)
5)Day of week (hold values between 0-6 or Sun-Sat, Here also you can use first three letters of each day’s name i.e Sun or Wed. )
6)Command Or Tasks

Cloud connector cleanup procedure


1.navigate to the OS path  /opt/sap/ssc

 service scc_daemon stop
                                       restart
                                       start
2.To get the rpm name used in cloud connector

     rpm -qa | grep ssc

3.if any process are running in the above step, kill them

  1. To cleanup cloud connector system

                cd /opt/sap/scc

                          rm -rf*
  1.  rpm -e rpm name

                      rpm name for step 2
6.rpm -qa | grep ssc

    This time the result should be empty
     Just to ensure, the rpm removed completely.
7./tmp/ rm setup*
                      silentsapinst
8./install/ rm <hostname of the login>

Tuesday, 14 January 2020

AWS accessing tools

AWS offers numerous ways to create and manage resources. Following are the different ways to access the features offered by AWS.

AWS Management Console - A web interface for AWS.
AWS Command Line Interface (AWS CLI) - Commands for a wide set of AWS products.
***Command Line Tools***- Commands for individual AWS products.
AWS Software Development Kits (SDK) - APIs that are specific to programming language or platform.
Query APIs - Low-level APIs that are accessible using HTTP requests.

The AWS Command Line Interface is a unified tool that manages several AWS services from the command line and automates all the services through scripts.
aws-shell is a command-line shell program to offer productivity and ease features to aid advanced and new users of the AWS Command Line Interface.
Key Features Include:
  • Fuzzy auto-completion for Resource identifiers, Options, Commands.
  • Dynamic in-line documentation
  • Execution of OS shell commands
  • Export executed commands to a text editor

Saturday, 11 January 2020

How to extent sap data unit in sybase

In any database data units and log units are core places where the data of database resides. in this post  i am sharing the process of extending disk space of one data unit in Sybase.

In the below screenshots,  sapdata_1 to sap data _4 & saplog_1 to saplog_2 are available.

To extended the disk space of sapdata_4,execute the below commands:



% isql -Usapsa -SSOL -X
Password:
1> use master
2> go
1> disk resize name = "SOL_data_004",size="5G"
2> go
1> use master
2> go
1> alter database SOL on SOL_data_004 = '5G'
2> go




Note: the disk space from root is assigned to sapdata_4.