SAP-BASIS

Traits of Outstanding Managers

(This was first published on LinkedIn)

When you've worked as long as I have in IT you start to notice traits and habits of people who are good at their jobs. I've had the pleasure of working for some great managers and this is what they have all had in common:

Communication and Awareness - Share everything!
The best managers keep you in the loop and reward you for returning the favor. This prevents getting side swiped by informal conversations and decisions made outside of standard channels.

One of the biggest questions with an upgrade is to see if it can be completed over a cutover weekend. Are there enough resources available to complete the task within the needed time frame? Is there a way to tell beforehand or will additional resources need to be brought in?

SAP BASIS - SAP on Oracle Cheat Sheet

Checking the SID
select instance from v$thread;
select name from v$database;
select name from v$controlfile;

SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 1: '/oracle/QQ1/sapdata1/system_1/system.data1'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/oracle/QQ1/sapdata1/system_1/system.data1'

SAP Basis Cheat Sheet

General Handy Items for SAP Basis Administration

Note that these are in no particular order

FM for the download basket in Solman:
/TMWFLOW/MO_UI_BASKET_AUTHORIZ

SAP Support CIC Number
800 677 7271

Windows network commands:
netsh interface ip set address "Ethernet" static 192.168.0.77 255.255.255.0 192.168.0.1 1
netsh interface ip set dns "Ethernet" static 8.8.8.8
netsh interface ip add dns "Ethernet" 8.8.4.4 2

RSBDCOS0 (shh! use to run OS commands)

Pages