Send SAP Spool Output via E-Mail

Send SAP Spool Output via E-Mail
April 25, 2014 | No Comments »

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

Oracle Datafile Resize
April 24, 2014 | No Comments »

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”

DB13 "Checkpoint Not Complete"
April 23, 2014 | No Comments »

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 ;

SAPGui SAP Menu and User Menu

SAPGui SAP Menu and User Menu
April 22, 2014 | 1 Comment »

I would like to share some informations about MENUs which located on SAPGui

- We can activate the USER MENU from left side of the SAPGui screen shown below..

SQL Quick Viewer

SQL Quick Viewer
April 21, 2014 | 2 Comments »

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

Compare Two Different SAP Systems or SAP Clients
April 20, 2014 | No Comments »

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.

STMS Message “requests do not match the component version of the target system”

STMS Message “requests do not match the component version of the target system”
April 19, 2014 | No Comments »

Sometimes we should see a STMS icon, different than the usual icon types in the STMS queue…

Zero Administration Memory Management

Zero Administration Memory Management
April 18, 2014 | No Comments »

“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

What is the Difference Between "Static" and "Dynamic" SAP Parameters
April 17, 2014 | 3 Comments »

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

What is WorkProcess? What are the Types?

What is WorkProcess? What are the Types?
April 16, 2014 | No Comments »

SAP workprocesses are part of the application server which can handle maximum one presentation server request at one time.SAP workprocess contains “ABAP interpreter” , “Screen Interpreter” , “Task Handler” and “Database Interface” sections.

Who Locks the RFC User ?

Who Locks the RFC User ?
April 15, 2014 | 1 Comment »

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…

How to Delete a SAP Client

How to Delete a SAP Client
April 14, 2014 | No Comments »

If we want to delete a SAP client on our SAP system,  then we can check the following steps and do it easly…

1 – Logon the related client which we want to delete with the user who has SAP_ALL authorization .

Example : Client No : 010

SAP User List Who Has “Access Key” for Our SAP System

SAP User List Who Has "Access Key" for Our SAP System
April 13, 2014 | 1 Comment »

If we want to display a list of users who has “Access Key” for our SAP systems then we can use related section of service.sap.com…but also there is another simple way to get this list over related SAP system.

Just display following SAP table via SE16

Get TCOLL Error After RTCCTOOL Report Runs

Get TCOLL Error After RTCCTOOL Report Runs
April 12, 2014 | No Comments »

After running RTCCTOOL report while working EWA (Early Watch Alert) configuration,  you can get TCOLL error like below ;

Short Dump : SPOOL_INTERNAL_ERROR

Short Dump : SPOOL_INTERNAL_ERROR
April 11, 2014 | No Comments »

Sometimes you can get an error like “Short Dump : SPOOL_INTERNAL_ERROR” under ST22 or SM21 Tcodes , usually the reason is ; “Spool Request” number reached the default value 32.000

Change SAP Object Without “SAP Object Key”

Change SAP Object Without "SAP Object Key"
April 10, 2014 | No Comments »

Normally if you want to change a SAP object, first you have to get an “Object Key” from service.sap.com

But you can try with following steps without getting the “Object Key”

ORA-12560: TNS:protocol adapter error

ORA-12560: TNS:protocol adapter error
April 09, 2014 | No Comments »

Usually we get this error if Oracle Client dosen’t know which database to connect according to “TNS Alias” information.

To control to status firstly we should check the connection manually over SQLPLUS with the related Oracle user.

RFC Connections , Definations and Status Report for SM59

RFC Connections , Definations and Status Report for SM59
April 08, 2014 | No Comments »

This report helps us too much to get all SM59 RFC entries definations and detail informations even “Connection Test” results

To get this report just we need to do following steps ;

Getting Error While Importing “Client Dependant” Requests

Getting Error While Importing “Client Dependant” Requests
April 07, 2014 | No Comments »

Is it possible to get an error like below while you trying to import client depending requests to your SAP system via STMS mechanism.

“The request’s target Q13.100 is client dependant but the target system cannot handle that”

ORA-01123: cannot start online backup; media recovery not enabled

ORA-01123: cannot start online backup; media recovery not enabled
April 06, 2014 | No Comments »

Sometimes when we trying to start “Online Backup” on our ORACLE/SAP system we get an error like “ORA-01123: cannot start online backup; media recovery not enabled”

For Oracle Version 10g and 11g please use the following syntax on SQLPlus ;

SO21 – SAP Working Directory

SO21 - SAP Working Directory
April 05, 2014 | 4 Comments »

If you going to choose your working directory everytime while transfering the files between SAP sistem and your computer and if its bored you too much , then you can fix your working directory easly with following procedure

Find Terminal Name and IP Information of Online SAP Users

Find Terminal Name and IP Information of Online SAP Users
April 04, 2014 | 2 Comments »

It’s very simple to list “TERMINAL NAME” , TERMINAL ID” , “LOGON LANGUAGE” and other usefull informations of your ONLINE SAP Users.

You just need to check following table…

ORA-01565 and ORA-27046 Errors

ORA-01565 and ORA-27046 Errors
April 03, 2014 | No Comments »

While tying to START a database sometimes if we are not lucky then we can see the following errors ;

ORA-01565 and ORA-27046

ST03N “Message_Type_X”

ST03N “Message_Type_X”
April 02, 2014 | 1 Comment »

Sometimes we get an error like “Message_Type_X” while trying to open historical data like below ;

ST03N -> Administration -> Expert Mode -> Workload –> Total

Blogroll