SAP BASIS

DATABASE CRASH WHEN IN BACKUPMODE OR SHUTDOWN ABORT

Recently had a DB crash and all the files were in backupmode. please follow below to start it up

1. Mount the database.
   SQL> STARTUP MOUNT
 



2. Find out which datafiles were in hot backup
   SQL> SELECT V1.FILE#, NAME
FROM V$BACKUP V1, V$DATAFILE V2
WHERE V1.STATUS = ‘ACTIVE’ AND V1.FILE# = V2.FILE#;


3. sql>alter database end backup


4. Open the database.

   SQL> ALTER DATABASE OPEN;
 
 
now try doing a shutdown immediate and a startup and confirm if DB comes up fine

 

Different Types of Users in SAP

Different Types of Users in SAP

1. Dialogue
2. System
3. Communication
4. Service
5. Reference
1. Dialogue:-
GUI login is possible.
Initial password and expiration of password are checked.
Multi GUI logins are checked.
Usage:- These are used for GUI logins.

2. System

GUI login is not possible.
Initial password and expiration of password are not checked.
Usage:- These are used for internal use in system like background jobs.

3. Communication
For this kind of users:-
GUI login is not possible.
Users are allowed to change password through some software in middle tier.
Usage:- These are used for login to system through external systems like web application

4. Service
For this kind of users:-
GUI login is possible.
Initial password and expiration of password are not checked.
Multiple logins are allowed.
Users are not allowed to change the password. Only admin can change the password
Usage:- These are used for anonymous users. This type of users should be given minimum authorization.
5. Reference
For this kind of users:-
GUI login is not possible.
Initial password and expiration of password are not checked.
Usage:- These are special kind of users which are used to give authorization to other users.

How to Change default SAP IMAGE on home screen

How to Change  default SAP IMAGE on home screen

  • Transaction code – SMW0
  • X – Binary data for WebRFC application
  • Hit Enter
  • Click Execute
  • Click Settings -> Maintain MIME types
  • Click the Create button
  • Fill in :- TYPE : image/gif EXTENSION : .GIF
  • Click Save
  • Click Back to the Binary data for WebRFC
  • Click Create
  • Fill in :- Obj. name : ZXXXX.GIF Description :
  • Company Logo
  • Click Import and specify the filename where your
  • GIF file is
  • located.File type is BIN. Finish press the
  • Transfer button.
  • If successful, your logo will be shown in the
  • Binary data for
  • WebRFC.
  • Transaction code SM30 – Table/View – SSM_CUST
  • Click Maintain
  • Click New Entries
  • Name Value to be set
  • START_IMAGE ZXXXX.GIF
  • RESIZE_IMAGE NO
  • Logoff and Login again

Procedure to reset TMSADM User

Procedure to reset TMSADM User

 

If you want to reset user TMSADM to the default, or if the configuration of this user was damaged, then:
1. Log on to the SAP system where you want to reset the TMSADM user. Call transaction STMS. Choose Overview > Systems. The system overview appears. Choose Extras > Reset User TMSADM. The system user TMSADM is regenerated with the default authorizations.

SE10,SE09,SE01 explained

SE10,SE09,SE01 explained

SE09 is the transaction code for workbench organizer. Workbench organizer is the set of utilities for development change management. All Development changes are tracked via Workbench organizer.

SE10 is for Customizing organizer. Customizing organizer is the set of tools for customizing change management. All customizing changes are tracked via customizing organizer.
SE01 is the main screen of the Change and transport Organizer. From here the administrator can achieve all tasks related to transport requests – such as create, change, view logs, display client/delivery transports,

Find the list of Tcodes executed by a user for a specific time period

Find the list of Tcodes executed by a user for a specific  time period

  • Go to ST03. Select choose for analysis. Choose only one application server at a time in case you have multiple application servers. Choose time period of your choice.
  • In the next screen from menu choose GO TO–>PROFILES->-USER PROFILES. Here you will get the list on users who have worked on that application server.
  • Double click on the required user and you will get all the transactions he/she has executed.
  • In case you select TOTAL in step 1 and then follow the steps 2 and 3 you will only get the list of application server on which the user has worked and not the transaction details.

How to Auto logoff inactive users in SAP

How to Auto logoff inactive users in SAP

To activate automatic logging off, do the following:

  • Go to Profile Maintenance by choosing Tools –> CCMS –> Configuration  –> Profile Maintenance or the transaction RZ11.
  • Maintain the parameter rdisp/gui_auto_logout. Enter the required number of seconds of inactivity before the user is logged off automatically.

To deactivate automatic logoff, delete the parameter from the profile(s) or set the value ‘0’.