17 May, 2013

SAP BASIS QUESTION

1. What are you roles and responsibilities in your company?
Monitoring
Troubleshooting
Kernel upgrade
TMS configuration
RFC configuration
Installation
System refresh
Client creation and client copy
Apply note and patches
2. How you will do client copy?
     Using TCODE SCCL, SCC7, SCC8
3. If SAP* is not available then how u will do?
Go to rz10 and change parameter login/no_automatic_user_sapstar 0 to 1so u can login withsap*. 
4. After client copy is table space and database sizes will be increased or not?
Well the actual size will increase
5. How to do client copy fast?
    Local client copy SCCL will be fast
6. What are various profiles available for client copy?
SAP_ALL
SAP_USER
SAP_CUST
SAP_UCUSTSAP_APPL
7. How to do transport’s between Production and Development?
STMS
8. How to apply OCS Patches?
   SPAM
9. How to do client copy?
    Using TCODE SCCL, SCC7, SCC8
10. How to do transports from OS level?
Logon with <SID>adm go to command prompt.
Go to path /usr/sap/trans/bin/
Assume Your DEV to QAS
First add request to buffer.
tp addtobuffer DEVKXXXXX QAS pf=/usr/sap/trans/bin/tp_domain_<SID>.PFL
Now import Phase
tp import DEVKXXXXX QAS client=XXX pf=/usr/sap/trans/bin/tp_domain_<SID>.pfl
Check for the return codes.
11. Where the transport data files will be placed?
You will need /usr/sap/trans/data and /usr/sap/trans/cofiles
12. How to make security authorization reports?
SUIM
Reports->Authorizations
13. In which table failed user login attempts will be there?
14. How to see the table entry values?
      SE19
15. How you will give new authorizations?
      PFCG
16. Have you participated in Kernel upgrading and OCS Patches?
 Yes
17. Have you done any up gradations?
      NO
18. How to configure TMS?
      STMS
19. What is transport domain?
All SAP Systems that are managed jointly by the Transport Management System.
All systems in a transport domain have the same settings as the Change and Transport System.
20. What is Consolidation route and delivery routes? How you will identify them?
consolidation route:
consolidation route is defined between the development system (consolidated system) and the quality system (integration system)
Delivery route:
Delivery route is the transport route that connects the integration system and the Delivery system (Production system)
Domain controller:
it is the central admin of the system
transport domain:
it is the place the transport layer and routes can be configured to access this transaction use stms
21. Transport error codes and their description?
Return code (4) indicates imported ended with warning.
Return code (8) indicates not imported ended with error
Return code (12) indicates import is cancelled.
       Return code (16) indicates import is cancelled.
22. The transaction should not be displayed in User Easy access menu. How to do userauditing in sap? What will u audit?
23. How to find users used transaction codes which are not authorized for?
Use Tcode SUIM
Select Users -> by transaction authorizations -> type the Transaction code
24. How to schedule online and offline backup which takes every day, every week. How to monitor it?
DB13
1. To access the DBA Planning Calendar in the SAP system, go to the DBA Cockpit and choose JobsDBA Planning Calendar.
 2. Double-click on the scheduled backup task whose history you want to display. A backup that has failed is indicated in red.
The upper part shows general information about the task. The lower part shows whether the task was successful and any messages that were generated
25. How will u send mail after completion of backup?
     1.Choose CCMS Configuration Alert Monitor, or call transaction RZ21.
      2. In the Methods group box, select Method Definitions and choose Display Overview.
      3.Select the method CCMS_OnAlert_Email and choose Edit Data.
      4.Choose change mode with the Display « Change ( <!--[if !vml]--> <!--[endif]-->) pushbutton, and choose the Parameters tab page.
26. How will u integrate existing ecc6 environment into solution manager
27. What are the regular activities u do in solution manager and how to update SAP?
1.Solution Manager Setup
2.ASAP roadmap
3.EarlyWatch Alert
4.Central System monitoring through CCMS
5.System Availability Monitoring through CCMSPING
6.Maintenance Optimizer
7.Service Desk
29. How to lock or unlock a transaction code using sm01?
      By editing table TSTC.
Create a parameter transaction for SM01 in SE93. Go to SE97 and ensure that SM01 "trusts" your <parameter transaction>.Then call transaction <parameter transaction> and unlock SM01.
30. How to setup RFC connection in ecc6 tells me steps involved?
Use Tcode: SM59
Create
Type a RFC destination Name, Descriptions, target Host, System Number
In Connection type you must select ABAP connection, means Connection Type must be 3
In Logon tab assign Client, RFC User which you have already created (t. code: SU01), type a password and save
31. Tell me steps for support pack installation in ecc6?
ABAP Stack
1) Upgrade "Kernel"
2) Download required sp's from service marketplace.
3) Extract downloaded files to your "saptranshost"
4) Read newest sap-note about problems with SPAM/SAINT transaction
5) Logon your system (client 000) with user that has "SAP-ALL" authorization.
6) Run transaction SPAM, define queue, and start import.
JAVA Stack:
1) Download required sp's from marketplace.
2) Unpack the files or move them to the "saptranshost" depending of your release.
3) Run SAPINST or JSPM depending on your release.
Double Stack systems:
1) Patch ABAP Stack as described.
2) Patch JAVA Stack as described.
34. What is the database backup strategy in your company?
35. What is upgrade process? And how u will do that?
An upgrade updates an existing SAP system to a new release. The upgrade contains program code and data changes or introduces new areas of functionality.
36. How u will give new authorizations?
Authorization in SAP means giving users access right to a T-Code. PFCG allows Basis to change user’s authorization inside a T-Code. By adjusting the object you also can control if user can display, edit, or change certain field in the T-Code.
A Role Is created with the profile generator and allows the automatic generation of an authorization profile. The role contains the authorization data and the logon menu for the user.
PFCG
· Create new role
· Define menu and define Tcode and authorization
· Click on Authorization tab and click “display authorization data”
· Give role to user
· Save it
37. How to adjust user master records? If user master record doesn’t adjust what will you do?
The existence of a user master record is a prerequisite for logging on to the SAP System. The user master record determines which role is assigned to the user, i.e. which activities are in the user menu and which authorizations the user has.User master records are client-specific. You therefore need to maintain individual user master records for each client in your SAP System.
38. How to check Kernel, tp versions?
SM51 --> Goto Release notes.
Menu -- >system -- >status. Then click on component information button.
39. Briefly explain a recent problem you faced, which u felt proud by solving that? And how will u solved?
41. What are common background jobs that will run in your system?
SAP_CCMS_MONI_BATCH_DP
SAP_COLLECTOR_FOR_JOBSTATISTIC
SAP_REORG_ABAPDUMPS
SAP_REORG_BATCHINPUT
SAP_REORG_JOBS
SAP_REORG_JOBSTATISTIC
SAP_REORG_SPOOL
SAP_REORG_UPDATERECORDS
SAP_SOAP_RUNTIME_MANAGEMENT
42. If a background job runs more than the time it should be completed normally then what actions will u take?
    Check
Background processes are free or not
· SM21 any specific message
· SM50 monitor how much memory the background workprocess is taking
· ST06 - processor free or not or 100% used?
Looks very much like you need more memory to complete the processing -
Increase abap/heaplimit=40000000" to 2 GB and restart the ABAP server
43. How to schedule background jobs at OS level?
Actually we cannot completely schedule background at OSLevel but we can trigger a background job which has alreadyscheduled by using sapevt tool syntax as follows.
sapevt <event name> nr=<instance name> name=<host name>
46. Transport request types and its syntax?
Fourtypes of transport requests
customizing request- c type
Workbench request- k type
transport of copies – t type
relocation 
47. Where will u find transport error logs?
       SE10 -- > transport tab at right -- > select transport from list -- > click on log symbol from tool bar
49. How to transport objects from Production to Development?
It is not recommended to do direct changes into production system. Anyway for Repository changes you can export the tpz file from production environment and then import it into development. For Integration Directory changes it will be nice if you do it manually because then you don't need to change the Transport target in SLD.
50. How to define instances and operation modes?
Instances are created during R/3 System installation. Assigning instance definitions to an operation mode has no effect on the instances, directories and profiles that you create using the installation programs.
Procedure:-
Transaction RZ04
Choose Instances/OP modes
51. What are Homogenous-Heterogeneous system copy and how you will do that?
Homogeneous systemcopy means a system copy with all the database tables from one system to another system of same kind, like same os/db on both the systems.Homogenous copy is done by export/import technique.
A Heterogeneous System copy is a copy from one system to another system of a different kind, like different os/db in either of those.Heterogeneous copy is done by system migration. It is same as export/import except that it will ask for target OS and DB type and needs a key to be entered.OSS notes are applied using T-code SNOTE.
54. At OS level in which directory oracle alerts are stored?
There will be file as alert<SID>.log under
UNIX: /oracle/<SID>/saptrace/background
Windows : <Drive>:\oracle\<SID>\saptrace\background\
55. If a lock entry is holding more than 24 hours then what will youdo?If another user wants to share that lock but the user using that Locks haven’t released lock he went for holiday what will u do? This User wants lock ASAP then what will u do?
Delete lock using Tcode SM12 -- > list -- > delete by selecting the lock after asking to that user.
59. What will you do if u got Update failure?
First of all check whether the Update is ACTIVE or NOT?
Tcode SM14 & SM13.
Check the Status of Update work Process.
Check the Table spaces (Free Space)
Check OS level Space.
Check the Object Locks (SM12)
60. What will you observe in System log (SM21)?
The SAP System logs all system errors, warnings, user locks due to failed logon attempts from known users, and process messages in the system log. There are to two different types of logs created by the system log:
  Local Logs
  Central Logs
63. How you will get help from OSS notes?
OSS is an online SAP service portal which that has updates about SAP patches and latest SAP note information.
64. What is the need of having Development system?
      For development of actual system and also for made any changes and testing.
65. Difference between Application server and Central Instance?
The main difference between CI and Appl. server is that the CI has the ENQUE process that handles the DB locks.
66. How you will check whether database is active or not from OS level?
Use command in os level
      R3Trans –d if the return code is 000, means the connection is good.
ps -ef |grepora_
ps -ef |greppmon
If the entire Oracle background process are running we can say that oracle is up and running.
OR
Connect to the sql like sqlplus "/as sysdba"
sql> select status from v$instance; if the output is "open" we can say that Oracle up and running fine. 
67. How to lock a client? How to delete a client?
To lock or unlock a client only in an in R/3 System, run the following functions via Tcode SE37:
1. SCCR_LOCK_CLIENT
2. SCCR_UNLOCK_CLIENT
       Delete a client
I would prefer SCC5
68. How to login in to SAP from command level?
             1. Open the command line prompt. Start > Run
2. Execute the following command as per system address and instance number
sapgui 192.168.1.10 10

Options
192.168.1.10 = System IP address
10 = Instance number
69. How to define Logon groups? And what is Logon load balancing?
      SMLG
      Create group by providing group name and instance.
       Load distribution allows you to dynamically distribute the SAP users to application server instances. You can increase the efficiency of individual work groups by setting up multiple logon workgroups that consist of one or more application instances
70. How to find sap transaction codes?
       SE93
71. How to find list all the T codes for a role in sap?
      Goto SUIM- Transactions - > Executable by a SAP role
      The best way is to goto t-code SE16 -> AGR_1251 -> give the role name  in field AGR_Name and   S_Tcode in Object field and execute it,you will get all the t-codes under that role.
Go to T-Code PFCG
Enter role name
Hit printer icon
You will get the list of T-Codes
74. How can I delete a data file that was created by mistake?
      SQLPLUS> delete datafile xyd.dbf;
      BRtools>
75. Which pools are resizable?
       Shared pool, java pool , stream pool , large pool
76. User could not logon to the system? Why?
1.       service is closed
2.       authorization
3.       profile missing
77. How to change default client like 111?
      you need to change an instance profile parameter on the R/3 system. The parameter is: login/system_client
The default value is 000.
The expert said that you need to make the change, save the instance profile and activate it. Then stop and restart the R/3 instance for the change to take effect.
82. If job is slow?
83. List of r/3 user types?
1.       Dialog user
2.       System user
3.       Communication user
4.       Reference user
5.       Service user
84. How to unlock the object?
      SE03 -- >unlock object (request)
85. What is Difference between SPAD and SPAU?
     SPAD spool administration (printing process and device setting)
     SPAU repository objects
86. What is SSO? How to configure SSO?
      The SAP GUI’s Single Sign-On (SSO) functions enable you to configure transparent user authentication for access to AS ABAP systems. With SSO, SAP GUI users can only select the AS ABAP system to log on to from the SAP Logon Pad, without needing to interactively provide a user name and a password.
You can use the SSO functions of the SAP GUI to facilitate user access to multiple AS ABAP systems in an SSO environment. In addition, the use of SSO can reduce your administration costs, while strengthening the overall security of your systems.
87. How to check cpu usage in EP?
      ST06
88. If java is down how you will do trouble shooting?
89. How to take back up on EP?
90. How to apply job on OS Level?
91. Difference between system refresh and client copy?

      Sometimes these are the same, For example, if you are performing a copy to an existing client for the express purpose of updating the data, then it is called Client Refresh. If you are copying to a newly created client then it is more appropriate to say “client copy.” Another way of thinking about this is that a client copy from production to a QA server or from production to DEV server is really a client refresh.
92. Where you have to see oracle parameter?
      DB26
94. If table space auto extend size how to see the size?
95. Difference between Remote client copy and Export and import?
    Remote client copy is done in the same land scape i.e. it is in LAN or wan, client import and export are two different landscape. Remote client copy is performed when small amount of data to be transported that suppose 20 GB, whereas client export/import is performed when huge amount of data to be transported that suppose 300 GB. Local Client Copy is done within same system(QA to QA) Remote Client copy is done with different system(QA to PRD)
96. What are steps for DB Refresh?      1. Pre Copy steps
      2. Restoring/Copying the database files
      3. Post Copy Steps.
97. What are the Pre-requisite for system copy?
• An SAP ECC 6.0 system, QAS, (similar to PRD in memory and disk configuration) should be installed with a valid SAP license key. (NOTE: Be certain that both the DNS name and NetBIOS name of the server are in all CAPITALS, 8 characters or less, and contain no special characters.)
• The source system should be backed up (Full Backup) and the media should be accessible from the target system.
• Perform a backup of the original QAS system to restore to in case of difficulties.
• Anything from the target that will need to be restored (user definitions, profiles, jobs, printers, RFC destinations, etc.) after the copy must be saved out. In addition, take a snapshot of the client change settings (SCC4), system change options (SE03), workbench organizer/transport system configuration (SE06), and any other setting that will need to be restored in the target system.
• Identify which transports exist in QAS but not in PRD and remind the owners that all transports which have not moved to PRD before the copy will no longer exist in QAS. Preferably, everything should be pushed through pre-copy (including LCP and CRT imports, Hot Packs, and other SAP transports associated with notes).
• Communicate to everyone that any spool data, datasets, master data, etc. which exist only in QAS will need to be moved elsewhere, printed out, or otherwise repositioned before the copy.
• Security profiles and user lists need to be repositioned so they can be recreated post-copy.
• Any external programs affected by the move (BSI, etc.) must be dealt with post-copy.
101. What are the table space names that you see in DB02?
         PSAPSR3
PSAPSR3700
PSAPSR3DB
PSAPSR3USR
PSAPTEMP
PSAPUNDO
SYSAUX
SYSTEM
102. What are the Parameters need to be set when connecting EP to r/3 system what are they?Connector:
Application Host : <host. Domain> :< port>
Remote Host type: 3
SAP Client: Client
SAP System ID: System ID
SAP SYSTEM NUMBER: 00
SYSTEM TYPE: SAP_R3

7 comments:

  1. nice information thanks for sharing from Sankar

    ReplyDelete
  2. This SAP OS DB MIGRATION ONLINE TRAINING course not only gives an overview but provides you with a thorough in-depth knowledge about how the SAP os db works. we also provide online training on SAP OS DB MIGRATION ONLINE TRAINING . the overall downtime phase of a heterogeneous system copy or Unicode migration. Therefore, it is important to optimize the import using SAP tools and DB2 configuration settings.

    SAP OS DB MIGRATION ONLINE TRAINING

    ReplyDelete
  3. To execute an OS/DB migration specially certified for OS/DB migrations, executes the migration locally, irrespective of whether you are migrating a development system, a test system or a productive system. This ensures that the required "know-how" is available to deal with the complexity of the situation. SAP OS DB MIGRATION ONLINE TRAINING check for the operating system or the database to migrate production systems.
    SAP OS DB MIGRATION ONLINE TRAINING

    ReplyDelete
  4. Wonderful content .... Very good blog. Thanks!

    ReplyDelete