Learn SAP Basis easily
Note: This problem is apply to Oracle Database only. You want to start your SAP, but you find that the SAP Service doesn’t up. You have checked that all file system are healthy. When you see from developer trace you find that all work processes are died. You check from R3trans -d and find that the SAP to Oracle connection … Read more
It’s necessary to monitor your SAP number range so that the transaction using number range can continue smoothly. Open transaction SA38 -> RSNUMHOT Fill with the percentage -> Execute You will be shown which number range about to be run out.
After fresh installation of your Oracle Database Software, you may need to install some oracle patches. This article describes how to use OPatch to install Oracle database patches on Windows platforms in an SAP environment. (on UNIX/Linux the steps is almost the same, just change the path). 1. Check your current oracle patch. > cd … Read more
The currently used Oracle Instant Client is not up-to-date and you want to update it to latest supported version. Here are the steps: 1. Identify your current Oracle Instant Client (as described in article How to check Oracle instant Client version). 2. Download the latest supported Oracle Instant Client from SAP. 3. Download deldbclient.vbs, which … Read more
There is easy way to check complete list of your SAP Oracle datafiles. You can do that using integrated oracle tool called rman. Below are the steps: 1. Login as ora<sid> in UNIX or <sid>adm in WINDOWS. 2. Call rman tools from command prompt. orasbe> rman 3. Connect to database target. RMAN> connect target / … Read more
As part of your job to make the SAP system performance always good, you actively monitor which SQL statement mostly having impact to the performance. Besides from ST04, you can also monitor the high SQL statement from SAP report as shown below: Note: in this example the database is using Oracle. From SA38 run /SSF/RSORADLD_NEW … Read more
Your SAP System hang? Here some list you have to check: 1.Can you access your SAP? If yes, check SM21 for problem log check SM13 for update deactivated check SM50/SM51 for workprocess full check DB02 for some full table/tablespaces if you don’t activate autoextend. 2. If you can’t access SAP, check for filesystem full (usually archiver … Read more