Showing posts from 2009

Run TP command in background

In Unix,

nohup tp import P28KT00687 D28 client300 pf=TP_DOMAIN_D28.PFL U128 &

Optimizer and DBchecks

In Unix,

 = to run the update stats, use
    brconnect -u / -c -f stats -t ALL
     >> you may also use the above to address the kosima dbverify alert.

 = to run the dbcheck manually again.
    brconnect -u / -c -f check

TP command and how to check status

how to add buffer via TP
tp addtobuffer P28KT00687 pf=TP_DOMAIN_D28.PFL D28
tp import P28KT00687 D28 client300 pf=TP_DOMAIN_D28.PFL U128

Check status of the transport
tail -f P28IT00687.D28

You may also user ps -ef|grep tp

Install SAP license Unix level

In Unix with SIDADM,

saplicense -installenter the system IDenter Hardware keyenter installlation noenter expiration date - 99991231
enter the license_keyLicense successfully installed.

Refresh df every 5mins

am2hc181:orad28 253> sh
$ while true
> do
> df -gt | grep archivpool
> sleep 300
> done
C4DEM1SYM62_2324:/vol/ARCHIVE00/SITI2324_archiv_pool/D28_archivpool   1020.00    481.24    538.76   48% /oracle/D28/archivpool

Create control files

In DBrefresh, you will need to create controlfile from tracefile.

In sqlplus,
alter database backup controlfile to trace resetlogs;this file can be found in /oracle/SID/saptrace/usertrace

SQL Alter tabase

During DB refresh, you will need to copy sapdata. Before doing so, you have to alter database backup mode for tablespace to active

In sqlplus,

Change oraarch directory to a larger folder

This command does not need to restart db.You can do it at run time
In sqlplus,

SQL> show parameter log_archive_dest;
SQL> startup mount;
SQL> alter system set log_archive_dest='/oracle/D28/oraarch' scope=memory;

* LOCATION will be the new path for your archive log folder.
* you may remove LOCATION word if sqlplus gives error.

Unix command

mkdir dbxxx            - Make dir dbxxx
df - g .                     - Current folder size
df - g | grep sap       - grep folder with
rm -rf exe*              - Remove file and folder with name exe*
cp -r exe /oracle/W91/saptrace/usertrace    - copy folder exe to  /oracle/W91/saptrace/usertrace

sudo /usr/bin/rootsh -i -u rootsudo rootsh -i -u rb4adm(don't copy paste, type manually)

Manuall import transport from Unix

In unix, execute

tp addtobuffer P28KT00687 pf=TP_DOMAIN_D28.PFL D28tp import P28KT00687 D28 client300 pf=TP_DOMAIN_D28.PFL U128P28KT00687 is the transport number
DOMAIN_D28 is the transport domain (you get from stms)
D28 is the target csystem
client300 is the target client
U128 is the combination of below:

0: Called a overtaker; change request can be imported from buffer without deleting it and then uncoditional mode 1 is used to allow another import in the correct location.

1: If U1 is used with the export then it ignores the correct status of the command file; and if it is used with import then it lets the user import the same change request again.

2: When used with tp export, it dictates the program to not to expand the selection with TRDIR brackets. If used in tp import phase, it overwrites the originals.

3: When used with tp import, it overwrites the system-dependant objects.

5: During the import to the consolidation system it permits the source systems other than the integra…

Login to sqlplus

From unix, execute

sqlplus "/as sysdba"

Changing user from root

Once login to your ID, you execute

sudo su - rootthen you can change to su -t01admthen you can also change to su - orat01

Migration Explained

Migration is a synonym for heterogeneous system copy.

Your SAP system is converted from non-Unicode to Unicode. This can also be done as part of a homogeneous or heterogeneous system copy.

A system that resides on more than one physical or virtual hosts in a network, and can be accessed transparently as an entity.

The SAP system containing the original database is called the source system and the system to which the database copy is to be imported is called the target system.

VNC from Windows to SuSE 10

Linux, execute yast2 > security and users > Local Security Custome > next until you see "Allow remote graphical login" (see below) Check and save. Terminal > su root vncserver Enter a password to access desktop Once finish go to cd /root/.vnc/ vi xstartup and change the original to #!/bin/sh xrdb $HOME/.Xresources xsetroot -solid grey xterm -geometry 80x24+10+10 -ls -title "$VNCDESKTOP Desktop" & /usr/X11R6/bin/gnome & Save xstartupTo kill a session, use vncserver -kill 'servername':1 (Eg:test01:~/.vnc # vncserver -kill test01:1)

Mount Windows folder to Linux

1. SU root
2. Enter below command
3. test01:/ # mount -t cifs //windows/share /media/install -o user=Domain/username

BRTOOLS to turn off archive log

Firstly you check acrhivelog status

BRTOOLS1 = Instance management
6 - Show instance statusContinue x22 - Show instance status

Information about the status of database instance R53

 1 - Instance number (number) ........... 1
 2 - Instance thread (thread) ........... 1
 3 - Instance status (status) ........... OPEN
 4 - Instance start time (start) ........ 2009-11-07 02.34.33
 5 - Oracle version (version) ...........
 6 - Database creation time (create) .... 2009-10-12 04.09.24
 7 - Last resetlogs time (resetlogs) .... 2009-08-20 07.11.28
 8 - Archivelog mode (archmode) ......... ARCHIVELOG
 9 - Archiver status (archiver) ......... STARTED
10 - Current redolog sequence (redoseq) . 18914
11 - Current redolog SCN (redoscn) ...... 16310535260
12 - Number of SAP connections (sapcon) . 26

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

To turn achive log off,Brtools 1 = Instance manageme…

SuSE Linux + Netweaver 2004s installation guide


1) Installalling SuSE Linux Enterprise Server 10

2) Installing SAP Netweaver 2004s (ABAP+JAVA)

3) Install SAP GUI (java based)


1) Installing SUSE Linux Enterprise Server 10 for AMD64 and Intel 64


01. Download the required image and burn it into a bootable DVD.

02. Power up the machine with the bootable DVD.

03. Choose boot from CD/DVD

04. Install

05. English/US

06. New Installation

07. Clock - Asia/KL

08. Expert > change > partitioning > create custom partition

09. Choose 2.IDE 457GB.. /dev/sdb ( this may differ on your hardisk)

10. Entire hardisk

11. Expert > Change > Software

12. Select Additional > File server + DHCP + C/C++ compiler

13. Expert > change > booting > finish

14. Accept > Install

15. Install > restar > boot from hardisk

16. Root pwd is "penguin7"

17. Hostname is "test…