How to List All the T-codes For a Role in SAP ?

Hi All,

Here I am sharing the procedure more-over its a trick to get all the t-codes from a Role.


To find all tcode for role along with the tcode that are present in the tcd field.. goto se16 enter agr_1251 and click on data browser button
enter the role name in agr_name field and enter tcd in FIELD field
Then click on execute button or press F8 to execute and you will see the list of tcodes for that role



Regards,
Gagan Deep Kaushal

Oracle Expertize

HI All,

Here i am sharing the steps i follow to patchset Oracle from 10.2.0.2 to 10.2.0.4 and activate Oracle enterprise manager

1) Activate OEM in SAP
emca -config dbcontrol db -repos create
Then Provide info as it ask
emctl start dbconsole
then point your browser at http://Srevr_name:5500/em

Note :386413 enterprise manager configuration oracle
592393 - FAQ: Oracle
355770 - Oracle Enterprise Manager Database Control
105047 - Support for Oracle functions in the SAP environmt

2) Note 871096 - Oracle Database 10g: Patch sets/patches for 10.2.0
Note 839187 - Oracle Database 10g: Patch set installation
Note 509314 - Downloading Oracle patches from SAP Service Marketplace
Note 839182 - Oracle database 10g: OPatch
Note 1137346 - Oracle Database 10g: Patches for Release 10.2.0.4

3) Download Patchset From Service Market Place
509314 - Downloading Oracle patches from SAP Service Marketplace====IMP
Sap Provide Patch in .bin format (Here i waste My full Day)
To get the original zip-file back, use the following commmands for:

UNIX cat aa.bin ab.bin ... >> .zip
Windows copy aa.bin /B + ab.bin /B + ... .zip
4) Now run runinstaller for Patchset before that shutdown DB and all services

5) Post Upgrade Steps:Database upgrade from Release 10.2.0.2 -> 10.2.0.4
When you upgrade a database from Oracle Release 10.2.0.2 to 10.2.0.4, you need to adapt the Oracle Dictionary to the new Oracle version during postprocessing. In this case, catupgrd.sql must run in accordance with the defaults described in the patch set documentation.


dbua -silent -dbname $ORACLE_SID -oracleHome $ORACLE_HOME -sysDBAUserName sys -sysDBAPassword bandhan6 -recompile_invalid_objects true

@/oracle/SID/102_64/rdbms/admin/catupgrd.sql

@/oracle/SID/102_64/rdbms/admin/utlrp.sql
emca -upgrade db


@/oracle/SRP/102_64/rdbms/admin/catupgrd.sql

6) Apply Opatch :Displaying the OPatch version
% opatch version

Displaying the online help
% opatch -help

Displaying the online help for a certain command
% opatch -help
= apply, rollback, lsinventory, util

Displaying the Oracle inventory (see below)
% opatch lsinventory [-all][-detail]

Installing a patch (see below)
% opatch apply

Uninstalling a patch (see below)
% opatch rollback -id



That's All but you can face different problems while following this so ping me AnyTime:



Regards,
Gagan Deep Kaushal

SAP T-Codes

Hi All ,

Here I am sharing List of T-codes that can help you lot in case you are facing some
Problems.

1) SWU3:RFC destination warning in workflow custom. check Automatic Work Flow Customizing

2) SUCOMP : User Company Address Maintain

3) STZAC: Customizing Time-Zones

4) SWF_XI_CUSTOMIZING:Automatic Work Flow Customizing For XI

5) SXMB_ADM:Integration Engine Administration

6) SOST :SAPConnect Transmission Request Overview With Log

7) SMSY: In Solution Manager To Define System

8) DSWP:In solution Manager To Check EWA / MOPz

Some Useful Unix-Command

Hi All,

Here I am listing Som useful Unix-Solaris command that can help you while administrating SAP with this combination:

1) /usr/sbin/prtconf | grep Memory To Find Memory

2) To Check th eValue of Variable rlim_fd_cur
adb -k /dev/ksyms

rlim_fd_cur/D *** This will display the current value

ctrl-D *** This quits you out of the debugger.
3) usermod example - Add a existing user to existing group
Add existing user tony to ftp supplementary/secondary group with usermod command using - a option ~ i.e. add the user to the supplemental group(s). Use only with -G option :

# usermod -a -G ftp tony

4) Change existing user tony primary group to www
# usermod -g www tony

5) Make is located at /usr/ccs/bin/make or you can download related
version of make pkg from this freebe location.
http://sunfreeware.com
6) rsh target_host -l username date :To check rsh is working or not

7) prtdiag to get system information

8) psrinfo to get cpu-count

9) isainfo to get system architecture


Regards,
Gagan Deep Kaushal

Kernel Update On Unix

Does SAP make available some where a real procedure
for NetWever 7.0 ABAP stack only KERNEL UPGRADE ?

A lot of people have questions ? answer are even available... but still... even experienced
basis admin having trouble now with Kerne Upgrade

Here I am Sharing My Experience To Upgarde Kernel On Unix!

1) stopsap
2) clean shared memory
3) saposcol -k
4) ps -ef|grep sapstartsrv
5) kill
6) cleanipc
7) lsnrctl stop
8) backup your kernel
9) cd /sapmnt/
10) cp -pr exe exe.001
11) extract new kernel
12) cd exe
13) SAPCAR -xvf
14) Start saposcol
15) startlistener
16) startsap

That's all but still sometimes there are some issues and all of you are welcome to share your views.......



Regards,
Gagan Deep Kaushal

!!!Back To Action!!!

Hi All,

!!Namaste !!

Its a long time actually i was busy with my project and Its about to Go-live. So lots of pending task is there as I am alone handling all basis activities. Hope all of you are enjoying your life with SAP.
From last 45 days I have not taken any holiday, its continues working of daily 12 to 18 hrs. Tough, isn’t it? Not so much, because I am enjoying my work like anything!!

Even I worked sleepless for 48 hours ....At that time you may feel bad but it’s really Enjoying once everything is over!

!!24 Hour of Stress!!

1) First major blow on my head is for 24 hr as I started some transports at evening 08:00 PM which was sized around 2 GB ....(Tough time starts)......In the morning same process was going on and i was shocked and inform my manger ...Let’s wait till 12.
SO now its 3 PM and everyone is losing his patience .Simply they come to me and ask when it’s going to be over?????? I have no idea so I told.............


Now time starts Tring-Tring-Tring

Different People Different ideas! Kill This Transport!! What the hell you are doing!! 18 hours!!!!You don’t know anything!!! !!Who told you to do this!!

But Thanks to My seniors and management because it’s finally completed at 07:30 PM with general warnings. Thank God it’s Over....Otherwise they can kill me at that time!!


2) Time to start installation for Application server I ran Pre-requisite test done Ok. Start installation!! What’s this JAVA_HOME not found????? Why? I have installed supported version only!! No problem let’s check on OS level ...Hmm its working fine here also .......Time evening 06:00 PM cal OS team please and I asked them to install one lower version...But still same error!! NO YAAR
So now Again Start TRING TRING TRING ....Why u did not try with latest java????Sir it’s not supported by JAVA....Then I am sorry it’s too old.
Let me check oh JAVA is not ok I will get back to you soon ...He never came back!! :)
Oh you guys every time disturb us don’t you know which version is working fine...???Sir same version is working fine for all the servers.But I don’t know why...and one more thing I did not design SAP application and JAVA so Please stop blaming and help us if you can.....Phone disconnected!!GUD
Finally OS team Reinstall everything again Morning 4:00 AM please check now.....Same Problem Now WHAT? Raise the same To SUN team…

Finally they came back to us and provided a solution in the 12:00 PM .OS team started work and then it's done till evening 08:00PM.

HAAAAAAAAAAAAAAA These 2 incidents I can never forget.........


Hope you also have same stories from your sites!!! :)
Regards,
Gagan Deep Kaushal

Central User Administration in SAP (CUA)

Hi All,

Here is the procedure for Central user administration configuration in a landscape:

1) Create Logical systems to all clients for the landscape using BD54 or SALE as
comfortable.

2) Attach Logical system to clients using Same.

3) Create RFC connection to relevant systems with the same name as logical system name .

If you Logical system name is SIDCLNT100 for dev then create RFC connection to
DEV with same name SIDCLNT100.

4) Let us suppose you Central system: DEVCLNT100
Child system: QUACLNT200

5) Create user CUA_DEV_100 in devclnt100 system

4. Create user CUA_QUA_200 in quaclnt200 system.

Create RFC’s to child systems from central and central to child.

5) Now logon to central system and execute tcode scua to configure cua.

Enter the name of the distribution model: CUA

Press create

Enter ALL Child system RFC’s

Save your entries now result screen will appear

If you expand the nodes for

the individual systems, you normally see the following messages for

each system: .ALE distribution model was saved,. .Central User

Administration activated,. and .Text comparison was started.. If

problem messages are displayed here, follow the procedure in SAP

Note 333441:


6) Setting the Parameters for Field Distribution
Enter Tcode SCUM in central system following screen will appear
Now maintain your filed distribution and save it.
You can use transaction SUCOMP to administer company address data.
You can use transaction SCUG in the central system to perform the
synchronization activities between the central system and the child
systems by selecting your child system on the initial screen of transaction
SCUG and then choosing Synchronize Company Addresses in the Central System

After you have synchronized the company addresses, you can transfer the
users from the newly connected child systems to central administration.

This is done, as with the synchronization of the company addresses, using

transaction SCUG in the central system. To do this, on the initial screen of

transaction SCUG, select your child system and choose the Copy Users to

the Central System button.


Use

You can use the report RSCCUSND from the central system of Central User Administration (CUA) to synchronize the master data of selected users with a child system of the CUA. The report sends the master data (including role and profile assignments) to a child system of the CUA.



If master data exists in the child system for the user sent, it is overwritten.

Procedure
...

1. Start report RSCCUSND (for example, using transaction SA38).

2. In the Receiving System field, specify the child system to which you want
to send the user data.

3. You can use the fields User and User Group to restrict the number of users.

4. Specify the data that you want to distribute under Distribution Options.

5. Choose Execute.



Hmnn That's all about configuration if you still have doubt ping me!!!! PING !!1PING !!!


Regards,
Gagan Deep Kaushal