TP command and how to check status

TP command and how to check status

October 26, 2009   TRANSPORT,

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
/usr/sap/trans/tmp
tail -f P28IT00687.D28

You may also user ps -ef|grep tp Continue Reading

Install SAP license Unix level

Install SAP license Unix level

October 26, 2009   license, unix,

In Unix with SIDADM,

• saplicense -install
• enter the system ID
• enter Hardware key
• enter installlation no
• enter expiration date - 99991231
  
• enter the license_key

License successfully installed. Continue Reading

Refresh df every 5mins

Refresh df every 5mins

October 25, 2009   script, unix,

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 Continue Reading

Create control files

Create control files

October 24, 2009   oracle,

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
  

Continue Reading

SQL Alter tabase

SQL Alter tabase

October 24, 2009   oracle,

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,

• ALTER DATABASE BEGIN BACKUP;
• once complete the copy of files,
• ALTER DATABASE END BACKUP;
  

Continue Reading