Easy way to understand oracle concepts

Easy way to understand oracle concepts:

Here I have attached the excel sheet for complete reference. Please let me know in case of further inputs.

Oracle Overview


Sabarish Vasudevan


SAP Remote Basis Administration – Task List

SAP Remote Basis Administration – Task List

Recommended daily tasks
1. Check whether the systems are up
2. Check whether the backups finished without errors
3. Check for alerts in CCMS monitors
4. Check for hanging or stopped work processes
5. Check system log for errors/warnings
6. Check whether any background jobs got canceled for any reason
7. Check the lock entry list
8. Look for any failed updates
9. Check for users logins from unknown terminals/locked users
10. Analyze program dumps
11. Check for excessive swaps and buffer statistics
12. Review Database performance
13. Check database for space critical objects
14. Check the average response times
15. Check for OS level alerts
16. Check CPU load and memory usage
17. Review SAPDBA calendar job logs
18. Check archive directory status

Recommended weekly tasks
1. Check database for free space
2. Monitor tablespace growth
3. Monitor total DB growth
4. Clean up Spool
5. Clean up transport buffers
6. Run TemSe consistency check
7. Review security audit log
8. Check for adequate file system space
9. Analyze Early Watch reports

Recommended monthly tasks
1. Cycle the R/3 system to defragment memory
2. Analyze the database growth and plan for storage
3. Review directory structure and need to move data files
4. Cleanup old logs

Recommended quarterly tasks
1. User security overview
2. Review SAP profile parameters
3. Review the standard scheduled jobs
4. Test the backup by restoring
5. Archive the old transport files
6. Maintain SAPDBA and database parameter files
7. Review maintenance contracts for all hardware / software
8. Check for usage versus licensing

Recommended annual tasks
1. Audit user security
2. Audit profiles and authorizations
3. Review user roles
4. Maintain activity groups/profiles
5. Cleanup clients in test/development systems
6. Check workbench organizer settings
7. Refresh test system8. Simulate disaster recovery/failover testing
Software maintenance (as needed) 1. Applying support packages
2. Applying database patches
3. Upgrading kernel
4. Change Management /applying notes
Additional services (as needed) 1. User Maintenance / Profiles creation and maintenance
2. Printer definition maintenance
3. Data archiving
4. Technical Upgrades
5. Server Migration

Error in Client copy[FINB_TR_CC_EXIT_TARGET FIN-FB]

Problem Statement:

After successfully done with client import we can’t able to execute the post processing activities by using SCC7 tcode.

“FINB_TR_CC_EXIT_TARGET FIN-FB    Post-Processing Required”



We have found one sap note regarding this case. we just follow the same steps mentioned in the sap note.

Here the problem is like, the post processing required only one entries mentioned in the above. so we will make this entries alone to do post processing as mentioned in the sap note.

Please refer this note:

1880165 – Client copy error FINB_TR_CC_EXIT_TARGET in T-code SCC9/SCCL

741864 – FinBasis: Termination TSV_TNEW_PAGE_ALLOC_FAILED

Please let me know in case of any queries.

Thanks & Regards,

Sabarish Vasudevan.

WebGUI logoff does not work

Problem Statement:

After logged off my webgui, the browser can’t carry out with log off. it still persist in the same page/if you press F5 it again back to your webgui without any login credential.


Please follow the below mentioned SAP note for this case. It’s very simple to redirect to log off page.

1777513 – WebGUI logoff does not work

1039335 – Incomplete logoff from an ITS WebGUI application

Step 1: /default_host/sap/bc/gui/sap/its/webgui

Step 2: Click on error page/logoff page

Step 3: Select and provide a redirect URL.


Please let me know in case of any queries.

Thanks & Regards,


Prerequisites for kernel upgrade from 72X to 72X+1


  • Before Doing any kernel upgrade, please refer the SAP note to avoid most of the issues in advance.
  • Here am going to do kernel upgrade from 720 to 721.
  • So i have to refer 721 Download compatible kernel notes from SAP market place for windows platform. PFB

1713986 – Installation of kernel 721 (EXT)

1716826 – Usage of the downward compatible kernel 721 (EXT)

Issues During my kernel upgrade:

Disk+work not started after my new kernel patch.

Error Log:

DpHalt: sync with message server o.k.
DpHalt: detach from message server
***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 13090]

I have resolved the error by referring the above sap note[1713986] point number 5.

I have replaced the new disp+work package from service market place.

Please do not start any upgrade or installation without SAP note. Please let me know in case of any queries.

Thanks & Regards,