Saturday, October 25, 2008

How to check BRTOOLS version

Some SAP Basis newbies ask me about how to know which version they are using right now. Although I am not SAP Basis expert, I'll try to get information to you.
You can follow this step :

Enter your SAP system on OS. You can use root (for UNIX/Linux) and Administrator (on Windows system). I am going to guide you on UNIX/Linux only system.

Switch you user to ora[sid] user :

#su - oraids

Type this command :

>brtools -V

You'll see something like this :

host:oraids 1> brtools -V
BR0651I BRTOOLS 6.40 (40)

Patch Date Info

36 2006-01-11 Small functional enhancements in BR*Tools (note 914174)
38 2006-03-29 BR*Tools support for MDM databases (note 936665)
40 2006-08-30 Wrong message numbers in BR*Tools 6.40 (note 976755)

release note 680046
kernel release 640
patch date 2006-08-30
patch level 40
make platform hpia64
make mode OCI_920
make date Sep 5 2006

host:oraids 2>

As you can see that I am using BRTOOLS version 6.40 and have patch level 40. I am using HP-UX on Itanium platform 64 bit. Now, check your own BRTOOLS version.

Wednesday, October 22, 2008

System Copy with Oracle 10g from 64-bit to 32-bit on Windows E-mail Print PDF

Following procedure helps you to do a system copy from a 64-bit to 32-bit hardware with Windows/Oracle Platform.

Introduction To System Landscape

When we design the landspace for a SAP Project, generally we prefer to have same platform for Development, Test and Production system.

This includes,

  • Hardware (32-bit or 64-Bit and also IA64, X64, or Unix 64 Bit platforms)
  • Operating System
  • Database
  • R3 Kernel

This helps, system administrators to identify system related problems causes functional problems.

For example, if a 64-Bit Kernel for Netweaver 700 on Windows/Oracle causes a problem, you cannot simulate it on your Test system if it is a 32 Bit platform.

Also you have to make sure that the kernel patch levels are all same on all systems.

System Copy Experience with 64-bit to 32-bit


Recently, one of our Customer asked us to copy Production System to their Test System.

Here is the systems environments:

Production System (Source System)

64-bit Intel Xeon (x64)
Operating System
64-bit Windows 2003 R2 SP1
Oracle 64-bit
SAP Kernel
700 64-bit PL 133

Test System (Target System)

32-bit Intel Xeon (x86)
Operating System
32-bit Windows 2003 R2 SP1
Oracle 32-bit
SAP Kernel
700 32-bit PL 72


Here is the brief procedure. For details, please download System Copy Guides from

  1. Stop Production System to copy files or use a recent online/offline backup to copy database files from production to test syste
  2. Run "alter database backup controlfile to trace" on source database to get control file creation script.
  3. Generate new cntrl.sql and run on target system with modified paths
  4. Recover if backup is online via "recover datbase using backup controlfile until cancel;"
  5. After recovery shutdown database on target with "shutdown immediate". Do not use "shutdown abort"
  6. cd ORACLE_HOME/rdbms/admin on target system with adm
  7. sqplus "/as sysdba"
  8. SQLPLUS> startup upgrade
  9. SQLPLUS> @utilrp.sql
  10. SQLPLUS> shutdown immediate
  11. SQLPLUS> startup
  12. SQLPLUS> @utlrp.sq
  13. If databaase scheme name is different from SAPSR3 on both systems, then you've to change dbs_ora_schema environment value to the one on Source System.
  14. If schema name is other than SAPSR3, than you have to re-configure OPS$ me. For this please check the reference section which gives OPS$ mechanism notes.
  15. Check connection with "R3trans -d"
  16. Start SAP System and apply, post-copy procedures.

That's it.

Hope it helps you to understand that it is not necessary to use R3load Procedure even platforms are different in bit level.


Note 050088 - Creating OPS$ users on Windows NT/Oracle

Note 361641 - Creating OPS$ users on UNIX

Taken from

Tuesday, October 21, 2008

Effective Optimizer Statistics Update

Following command is very effective, as its not estimating, doing a real calculation on tables including all indices to find the right path for R3 Systems.

brconnect -u / -c -f stats -t all -m +I -s P10 -f allsel,collect,method,precision -p 8

Taken from

Friday, October 17, 2008

SAP Basis Task List Part 1

Some people ask me about "What kind of job SAP Basis do ? "
It is difficult question to answer because it's not general answer. SAP Basis task list depend on :
  • company size
  • avalaible resource (size of your Basis group)
  • infrastructure such as database, network, desktop support
Practically, SAP Basis task are split into two (2) type SAP directly related and SAP indirectly related. On this post, I just explain about SAP directly related task. I'll post another task list on my next post. Some of SAP directly task list are :
  1. User Administrator - manage SAP user accounts
  2. Security Administrator - manage roles and profiles which related with all SAP user activities
  3. System Administrator - monitor and maintain your SAP server health and performance
  4. Transport Administrator - maintain and monitor SAP change request
  5. Job Scheduler - maintain and monitor SAP jobs
  6. Backup Operator - maintain and monitor about SAP server and data backup
  7. Disaster Recovery technical manager - plan and testing SAP disaster recovery plan
  8. Database Administrator - Some of Basis are also work as DBA for its SAP database
Some Basis may have vary job. This just sample of SAP Basis task list related with SAP directly. I hope you enjoy it.

Monday, October 13, 2008

Uninstall old version of SAPGUI for Java

Today I’ll show you how to uninstall old SAPGUI for Java version. To install newer version of SAPGUI for Java, you can check my previuous posting. On this posting, i am going to show you how to uninstall the old version of your SAPGUI for Java.

Coz I use root level to install SAPGUI for Java, so I need to switch my user (ardhian) to my root user :

ardhian@edp-ardhian:~$ su -
edp-ardhian:~ #
edp-ardhian:~ # java -jar PlatinGUI-Linux-710r4.jar uninstall

This last command will uninstall my old (SAPGUI for Java version 7.10rev4) version. Just simple command. I hope this could help you.