SAP BASIS Interview Questions

SAP BASIS Interview Questions with hint:

1. On which port SAPINST runs? (21212 or 21213)
2. What are different types of client copy? (local, Remote & export import)
3. In export/Import client copy what are created ?( 3 transport req-> RX,RT, RO)
4. What is control file? how many control files present at DB?
5. What if one controlfile is corrupted?
6. What if one datafile is corrupted?
7. Tell me point in time recovery.
8. At OS level how you will check kernel level? (disp+work –v)
9. How you will check OS version at OS level? (uname -a)
10. Methods of system refsresh?
11. Steps of system refsresh with commands?
12. Steps of kernel upgrade?
13. Steps of oracle upgrade?
14. Why dbua and OUI is used for an oracle upgrade?
15. Troubleshoot background job delayed.
16. There are 3 Requests out of which only 2 Requests got imported to target. but 3rd Request is not getting imported. why? (local Request/import buffer full/tp check)
17. If size of my database is 650 gb, then what will be the size of export? (1/10 th of your databse size=65 gb here)
18. If I am trying to add datafile, it is not letting me to add though there is space, why?
19. What is spool store location? (paramter name, G & DB concepts expected)
20. What is spool buffer overflow error & how to trouble shoot it? any proactive action to resolve this issue?
21. What is access method and what are they? (printer related : L & F expected)
22. How to configure new printer? (steps)
23. How to disable import all option in STMS?
24. In which table, clients are stored? (T000)
25. In which table ST22 dumps are stored (SNAP)
26. What if my SAP* user is locked? (unlocked & reset at OS level: steps expected)
27. How to unlock user at OS level?
28. How to create control file in system refresh?
29. Difference between enhancement package and support packages?
30. Steps of SAP system installation?
31. What DVDs requires for installation?
32. In which tables T-codes are stored? (TSTC)
33. Difference betwwen Role & profile?
34. What is derived role?
35. What is pwd excpetion list & in which table it is stored? (USR40)
36. Troubleshoot if SAP system is down.
37. What is OPS$ mechanaism?
38. What is diagnostic agent?
39. What is private mode?
40. Types of RFC communication & explain each?
41. What is consolidation & delivery route?
42. Return codes of transports and explain each? (4, 8, 12 & 16)
43. Transport architecture.
44. Troubleshoot if transport request is hanged.
45. Types of transport Requests? (4 types: customizing, workbench, Transport of copies, Relocation)
46. How to take export of rfc?
47. How to transport request at os level?
48. What will you do if CPU values are showing null in st06? (related to SAPOSCOL)
49. How to define job? (steps, job class, variant etc expected)
50. DR concept.
51. What is Restore & recovery?
52. Generally we take sat sun offline backup and remaining weekdays online backup, what solution you will give if customer is not giving downtime for offline backup?
53. How to find out expensive SQL statements in SAP?(ST04 --> buffer gets)
54. What are SPDD & SPAU?
55. Where you can see logs of support patches? (both R/3 & OS level expected)
56. What is alert_SID.log contains? location of this file at os?
57. User is executing transaction, response is very slow, troubleshoot it.
58. What are online redo log, offline redo log & datafile contains?
59. If my orarach is full, how it will impact SAP?
60. What is oratab & what it contains?
61. During oracle upgrade when you run ./runinstaller it asks you to execute one script, tell me name of that script & why it is used?
62. If your SAP is down which logs you will check at OS level?
63. How you will check if your system is dual stack or not? (DB02--> PSAPSR3:ABAP, PSAPSR3DB: JAVA)
64. What is stack upgrade?
65. Difference between stack upgrade & support pack?
66. Scopes of oracle parameters?
67. Different shutdown modes of Oracle?
68. What is the status of database of DR? (Mount)
69. RDDIMPDP background job is used for?
70. What is logicat system name?
71. how to set logical system name and naming convention?
72. Preinstallation steps?
73. How to apply license at OS level?
74. What is the location & parameters of security audit log?(rsau/enable, rsau/local/fle, rsau/mx_diskspace/local etc)
75. What is memory allocation process for SAP workprocess? (Roll first, extended memory, remaining Roll area, heap memory)
76. In SM50 , when work process is on hold what are the reasons of on hold? (ENQ, PRIV, UPD, CPIC, RFC)
77. How many users each work process can handle?
78. Name and location of oracle log & trace files? (alert log, trace file, core dump file, audit file, network log)
79. What is Roll in & roll out?
80. What is SNOTE and is it possible to rollback SNOTE & support packs?

System Refresh: General steps of Backup Restore method

System Refresh Steps:

There are 2 ways of doing System Refresh:

1.       Backup & Restore method  (for comparatively small database size)

2.       Export/Import using SAPINST (for comparatively large database size)

Example: Source System is PRD & Target system is QAS.

Pre-system refresh activity:

1. Check size of database in both QAS & PRD. (If space issue, then resolve it)
2. Take offline backup of both QAS as well as PRD
3. Check file system size in QAS (is there enough space or not!)
4. Check support pack levels of both system & Compare it.
5. Take export of RFCs, user master data, application data.
6. TMS Screenshots of an existing system.
7. Suspend the jobs by running report BTCTRNS1.
8. Profile parameters.
9. Down QAS system & database.
10. Copy the QAS license in text file at OS level. (rename it so that it will save your time of applying new license. Once the activity completed apply same license then no need to download it again from OSS).

  
System Refresh Activity:


Backup Restore Method:

1. Take a backup of Source system (PRD)
2. Then Restore it on target system (QAS).                                                          
3. oraqas>brrestore –m full –b <backup>.aft –c
4. If backup is online (.ant)--> then restore & recover it.
5. If Backup is offline (.aft)-->only Restore it. (here we are using offline backup)
6. Once the restore is complete, After that create a trace file at source system (PRD). SQL>alter database backup controlfile to trace;
7. Copy that trace file to target system QAS & edit it in target system.
8. In trace file:Locate  “STARTUP NOMOUNT”  From current line till end delete everything.
9. Then change SID PRD to QAS (:1,$S/PRD/QAS/g)
10. Change Reuse to set
11. Change Noresetlogs to resetlogs           
12. Change Archivelog to Noarchivelog
13. Now save this file as <tracefilename>.sql at location /oracle/QAS/saptrace/usertrace
14. Once you complete the above step, create controlfile using trace file in target system QAS.    
15. SQL>@<tracefilename>.sql
16. SQL> alter database open resetlogs;

 
Post Refresh Activities:

 

1. Delete the existing license as it represents the old SID : PRD.  
2. Install the SAP license for SID QAS. 
3. Reconfigure STMS (SE06). 
4. Delete RFC from SM59. Import RFCs, User master data, application data. 
5. Release the jobs (Run the report BTCTRNS2). 
6. Maintain logical system name. 
7. Execute SGEN. 
8. Stop Archiving Process when SGEN is executed. 
9. Import profiles of active servers. 
10. SCC4 setting. 
11. Take a backup of existing system QAS. 
12. Health check monitoring.