Wednesday 28 December 2011

OBIEE fans

One of my friend was writing excellent blog articles on OBIEE software. I would like to share the website with you guys.

OBIEE FANS

Monday 12 September 2011

sap securty training videos for free

Watch the following videos for FREE

SAP Security Training How to setup what can be changed in Child System

http://www.youtube.com/watch?v=KrH_dQSp6yk

SAP Transactions for Securing Custom Programs

http://www.youtube.com/watch?v=eHGURaUJsRs

Kernel Upgrade steps

 Here is the Procedure to Update your SAP Kernel

Stop all R/3 Processes and the Database

          % stopsap all

Stop SAPOSCOL process 

          % saposcol -d

Stop ListnerControl process by logging in as ora user

         %lsnrctrl stop

Download Kernel Patches

Copy Them to a directory on Central Instance

Backup Your Old Kernel (by renaming it or moving it)

uncar the downloaded files

After that restart your services in following order

Listner 
SAPOSCOL 
Database 
R/3

How to send Message to Specific user on SAP

Some-times we need to send a specific message to specific user in SAP which is not possible by using SM02..SO here is the trick to do it :

Use function module TH_POPUP
goto Transaction code SE37 enter the function module name & test run it
the the resulting screen is shown below, type the details and execute.
The user must be logged into the system to receive the message

How to update the SAP kernel

1. create a folder to store the kernel SAR file

2. copy the SAR file to the new folder

3. run sapcar -xvfSAPEXEDB* (database dependent)

4. run sapcar -xvf SAPEXE_* (database independent)

Step 3 and 4 are to extract the kernel

5. stop SAP console

6. stop SAP service

7. stop SAPoscol service

8. remove the SAPEXEDB___.SAR and SAPEXE__.SAR from the new kernel folder

9. copy everything from the new kernel folder to E:usrsapDVEBMGS00exe

10. copy everything from the new kernel folder to E:usrsapE05SYSexeucIA64

11. start SAPOSCOL and SAP SERvice

12. start SAP console

Note, Don't forget the backup before upgrade.

How to update using SPAM SAINT

Importing a SPAM/SAINT Update
Use:
A SPAM/SAINT Update (SPAM update for short) contains updates and improvements to Support Package Manager and Add-On Installation Tool. There is always one SPAM update for each release.

The latest SPAM update is also available in SAP Support Portal, under service.sap.com/spManager.

Make sure you always have the most recent version of SPAM update before importing Support Packages or Installation Packages.

Prerequisites
You can only import a SPAM update if there are no terminated packages in the system.

A dialog box informs you if there are any terminated packages. You then have two options:

? Import the entire queue to begin with and then the SPAM update.

? Delete the queue, import the SPAM update, then import the queue.

You can only delete the queue if module Import 1 has not yet started (up to phase SCHEDULE_RDDIMPDP).

Procedure
1. Call Support Package Manager (transaction SPAM).

2. Check if the SPAM update offered is newer than the one in your system.

3. To import the most recent SPAM update, choose Support Package ® Import SPAM update.

SPAM updates are automatically confirmed once they have been imported.

How will you check whether database active or not from OS

There are so many options to check whether DB is active or not1. ps -ef |grep ora2. ps -ef |grep ora_3. ps -ef |grep pmon4. R3trans -d ; give RC - 0000 means active other than 0000 is error5. in Brtools 1.Instance Management, 6 - Show instance status, 3-Database instance, give the instance name i mean Database Name and press continue....give the status s6. we can also check for SQLSQL> select status from v$instance;STATUS------------OPEN7. From SAPDBA, it will show the status on top.