Activate Inactive Object

 Activate Inactive Object (SAP NOTE)

Issue: 
We applied SAP Note. 
After that when we were trying to release corresponding Transport Request, got 'Inactive Object' eror.

Solution:
SE38 --> Run the Report: SCWB_NOTE_ACTIVATE --> Execute
 
Enter the SAP Note Number.
 

Execute & Activate the objects.

Then Release that Request.
 

How to copy output of SQL commnads to a text file?

Steps to copy output of SQL commands to text file:

1. Go to SQL prompt:

  

2. Check Present working Directory:

     SQL> !pwd

               

3. create text file which will be saved at above location.

     SQL> spool priya.txt

       

4. After that execute your SQL command,  command & output will be saved in the text file you created.
   

    Note: you can execute as many command as you want  in that text file one after other.

5. Once your finished with your commands, close that text file.

    SQL> spool off;

 

6. Now check text file at the specified location.

  

7. Open that text file & check output.

    > cat priya.txt | more   

   

In this way we can save lengthy output of SQL command in text file.

    

Oracle Logs & Trace Files

Oracle logs & Trace Files:

1. Alert Log (alert_SID.log):

    Location: /oracle/SID/saptrace/background

    Log consist of instance activity such as startup, shutdown, switch logfile, parameter change, error etc.

2. Trace File (*.trc):

    2 types of Trace Files:

        System trace--> /oracle/SID/saptrace/background

        User Trace  --> /oracle/SID/saptrace/usertrace

    Normally the error logs globally mentioned in the alert log & more details are written in trace files.

    SQL> show parameter user_dump_dest;

3. Core Dump File:

    Location: /oracle/SID/saptrace/background

    Like core dump in OS. When there are issues related to configuration of OS such as, accessibility,

    oracle storage usually make core dump.

    SQL> show parameter core_dump_dest;

4. Audit File (ora_OSID.aud):

    It contains connection history from user sysdba (sys) & user audit activity for AUDIT_TRAIL = OS.

    If the file system, where audit_file_dest is full, we could not login with sysdba user (sys).

    SQL> show parameter audit_file_dest;

5. Network log (listener.log):

    Location : /oracle/SID/102_64/network/log

    Contains network related logs.

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?