How to get hardware key for SAP License from UNIX & Windows OS

 Hardware key is required for getting a license from SAP Service Market Place.  
Steps to get Hardware Key:  
For  UNIX and Windows operating System  
Login to the server with SIDADM user
Use command: saplicense –get

How to check the spool requests in SAP

spool request can be viewed in SP01 transaction as below :
 


                     Enter username or spool request number  or you can put * also





 
 execute to view the below list of spool requests


How to Close and Terminate a user session in SAP

GO to SM04 then user list will appear, Double-clicking on the User will bring up the sessions he has open. To close a session, select it and then click the "End Session" button.




 Sometimes  there will be a requirement to terminate a user session. An user has run a report or program with inappropriate selection criteria, which leads work process going to PRIV mode occupying so much memory impacting performance of the system. In those cases, you will have to check with the user and terminate his session or logoff user system wide if he is no longer working.

How to Delete SAP Client (SCC5)

Deleting a Client 


  •  From the SAP login screen, login as any super user in any existing client (which you want to delete)
  •  Access the menu path Tools -> Administration -> Client admin.-> Special functions -> Delete client. Alternately run transaction SCC5. 
  • In the resulting screen select the option ‘Delete from T000’ and click on ‘Online’ pushbutton in order to run the client delete in the foreground. Alternately administrator can also run this in the background by clicking the pushbutton ‘Background’

HOW to start,Stop, Start and bounce an Oracle Database

Connect as SYS DBA or SYSOPER privilege

Stop:

SQL> shutdown

Options

-NORMAL

-IMMEDIATE

-TRANSACTIONAL

-ABORT

START:

SQL> startup

Options

NOMOUNT

-MOUNT

-OPEN

BOUNCE:

SQL>startup force

It is a combination of shutdown abort + startup open (But beware of this command if there are other connections to database – they will be forcefully closed)

How to change column name of any table in Oracle?

Sometimes we might need to change column name in table, to do so

alter table <table name> rename column <column name to be changed> to <desired column name>

For example if you want to change column name from D_ID to DEPT_ID of DEPARTMENT table


alter table DEPARTMENT rename column D_ID to DEPT_ID;

What is Dispatcher in SAP







DISPATCHER:


  •  Program which manages resources of the SAP R/3 Applications
  •  Receives requests from user and passes them to the corresponding work  processes
  •  Only one Dispatcher per application server



DISPATCHER TASK:

  • Balances the workload between the processes
  • Buffer management in main memory
  • Connection with the presentation level
  • Organization of the communication Process

Difference Between Oracle Mount, No Mount and Open Stage?

NOMOUNT: This stage is only used when first creating a database or when it is necessary to recreate a database's control files. Startup includes the following tasks.

  •  Read the spfileSID.ora or spfile.ora or initSID.ora.
  • Allocate the SGA(System Global Area).
  • Startup the background processes.

MOUNT: This stage is used for specific maintenance operations. The database is mounted, but not open. You can use this option if you need to:
  • Rename datafiles.
  • Enable/disable redo log archiving options.
  • Perform full database recovery.
  • When a database is mounted it is associated with the instance that was started during NOMOUNT stage.
  •  locates and opens the control files specified in the parameter file.
  •  reads the control file to obtain the names/status of datafiles and redo log files, but it does not check to verify the existence of these files.
OPEN: This stage is used for normal database operations. Any valid user can connect to the database. Opening the database includes opening datafiles and redo log files. 
If any of these files are missing, Oracle will return an error. If errors occurred during the previous database shutdown, 
the SMON background process will initiate instance recovery


The startup process is Nomount -> Mount -> Open.