Home » Posts tagged 'ORASID'

Tag Archives: ORASID

SAPOSCOL : how SAP R/3 instance communicate with OS

SAPOSCOL a tiny program developed by SAP as daemon so that SAP R/3 instance can comunicate with its OS host. By using this SAPOSCOL program, SAP R/3 can communicate and can get a lot of information about OS including CPU usage, memory level usage, swap, disk activity, network information, monitored process, system configuration, client – server connectivity, etc. Hmm….we can get it without directly communicate with OS. Just use SAPGUI from your workstation.

Usually, SAPOSCOL program had to be started before your SAP R/3 instance so that it can supply your R/3 instance with OS information. To start SAPOSCOL program, your just entered your OS console/terminal and use ora[SID] (if you’re using Oracle) or SAPservice[SID] if you’re using MS SQL.

Just type : #saposcol

If SAPOSCOL process had been running, it will show you the information and status.

To stop SAPOSCOL, just type : #saposcol -k

To check SAPOSCOL information, just type : #saposcol -s

SAPOSCOL program is very important to SAP R/3 instance. It can delivered information to SAP tcode such as RZ20, ST03, ST06, etc.

If your SAPOSCOL program did’nt run then you’ll need to run it manually. Usually, Basis forget about its permission (if you’re working in UNIX environment) and claimed  “Hey, my SAPOSCOL didn’t run ? help…”

Your first step is check its permission on OS level (no need to restart your SAP R/3 instance nor your database server).

Hope this tutorial can help you.

Checking SAP R/3 Database via BRTOOLS

BRTOOLS is a database tool developed by SAP to help SAP Basis manage his Oracle based SAP R/3 database. In the last tutorial, I had shown you how to check your database through DB13 tcode. DB13 is database independent tcode to manage your database whether you’re using MS SQL, Oracle, DB2, or SAPDB.

Here, I am going to demonstrate how to use BRTOOLS to check your Oracle 9i database. You need to logon to your SAP R/3 server using ORA[SID] user.

Type BRTOOLS on your console and then you’ll have this screen. For your information, I’am using UNIX OS. It might be different when you’re using Windows OS.

Choose number 6 option by typing 6 and then press ENTER.

To check your database choose number 1 option and then press ENTER.

In this screen, you might need to input some information about your database such as your SAP Database profile, your database user and password, database owner, and something you might not want to be checked. For this moment, I am using default properties and press ENTER.

This screen show you BRTOOLS confirmation. Just type C and then press ENTER to proceed to the next step.

Press ENTER to proceed.

Now, you’ll see that database check process is running. Wait until it finished.

Type S to stop and exit from BRTOOLS menu. Now you had learn how to check your SAP R/3 database by using DB13 tcode and BRTOOLS command. In the next tutorial, I’ll show you another tips and trick that might be useful and helpful. Stay there and always connected.

Critics and suggestion are welcomed. Please feel free to contact me on devratt@yahoo.com.