ORACLE
Relink all Oracle binaries:
Relink all (Needed mostly after Oracle restore or system restor on another box)
Alter a user's temp tablespace:
Alter user userid temporary tablespace psaptemp2
at SQL:
c/userid1/userid2 (use " if userid has $ )
/
$ORACLE_HOME/bin/oracle and $ORACLE_HOME/bin/oracle0 should have 4755 to let sidadm to shutdown the database.
SAP
Time Zone Setup : STZAC - Changes system wide
Useful BW Transactions: RSD1 --> Repair , RSRV --> Analysis RSMDCNVEXIT --> For upgrade
Logical System Def: BD54
Transport table: E070
SLICENSE for license keys ( instead of saplicense OS command)
Initial SAP screen: http://www.sap-img.com/bc052.htm : SE61 --> General text--> create ZLOGIN_INFO. Icon code list run report RSTXICON. OSS note 205487
??? In the menu items: You can run SAPRSEUG and regenerate all user interfaces.
WINDOWS
Terminal Services Max sessions exceeded:
qwinsta /server: < IP address> to find out connected sessions
rwinsta /server: < IP address> <ID> to kill sessions
qwinsta = Query WINdows STAtion
rwinsta = Reset WINdows STAtion
Source of this information: http://weblogs.asp.net/owscott/archive/2003/12/30/46776.aspx
Solution Manager Related:
Delete Redundant Monitoring LC* trees in APO: Run Report RSLVCAMDEL
To build the trees back: Run Report RSLVCALMON
Delete and Recreate Oracle Monitoring tree: Make sure you reset and delete the Oracle monitoring tree at RZ20 then run report RSDBMON0 to recreate it.
LIBPATH for AIX
If any difficulty arises when youtry to run an exe and could not be found check LIBPATH enviroment variable. For example for upgrades make sure upgrade dir is added to the LIBPATH of the sidadm:
You can update the .profile at the home dir or :
export LIBPATH=$LIBPATH:/usr/sap/put/exe
PATH for AIX:
Make sure the java home dir is defined in this variable thorugh .profile or :
export PATH=$PATH:/usr/java14/bin:/usr/java14/jre/bin
Java home in this example is : /usr/java14
Table Logging: To see how many tables are marked as logging use table DD09L field PROTOKOLL. This field corresponds to the Logging checkbox at SE11 Technical settings.
Parameter value check:
sappfpar check pf=.....
Tp objectlist check:
tp getobjlist SIDtransport-number pf=TPPARAM ( make sure it is configured to get the objects from the SID if not create a temporary parameter file with duplicate entries and replace the SIDs)