Thursday, 7 October 2010

Freespace in Oracle database

select tablespace_name, sum(bytes/1024/1024) from dba_free_space group by tablespace_name;

Wednesday, 15 September 2010

URL for web GUI

To access the web GUI use the following URL:

http://<server>:<port>/sap/bc/gui/sap/its/webgui/!

Tuesday, 27 July 2010

Some terminal commands

To pause the current session:
  • ctl+z
To list paused sessions:
  • jobs
To make the current session a foreground session:
  • fg %<number in brackets from 'jobs'>
Create new Xterm session with scroll bars running in the background:
  • xterm -sb &

SAP GUI installation check

To check the installation of the SAP GUI client version 7.10 and 7.20, run NWCheckWorkstation.exe (located in C:\Program Files\SAP\SapSetup\setup).

For previous versions of the GUI run "sapsetup.exe /check"

Thursday, 10 June 2010

SRM URL

Standard URL to SAP SRM system:
http://<server>:<port>/sap/bc/gui/sap/its/bbpstart

Thursday, 3 June 2010

SAP PI URL

To invoke the Runtime Work Bench:
http://<server>:<port>/rwb/

To invoke Integration Tools web page from ABAP:
SXMB_IFR

Tuesday, 11 May 2010

Find the volume group for a file system

In order to find the volume group that a filesystem is on:

df -g <file system>

Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/<filesystemname> 40.00 2.42 94% 541 1% /oracle/EXD

lslv <filesystem name>

VOLUME GROUP: cstdexdvg VG IDENTIFIER: 00c724b200004c000000011f1381fa92
VG STATE: active PP SIZE: 128 megabyte(s)
VG PERMISSION: read/write TOTAL PPs: 959 (122752 megabytes)
MAX LVs: 256 FREE PPs: 366 (46848 megabytes)
LVs: 6 USED PPs: 593 (75904 megabytes)
OPEN LVs: 6 QUORUM: 2 (Enabled)
TOTAL PVs: 1 VG DESCRIPTORS: 2
STALE PVs: 0 STALE PPs: 0
ACTIVE PVs: 1 AUTO ON: yes
MAX PPs per VG: 32512
MAX PPs per PV: 1016 MAX PVs: 32
LTG size (Dynamic): 256 kilobyte(s) AUTO SYNC: no
HOT SPARE: no BB POLICY: relocatable

Friday, 12 February 2010

Run transaction in another user's session

To cause a transaction to run in another user's session:
  • SE37
  • Enter "TH_CREATE_FOREIGN_MODE"
  • Execute
  • Enter the client, username and transaction code you wish to run
  • Execute




Note: You must be on the same application server as the user in order for this to work.

Wednesday, 3 February 2010

Microsoft App-V Commands

List virtual applications to which user has access:


  • Open command prompt
  • sftmime /query obj:app /short
 
To start a command prompt in a the same session that an application is running in:

  • List applications as shown above
  • sfttray.exe /exe cmd "<full application name>"
To start the Application Virtualisation Client MMC plug in:

  • SFTCMC.MSC