We can create a restricted password list for our SAP system to make our life much more easier for AUDIT sessions Maybe users are not going to be happy but it’s so important for our SAP systems to make much more secure…
Find the LOCKED SAP Users Easily
There is a lot of way to find LOCKED users in SAP but i always prefer the following way to find it , it’s very easy and very fast…
Delete SAP Client from OS Level
If you have to delete a SAP client in your SAP system and you don’t have any authorization or user for this client , then you can do this operation on operation system level without any authorized SAP user needed.
Find Users Who Never Logon to The SAP System
Sometimes you get a lot of urgent!!! user creation requests they always need immediately and its very important….
But are they using this SAP users??? Lets check…
Reset SAP User Buffer Data
Sometimes we need to clear SAP user’s buffer area and we ask them to relogon to SAP system again, but following metod helps us to reset this buffer data area easly…
If You Cannot Find Your SAP System in SAP MMC Window
If you cannot find your SAP system defination in your SAP MMC window or maybe you deleted mistakenly then you don’t need to worry about it…
SAPGui Favorites for SAP Users
We can add our frequently using transaction codes to “Favorites” group for our SAP User.Also we can “Download” this favorites to our computers or “Upload” to our SAP system.
UPLOAD and DOWNLOAD Locations for SAP Users
Before we have worked on SO21 tcode to “configure working directory” but now i would like to share with you how can we change upload and download working directory for another SAP user.
ORACLE DB Startup Modes
Let’s remember the ORACLE database startup options.
NOMOUNT : If we choose “nomount” option to start our ORACLE database , system first read “init.ora” file to get database configuration and related parameters thus database can start background processes.
Send SAP Spool Output via E-Mail
We can send “SAP Spool Output” by e-mail to related colleagues…It’s so easy and it’s very useful especially for backgroud job’s spool outputs.
To configure this option we can follow the steps below ;
Oracle Datafile Resize
Sometimes we get a message from DB13 “Check DB” operaion like ;
BR0970W Database administration alert – level: WARNING, type:
TABLESPACE_FULL, object: PSAPSR3DB, value: 95.46% (> 95%)
DB13 “Checkpoint Not Complete”
If you get “Checkpoint Not Complete” message from your “Alert.log” via DB13 tcode, it means that probably your REDOLOG file sizes are smaller than the oracle db needed.
DB13 tcode show us following screen in case of situation ;
SQL Quick Viewer
SQL Quick Viewer is the part of SAP system which is not very much known by the Basis admins but it’s also very helpfull tool for getting the table entries with any kind of patterns which you want…
Let’s check this tool with an example ;
Compare Two Different SAP Systems or SAP Clients
Sometimes we need to compare two different SAP system or SAP client, then we can use transaction SCU0 for this process.
Let’s make an example how we can use SCU0 for a compare operation.
Zero Administration Memory Management
“Zero Administration Memory Management” handles the SAP MEMORY management dynamically on windows systems.“Extended Memory” value can be configured with parameter “PHYS_MEMSIZE” via SAP profile parameter.
What is the Difference Between “Static” and “Dynamic” SAP Parameters
SAP has two type of “SAP Profile Parameters”
1 – Static Parameters
2 – Dynamic Parameters
All static parameters needs “SAP System Restart” before it’s activated, but we can change all Dynamic parameters without SAP system restart , these type of parameters get activated when they changed via RZ11
Who Locks the RFC User ?
Sometimes RFC users getting LOCK status and you have to find who or which process locks this user ? If you can’t find the reason why your RFC user always getting lock status then your RFC connections won’t work because of RFC user lock issue…
Then let’s investigate who , what or which process locks this RFC user…
Recent Comments