SAP BASIS Support and Training Jobs

SAP BASIS Consultant Jobs , SAP BASIS Training, SAP BASIS Tutorials

Wednesday 26 September 2018

SAP HANA Log Volume Full

Log Volume is full & HANA DB, SAP system is not responding the follow the below steps to resolve the issue.



If we manually remove some file from the directory, data loss will happen & Hana system won't cam up after that. Recovery is the only option if we remove the file manually.

Issue - /hana/log - 100%

Solution -

* Stop HANA DB
   HDB Stop 

* Go to /hana/log/SID/mnt0001

   default location - /usr/sap/SID/global/hdb/log/mnt0001

 * Move one volume temporarily that having more than 2 GB to another location where         enough space is available.
  
   To start Hana DB at least 2 GB space is required, 

   Check the folder size using - du -ksh *

 * Move a volume which consumes 2 GB of space 
    eg - hdb0002

    mv hdb0002 /usr/sap/SID/global/hdb/data
    or
    mv hdb0002 /hana/backup/SID (if you are using separate volume for log)

 * Create symbolic link to the new folder in the old location

    In -s hdb0002 /usr/sap/SID/global/hdb/data/hdb0002 /usr/sap/SID/global/hdb/log/mnt0001 /hdb0002 

  * Start the HANA Database
     HDB start

 * Wait until log backup are performed 

 * Use the following SQL command to clean up the log volume 

    ALTER SYSTEM RECLAIM LOG;

 * Stop the HANA database & Remove the symbolic link

    rm -f /usr/sap/SID/global/hdb/log/mnt0001 /hdb0002 

 * Move  the log volume back to the original location

    mv hdb0002 /usr/sap/SID/global/hdb/log/mnt0001 

 * Start the HANA Database again

    Now the Volume size will be fine.

Reference - SAP note 1679938

Thursday 26 May 2016

SAP HANA Installation Using GUI

Hi all,

Installation steps of HANA database using GUI    


1) Download SAP HANA file  from  SAP service market place
2) Loginto with " root user " or SIDadm user
3) Go the directories which you the HANA  file using command 
 cd <installation medium>/DATA_UNITS/HDB_LCM_LINUX_X86_64
4) Start SAP HANA platform lifecycle management tool:
5) Find the file and execute “./hdblcmgui --components_username=/DVD”

It will show a screen like in the image bellow, 
Mainly 5 phases in HANA installation

There is an option "Add Component Location", Using that we add the additional HANA component    location in  our server (show in bellow image)                                                                                                                                       
                                  

If we have no additional components, Click *Next                                                                                  



If we updating an existing system , we have 1st option and select system SID. Here we using "New    Installation " so select the 2nd option *Install New System then, *Next                                                               


Here we can select additional components we want to install, select then *Next                                       


2 Types of HANA Data Base installations are there,                                                                                                 
          1) Single Host System                                                                                                                                2) Multiple Host System                                                                                                                           We are using Single Host system so select 1st option and click *Next                                                                                                        
              


Here, Specify the HOST NAME, Installation path, SID, Instance Number , Database mode and system usage. Allocated Memory usage we select " Restart Instance after system reboot " and then Click *Next


Here select the " Location of Data volume and Log volume, The click *Next                                          


Enter the "Server Name on Certificate host name space", then click *Next                                          

                                                                    

Here giving SIDadm user password, type password for SIDadm and click *Next                                 
                                                                 


Here giving Database user password, type password for Database user and click *Next 





Here we can see the summary of parameters and installation components , if any changes we can      change it using *Previous option, if fine click *Install Option.                                                              
                                                                         
                            

 Installation process in progress,                                                                                                                  

                                                                           


Installation completed successfully, we can see the logs also.    
Click *Finish option.

SAP HANA Database installation competed successfully.

Wednesday 25 May 2016

Creating Roles in SAP - PFCG

Hi all,

Mainly 5 Types of Roles in SAP

1)     Single Role2)     Composite Role3)     Derived Roles4)     Orphans Role5)     Reference Roles


Single Role 

Single role is role which generally does not have a Org level.

Composite Role


A composite role is a container with several different roles.Composite roles do not contain authorization data. If you want to change the authorizations (that are represented by a composite role), you must maintain the data for each role of the composite role. Maximum 164 Single can be added in a Composite role.

Derived Role

A Derived role is the copied role from a master role, coping transaction and authorization object. 

Orphans Role

Orphans Roles are Stand-alone roles and are many a times required for IS uses/. So a System Admin role, a Security Auditor role and many other special roles mainly not used in Business side are created as ORPHANS. This role limits the user to a particular organization.

Reference Role

They are SAP standard Roles.


Here we will discuss about how to create roles in SAP

PFCG Tcode is using to create Roles in SAP

Enter PFCG




 Here, fill the Role column. All roles created with users must be start with "Z or Y".                         
  
After the Role name, Click on the 'Single Role' button (here we discuss about single role)               
     
It goes to the Description tab,                                                                                                               


In top fill any description about the the Role and at the bottom  give detailed description .                
                
Then *Save and next click on the * Menu Tab                                                                                       
              

Click on the *Transaction button, the it shows another window like in the image. Add transaction you want to add in the role and *Enter to next tab after complete click on *Assign Transaction Button      


Then the *Menu tab shows green , and the Role menu shows the assigned roles like in the image.   

 Go to next tab *Authorization                                                                                                                
                                                                                                  

Click on the *Propose Profile names Button (Shown in the Figure), it will create a Profile name and   profile text automatically (Show in next Figure)                                                                                    



 Click on *Change Authorization Data Button, Save                                                                                


Here the Organization level values are given by the Functional Team if it is not then click on           
        *Full Authorization and then *Save                                                                                                                 

     

Then Click on the *Generate button on the Top, it will generate the Profiles for the Roles then       
      *Back to Authorization Tab  click on *User tab                                                                                                            



Here we adding the Role to the users we want. Enter the user name on the User ID area and *Enter,     after completing User Id's Click on the *User Comparison Button then *Save , Its Competed.                                
             






                                                                                                                     



                                                                   
  

                                                            






Monday 22 June 2015

SAP SUM Tool (Software Update Manager)

What is SUM?

SUM Stands for Software Update Manager .It’s a multipurpose tool that used to perform release     upgrade , Enhancement package installation ,applying or upgrading support package stack(SPS) and can upgrade a single component on SAP netweaver, Java Patches, Correcting Installed Software Information, Database Migration Option (DMO) .
.
Why SUM?

Usually SPAM\SAINT tool are used to upgrade components in SAP netweaver. By using SUM we can
·         * Minimize Downtime.
·         * Shadow system .
·         * Unicode conversion supported in enhancement package scenario.
·         * Support for selectively installable instances.
·          
Download SUM latest version from Market Place

Either by the path in SAP Software Download Center to download the SUM: Ã  Support Packages and Patches Ã  A - Z Index Ã  S Ã  SL TOOLSET Ã  SL TOOLSET 1.0 Ã  Entry by Component Ã  SOFTWARE UPDATE MANAGER (SUM) Ã  SOFTWARE UPDATE MANAGER 1.0 Ã  Support Package Patches Ã  <your OS> Ã .

OR By the path shown in the figure.




Here i'm upgrading Solution manager 7.1 SR1 with SPS04 to the latest SPS13 .Download the SPS13 Exports from the market place and put it in a folder. After completing SUM tool download , UNCAR the Sum tool into a folder using sapcar.




Once you have downloaded & extracted the SUM tool, start the SUM tool:   ./STARTUP .For that Log in as <SID>adm , And open command prompt with ‘RUN UNDER ADMINISTRATOR’ , from the directory run the STARTUP.bat file through command prompt.




Open up your browser and type the URL <http://<yourdomain.com>:4239> 
Where <yourdomain> is the host name ,and 4239 is the default port that opened for SUM.




It will open a screen asking username and password to operate the SUM .Fill the entries at once and it ll pass to the next screen. Click on the Next button






Enter The password for <SID>adm user


Select the Stack.XML file located in the SPS directory  -> Next.


In the next screen find the Keyword From the SAPNOTE given.



5.1 initialization :-

 Once the confirm target phase completed the installation will start ,The first phase initialization will start .



5.2 Extraction :

Once the Initialization phase Completed ,by clicking Next the next phase Extraction will start.




While in the Extraction phase SUM will ask for the DDIC Password.



In order to run SUM ,the SAP instance which we have to make change should be active ,otherwise this phase will throw some error like this..Click continue 

SUM will now check for the SPAM\SAINT version we can manually or automatically upgrade to its latest version.




5.3 Configuration phase:-  

And with in some time Extraction phase will be over and enter to the Configuration phase by clicking next.In that phase we ought to select and give some settings maually like below:-







Enter the Keyword from the SAPNOTE.


If you want to  adjust SPAU/SPDD objects  or simply click continue



5.4 Checks Phase:- 

After Completion of Configuration phase by clicking next we are entering into the Checks phase where SUM checks for the requirements for SPS upgrade.


5.5 Preprocessing Phase:- Next Step is preprocessing phase .



Perform the Backup



5.6 Execution Phase:-

 Next step is Execution The software update manager will now perform the actual update in the system. 




Postprocessing Phase :-

 Once the Execution Phase completed SUM will enter into the Postprocessing steps.


click continue button



5.6 Finalization Phase:- 

At last Finalization step ,No manual actions required in this phase 

Summery :-


 Done!! Now the SPS of your system has been upgraded.To Check whether the upgrade completed or not ..
Goto https://support.sap.com/release-upgrade-maintenance/pam.html and see the components and there levels and compare it with the current SAP system components (Goto SPAM\SAINT >> Package level )and check the component SP level with SP level of the SPS in PAM(product availability matrix)

Download SAP BASIS Mobile APP

Download SAP BASIS Mobile APP

Sponsor