HOW TO SAP

Step by step manual guide with screenshot for Basis, Security Authorization & Abap

Popular Posts

  • HOW TO SAP - STMS transport hang with truck icon
    At times transport will hang with status Truck icon Check https://forums.sdn.sap.com/thread.jspa?threadID=972797&tstart=100 Logi...
  • Webdynpro - User session (HTTP/SMTP/..) closed after timeout
    There are two solution for this. Solution 1: Follow SAP note  1948291 - User session (HTTP/SMTP/..) closed aft by increasing the http...
  • HOW TO SAP - Change retention settings in ST03
    ST03 Collector and DB performance > Performance Database > Workload Collector Database > Reorganization > Control Settin...

Blog Archive

  • ►  2019 (14)
    • ►  July (4)
    • ►  June (8)
    • ►  May (2)
  • ►  2018 (1)
    • ►  January (1)
  • ►  2017 (65)
    • ►  December (16)
    • ►  November (18)
    • ►  October (26)
    • ►  September (1)
    • ►  August (3)
    • ►  June (1)
  • ►  2014 (1)
    • ►  August (1)
  • ►  2013 (2)
    • ►  December (1)
    • ►  March (1)
  • ►  2012 (5)
    • ►  June (3)
    • ►  February (2)
  • ►  2011 (88)
    • ►  October (3)
    • ►  September (8)
    • ►  August (8)
    • ►  July (4)
    • ►  June (14)
    • ►  May (22)
    • ►  April (11)
    • ►  March (14)
    • ►  February (2)
    • ►  January (2)
  • ►  2010 (1)
    • ►  October (1)
  • ▼  2009 (17)
    • ▼  October (12)
      • Run TP command in background
      • Optimizer and DBchecks
      • TP command and how to check status
      • Install SAP license Unix level
      • Refresh df every 5mins
      • Create control files
      • SQL Alter tabase
      • Change oraarch directory to a larger folder
      • Unix command
      • Manuall import transport from Unix
      • Login to sqlplus
      • Changing user from root
    • ►  September (1)
    • ►  August (3)
    • ►  June (1)
  • ►  2008 (20)
    • ►  January (20)
2013-2017. Powered by Blogger.
HOW TO SAP

Run TP command in background

October 27, 2009   TRANSPORT, unix,
In Unix,

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

Optimizer and DBchecks

October 26, 2009   oracle,
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
Continue Reading

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

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

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

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

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

Change oraarch directory to a larger folder

October 24, 2009   oracle,
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.
Continue Reading

Unix command

October 24, 2009   unix,
mkdir dbxxx            - Make dir dbxxx
df - g .                     - Current folder size
df - g | grep sap       - grep folder with ms.sap
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 root
sudo rootsh -i -u rb4adm  (don't copy paste, type manually)
Continue Reading

Manuall import transport from Unix

October 24, 2009   TRANSPORT,
In unix, execute

  • tp addtobuffer P28KT00687 pf=TP_DOMAIN_D28.PFL D28
  • tp import P28KT00687 D28 client300 pf=TP_DOMAIN_D28.PFL U128
P28KT00687 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 integration system.

6: When used in import phase, it helps to overwrite objects in unconfirmed repairs.

8: During import phase it ignores the limitations caused by the table classification.

9: During import it ignores that the system is locked for this kind of transport.
Continue Reading

Login to sqlplus

October 24, 2009   oracle,
From unix, execute

  • sqlplus "/as sysdba"
Continue Reading

Changing user from root

October 24, 2009   unix,
Once login to your ID, you execute

  • sudo su - root
  • then you can change to su -t01adm
  • then you can also change to su - orat01
Continue Reading
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)
Designed By: Blogger Templates | Templatelib