Tell about your self ?

HI , Thanks for giving this opertunity , tHIS IS ADITYA , iAM A BTECH GRADUATOR , i have 3 yrs + exp
eriance on sap basis , I am from TCS Hyderabad ,
COMING TO MY ROLES AND RESPONSIBILITIES
Doing health check activities
Doing Trasport import activities
Doing kernel patch upgrade
Applying support packages
clinent administration activities
user administration activities
Implementing sap notes
Take care about data base backups
worked with oracle 11g database and windows operating system ( windows 2008 server )
++++++++++++++++++++
what are the modules you have in your project ?
BW ( 7.31), ECC6 EHP 6 , PI 7.4 , EP 7.31 , SOLMAN 7.1 ,crm,srm ( 7.31 )
+++++++++++++++++
What is your landscape
it is a 3 sytem landscape -- development , quality , production
++++++++++++++++============
what are the oprating system , you have worked on ?
Windows ( 2008 server ) , Linux ( Redhot linux -- 6.2)
+++++++++++++++++===============
what are the databases you have worked on
Oracle -- 11G ( 112_64 , [Link].0)
=============+++++++++++++++===========
how to do Health checks activities ?
sm50 - is there any workprocess in private mode or on hold state if any kill them ( dpmon ) -- dwp1 -- 342
5 -- private mode -- kill -- new 3426
sm51 - how many applications are in active state
sm04 - how many users are logged in locally
Al08 - how many users are logged in globally
sm12 - lock entries , shold not be more than a day if any kill them with user approval
sm13 - there should not be any failure updates
st02 - whether sap buffer hit ratio is more than 98% or not ?
st04 -whether db buffer hit ratio is more than 94 % or not ?
st06 - cpu , swap , file system utilizations are how much ?
st03n - dailog response time should not be more than 800 ms
smlg - logon load balancing is how much ?
st22 - abap dumps
to know how many dumps are existed in sap system , we will call tcode -- st22

EASY way to remembering health checks tcodes -- SM50,SM51,SM66,SM37,SM04,AL08,SM21,SM12,S

M13,SMLG,SMQ1,SMQ2
ST02,ST03N,ST04,ST06,ST22
DB01,DB02,DB12,DB13,DB14,DB16
SP01,SP02

Health Check questions

IF YOU FIND Lock entries WHAT DO YOU DO ?
Ans >>> if i found a lock entri more than a day , with d user approval , i will kill/delete the lock entry -- sm
12
++++++++++
IF YOU FIND failure updates WHAT DO YOU DO ? -- sm14 (update mechanism is in active state or is it
in in-acitive need to check ?) , oraarch direcotry full ,
table space utilization is full, lock entries ?
++++++++++++++++++++++++==
long running jobs -- sm66 / sm37 -- by choosing the status -- active
if you find long running job , What is your action ?
Ans >>> if i find a long running job Either in SM66/SM50 or in SM37 , i will follow below steps
1> Some times it depends on how much load it was been given on the job
2> oraarch directory full
3> table space utilization full
4> cpu and swap utilization more than threshold value
5> updates failures
6 > database statistics are not up to date
7>sto5 system trace
8> work load analysis -- st03n ( dialog response time ) -- peek hours , sto3n ranking section , how Load b
alancing , tcode vise performance -- st12/stad
9>customising reports are running if any ?
++++++++++++++++++++++===================
cancelled jobs ? == sm37 by choosing the status -- cancelled
if you find Cancelled jobs , what you will do ?
Ans >> i will follow below steps
1> LOCK ENTRIES
2> DEPENDEND JOB FAIL
3>MANUAL TERMINATE
4> oraarch directory full
5> table space utilization full
6> cpu and swap utilization more than threshold value
7> updates failures
8 > database statistics are not up to date
9> FILE SYSTEM UTILIZATION IS MORE IN sap and database level
10> rfc or target system is in down state
++++++++++++++++++++++++===
logs -- sm21 -- license experice , in correct credentials use ,, n no of sessions open , update failures , st22
dumps , tcode terminate
st22 dumps -- any 3 ?
sm50 - wp is in private mode -- dpmon / sm50 -- cancel the wp with core / with out care ?
sm04 -- upon user approval -- terminate user sessions
st02 -- swap utilization more -- upon reading the notes, found a clue that increase roll area , extended me
mory so increased , also increased the buffer parameters
st06 -- cpu and file system utilization is more ? os team co ordinate
st03n - dialog response time is more? how much the load balance is via smlg ,with in the sto3n via rankin
g section which user consuming more dialog response time
smq1/smq2- whether port numbers are in opened or not in we20 , RFC Connections ? -- pi consultants ap
proach
db01 - dead locks -- memory issue , insufficent memory allocate
+++++++++++++++++++++++++++++++++++++++
Could you explain any Few ABAP DUMPS , you have faced in your carrier ?
1>>>>TSV_TNEW_PAGE_ALLOC_FAILED means thatmore memory was requested by the system
because the program needed to expand an internal table,but Memory is not enough.
((Roll area,extended memory area(EM),,fixed storage space (HEAP)))
2>>>>system_no_task_storage ( latest patch apply -- sap components -- sap_basis,sap_abap,sap_pi)
For this error, please go to service market to download the latest patch for your SAP Application
release and apply the patch.
3>>>>>SYSTEM_CORE_DUMPED ( kernel patch upgrade ) is related toR/3 system [Link] the k
ernel patchto the
latest may solve the issue.
4>>>>>Message_Type_X/RAISE_EXCEPTION ( sap gui error -- 730--->740)
Is aGUI related [Link] for latest GUI version to avoid this error.
5>>>>TIME_OUT Error
rdisp/gui_autologout parameter = 800 sec -- 1200 sec
++++++++++
SSO ( SINGLE SIGN ON )Configuration:
abap -- login/creat_sso2_ticket = 1
login/accept_sso2_ticket =2 -- RZ10
ABAP -- STRUSTSSO2 - Export the abap certificate
Java ( [Link] ) -- Export the java certificate
ABAP -- Strustsso2 -- import the java certificate
Java -- nwa -- deploy-ticket keystore--abap certificate import
++++++++++++++++++++
SLD - System landscape directory, It is a pure java system
Tcodes - RZ70 - GATEWAY HOST , GATEWAY SERVICE (bridge info )-- ACTIVATE ,, TRIGGER ( IT C
OLLECTS THE INFO from all the components AND PASS THAT TO SLD System )
SLDAPICUST -- SLD HOST,SLD PORT NUMBER,SLD USER,SLD USER PASSWORD
SLDCHECK -- to know whether SLD is working or not ?
Java system -- visuval admin tool(nwa)-- slddata supplier -- http setttings - maintain below
SLD HOST,SLD PORT NUMBER,SLD USER,SLD USER PASSWORD
trigget the java system data to your sld system
NOTE : SLD SYSTEM IS A JAVA SYSTEM
SLD TO SOLMAN -- DAA ( DIAGNOSTIC AGENT ) -- it will pust the data from sld to solman
++++++++++++++++++++++++
let me know what are the POST INSTALLATION ACTIVITIES , You have done ?.

SICK/SM28
SLICENSE -- applying license
RZ10 -- importing sap profiles from os level to sap level
SE06 -- CTS CONFIGURATION
STMS -- configuring trasport management system.
SM36 -- STANDARD BACKGROUND JOBS
DB13 -- DB BACKUP’S Schedule
SM59 -- RFC’S connections
BD54 /SALE -- LOGICAL SYSTEM CREATion
SCC4 -- CLIENT CREATion
SGEN -- PROGRAM COMPILER
SMLT -- NEW LANGUAGE INSTALLATION
OPERATION MODE ( RZ04,SM63,RZ03 )
SU01 -- USERS CREATION
SCCL -- LOCAL CLIENT COPY FROM MASTER CLIENT 000 TO BUSINESS CLIENT - 100
++++++++++++++++++++++++++++++++++++++++++++
How to open and close the client ?
SCC4
*Client copies
local client copy ( SCCL )
remote client copy ( SCC9 )
Export(SCC8)/Import(Stms_import,SCC7) method

client copy presteps

db backup should be taken (brtools , DB13 )
archive log backup should be disable
maintance certificate (tempory license )need to be up to date ( market place )
intimate d end user ( SM02 )
lock the users in target client ( EWZ5 , SU10 )
target client size estimation - SA38 - Run the following reports -- ( RSSPACE CHECK & RSTABLE SIZE )
++++++++++++++++++++++++
My production sap System is slow ?
1> os level -- dpmon -- whether all dialog workprocess are free or hanged by some user or whether they a
re private mode ?
open the wp’s -- from os level by using dpmon , kill the workprocess
2> oraarch directory full -- /oracle/SID/oraarch -- redolog backup ( archive log ) -- sucessful not runining ?

via brtools -- archive log backup trigger

[Link] ( /oracle/SID/112_64/dbs/ -- small setting -- disk full , another disk change ( storage location p
arameter )
3> we found that system is in hang state -- if u run any commond at os level taking long time
reboot -p
restart -- stopsap R3
cleanipc instance number remove
cleanipc 00 remove
(it will remove hanged memories )
STILL IF U FIND ANY SERVICES ARE RUNNING --
ps -ef|grep dw
ps -ef|grep sidadm
kill -9 sevice id
startsap R3
4> table space utilizatio is full
psapsr3,psapsr3db -- brootls -- space management -- add the data files to sap table spaces
5> file system utilization is above the threshold value -- /usr/sap -- below the 90% , but -- 99%
i have deleted the unwanted files or i have moved those files
++++++++++++++++++++++
if my sap production System is not coming up , Then how ?

1st do cross check

1> if os is linux or unix
ps -ef | grep dw
ps -ef | grep sapsid
OR
if os is windows
[Link] -- listener,saposcol,sapservice sid ,oracle service sid

2> is the connectivity b/w sap and db existed or not

1 st check whether listener is up or not
orasid>lsnrctl check
if listener is down then start it first by following command
orasid>lsnrctl start
2nd -- R3trans -d
connectivity b/w sap and db is ok or not -- 0000 -- connection is ok
if return code 0012 -- connection between those are not ok
Possible reasons::--
1>schema user lock ( brconnect ) , 2>db files might have been corrupted ( restore and recovery )
file system utilization at db level -- os team co ordinate -- file system utilization volume increase

3>>license experience ( maintance certificate -- 3 months )

/usr/sap/SID/DVEBMGS00/WORK -- dev_disp,dev_msg,dev_w*,[Link],stdserverstart

4>>mount point missing -- /usr/sap/SID/SYS/exe ,, /usr/sap/SID/SYS/profile - os team co ordinate -- u wi

ll make missing directoires are in mount
profile parameters are maintained correctly -- sappfpar check pf=instance profile
Central sevices ( SCS ) -- msg and enq servers up and running or not
5>>> oraarch directory full -- /oracle/SID/oraarch -- redolog backup ( archive log ) -- sucessful not runining
?
via brtools -- archive log backup trigger
[Link] ( /oracle/SID/112_64/dbs/ -- small setting like -- disk full , another disk change ( storage locati
on parameter )
6>>>>we found that system is in hang state -- if u run any commond at os level taking long time
reboot -p
restart -- stopsap R3
cleanipc instance number remove
cleanipc 00 remove
(it will remove hanged memories )
7>>> table space utilizatio is full
psapsr3,psapsr3db -- brootls -- space management -- add the data files to sap table spaces
8>> file system utilization is above the threshold value -- /usr/sap
i have deleted the unwanted files or i have moved those files
+++++++++++++++++++++++
STMS CONFIGURATION
Login to Dev system - 000 and ddic
call SE06 -- DO CTS Configuration ( change transport system ) -- prodcution transport layers and routes
will be converted to quality transport layers and routes
Call STMS -- DO The local stms configuration and create virual system configuration with qualith and pro
duction sytems
login to quality and production systems, setup the stms configuration with devlopment system
once done setup the transport layers and routes configuration with Quality and Production
2 rfc connections will be created those are TMSADM and TMSUP
Transport layers are two types -- standard layer and coustmising layer
Transport routes are two types -- consolidated route ( from dev to quality sytem) and Delivery route ( from
quality to production system )
+++++++++++++++++++++++
if in my production system Transport request import is taking long time , what is your action ?
1 > check first of all whether -- event based job -- rddimpdp is running or not ? if not in se38 --run rddnew
pp report and just trigger
2> PSAPSR3 / PSAPSR3DB Table spaces are running with above the threshold value -- with the help of
brtools ( table space increase )
3> /usr/sap/trans -- has less free space
4>oraarch directory is full - run the archive log backup
+++++++++
what are difference between tranport domain and tranpor group and transport directory ?
what is your domain controller sytem ans > Development system and why that system only ?
+++++++++++++++++++++++
DB Backup -- brtools,DB13,brbackup (online db backup ),brarchive(redo log backup )
DB12 -- BACKUP Related log files /erros
++++++++++++++++++++++++++++++++++++
How to restart your sap system ?
restart --
STOPING
su - sidadm
sidadm > stopsap R3
sidadm> cleanipc instance number remove
cleanipc 00 remove
(it will remove hanged memories )
STILL IF U FIND ANY SERVICES ARE RUNNING --
sidadm>ps -ef|grep dw
sidadm>ps -ef|grep sapsid
sidadm>kill -9 sevice id

DB STOP
orasid>lsnrctl stop
orasid>sqlplus / as sysdba
sql>shutdown immediate;
exit
Starting
orasid>lsnrctl start
orasid>sqlplus / as sysdba
sql>startup;
su - sidadm
sidadm>startsap R3
+++++++++++++++++++++
how to apply sap note -- via tcode : Snote --

Note --- 2 types

manuval and corrective note
manual -- changes need to be taken by basis consultant -- CAN NOT BE IMPLEMENTED
Corrective note -- CAN BE IMPLEMENTED - SNOTE
Once implemented can not be revert back -- abapers help
while applying note-- Note will be added to Transport request
+++++++++++++++++++
How to use sum tool ? what you have done with sum tool ?
SPS 13 TO SPS 17
SUM -- Downtime will be decreased ,, no manuval involvement to uncar ,, at a time u can apply the stack
to both abap and java systems
benifits -- EHP Upgrade , vertion upgrade , release upgrade , migration ( DMO Method )
1st download the sum software kept at /usr/sap/SID/SUM and do uncar
sum lunch -- ./startup and to open sum gui - [Link]
as pre requisite -- stack xml file generate -- solution manager system -- solman_workcenter tcode -- optio
ns--> change mangement-->
maintance optimiser --> new maintance traction -- select the target release
SUM Phases -- there are 8 PHASES - Initilization phase , extraction phase,configuration phase,check pha
se,pre processing phase,
execution/downtime phase , post processing phase , finalization phase
+++++++++++++++
Difference bw 7.0 / 7.31
7.0 -- services - - sdm,dispacther,server0
7.31 -- sevices -- icm,server0
7.0 -- 3 profiles - start,instance,default
7.31 -- 2 profiles -- default , instance
7.0 - SDM,JSPM,CONFIGTOOL,VISUL ADMIN TOOL,NWA
7.31 -- CONFIGTOOL,NWA,JSPM,SUM TOOL
7.0 -- JCONTROL,JLUNCH
7.31 -- JSTARTUP
7.0 - JCMON
7.31 -- JSMON
+++++++++++++++
What is Difference between remote and export/import method

remote client copy depends on rfc and network connections

due to dependency of network it takes long time to send huge amount of data
both source and target should be up and running

Export/Import depends on STMS connection

U need to export 1st in source system and later import the same data in target system
large amount of data can be send with in d less time
Note :: among both the copies Export / Import method is the best one
+++++++++++++++++
how to do the Kernel path Upgrade ?
Download kernel files like db dependent and db independent files from market place
uncar them using sapcar -xvf files
stop sap and services
take exe directory as backup
copy the uncared files and paste them in /usr/sap/SID/SYS/exe/run location

run ./[Link] to give permissions to saposcol and brtools,ICMBND

[Link] to copy kernel files from central instance to dialog instance
start sap and sevices

If system is not coming up after kernel patch upgrade , then how ?

whether all the Services are up and running ?
whether we have downloaded and applied the correct kernel patch
whether sapcar may be become old ? incomplete uncar ?
goto work directory -- /usr/sap/SID/DVEBMGS00/work -- check the error at dev_disp,dev_msg,stdserver.l
og,[Link],[Link]
at final stage roll back the kernel exe dirctory which was taken backup earlier
+++++++++++++++++
How to apply support packages and what are the support packages pre requisites ?

Login to 000 client and User like ddic

check with stms configuration
check recent db backup is available
minimum 2 backgroud workprocess are required
check spam/saint vertion upgrade
check sap license
intimate the users and lock them
download support packages and uncar them
load those uncared packages into sap with the help of SPAM Tcode
First import spam/saint update
click on display/define button
select which is required one and schedule the job with backgroud workprocess
+++++++++++++
differance between configtool and visuval admin tool

Configtool - no credentials required when the time of login , Only db is requried and sap is optional while l
ogin
server counts ( sever0 ,server1) can be incresed and decreased
java memory parameters ( heap memory , perm size , thread counts ) can be maintained

Visuval admin tool - credentils r required when time of login , sap and db must be up and running
remote logon is possible , Listens the P4 Port , Benifts --- Java Licese , Jco rfc provider( ABAP TO java) ,
sld data supplier,destinations,
Ticket keystorage ( SSO CERTIFICATE ) Export/import, logs can be viewed
++++++++++++++++++++
***Differance betweeen SDM and JSPM
SDM - software depoyment manager
only single patches can be done
it has its own user id and password
.SCA and .SDA Files can be deployed and undeployed

JSPM - Java software provistioning manager

single and multiple files ( stack file ) can be deployed at a time
it depends on SDM Credentials
only deployment is there but there is no undeployment options
+++++++++++++++++++
****DB Refresh activities
Steps need to carried on production system ?
-----------------------------------------
Take online db backup from production
generate trace file (database backup controlfile to trace;)
copy above two files along with redo log files to quality system

Steps need to be done on the quality system :

-------------------------------------------
do presteps in quality like stms,al11,slicense,we20,we21,db13,smlg,rz12,rz04,sm63,sldapicust,rz70,stust
sso2 tcodes screenshots
export users , add usr02,rfcdes,tbdls table to transport of copies , It will generate a new TR

Drop database of quality system

resote quality database with d help of database backup file of production system
change trace file to [Link]
open [Link] ( change production sid to quality sid , reuse=set , noarchive logs = archive logs )
run @[Link] in nomount state
in mount state with d help of redo log files do recovery ( dbrecover using backup controlfile until cancel )
open database
run @[Link]
open ur sap with sap* and pass
call btctrans1 to pause background jobs
disable mail chain(scot),printers(spad)
apply license
run BDLS (to convert source logical system to target logical system )
import profiles (rz10)
import users and rfc connections
schedule backups (db13)
+++++++++++++++++
DB ADMINISTRATION:
Either Brtools / db13
Online db backup ( DB13 ) -- TAPE Production -- every a day once
Redo log backup ( db13 ) -- Disk Production -- every 4 hours once
brrestore ,, brrecovery
brstatistics - brconnect
db cleanup logs
table spaces increse -- brtools -- space management
missing indexes -- brtools -- segment management
+++++++++++++++++++++++
spfile vs pfile -- these 2 files will store at /oracle/SID/112_64(11204)/dbs
spfile -- sap paramerization file -- binary one , direct modification is not possible , to modify this alter data
base
When d time db is coming up read file - spfile ,, spfile naming convention -- [Link]
pfile -- peramerization file -- static one -- to reflict any changes via this file , restart is required ,pfile namin
g convention - [Link]
once changes are happened in pfile to make them effect in spfile -- "creat spfile from pfile; "
+++++++++++++++++++++
Java system is not comming up , then how?
log flies -- /usr/sap/SID/DVEBMGS00/j2ee/cluster/server0/log -- [Link]
work directory - /usr/sap/SID/DVEBMGS00/work/ -- std_server0,stderror0,dev_icm
jcmon / jsmon -- is there any java service down ,, i mean to say server0,icm should both up and running
Java license expeire
java system connectivity with database ,, Configtool lunch
need to maintain java memory parameters under threshold value
++++++++++++
SLD SYSTEM IS a java stack system
How to do transports ( stms_import) ?
how to monitor long running background job( sm37) ?
how to monitor rfc (sm59)?
How to do oracle database administration ? - brtools(db backup(brbackup),increase table size(brspace),
resote(brrestore)and recovery(brrecovery),
running statics(brconnect)
support packages - SPAM Tcode
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
linux / unix commands
for copy --> cp -pr
for remove --> rm -rf
for move ---> mv
for create a directory --> mkdir
to know which directory your are at --->pwd
full permission--> chmod 777 file name --- chmod -R 777 folder/file
ownership ---> chown group:user filename --- chown sidadm:sapsys filename --- chown orasid:dba filena
me
to open a file --> more filename or view filename or vi editor ,, tail -f filename ,, tail -10f filename ,, tail -100
f filename
esc + x --- character delete
esc + dd -- complete line -- esc + 3dd -- 3 lines delete
esc + i -- u can add new lines
esc + u -- undo
esc + wq! -- save
esc + q! --
to create / modify the file -- vi editor
vi xyz
+++++++++++++++++++
to login to linux, putty is a 3rd party tool
to copy a file from dektop to linux and vice versa -- winscp
++++++++++++++++
your ticketing tool is remedy tool
your concurrent users count ( say around 310 )
how many servers means say ( 13 servers )
your mail is lotus notes
++++++++++++++
db refresh post activities
SAP LICENSE ( SLICENSE )
BDLS Convertion ( BDLS -- LOGICAL SYSTEM Convertion from production system to quality )
STMS CONFIGURATION ( STMS )
BACKUP SCHEDULING (DB13)
STANDARD JOBS SCHEDULING ( SM36 )
importing profiles ( rz10)
sld(RZ70,SLDAPICUST,SLDCHECK) and sso ( STRUSTSSO2 ) configuration
++++++++++++++++++
note implementation ( snote)
+++++++++++++++++++++++++++
13-04-2016

kernel
object and develoer accesskeys
market place
license download
stms_import
client copies
client open and close
presteps of support packages , kernel , client copies, refresh

login -- root , sidadm , orasid , db2sid