Prod:
Non – Prod:
Prod:
Non prod:
Prod
After editing script:
Non – Prod:
DOUBLE TIME:
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/RQ8/sapdata1/temp_1/temp.data1'SIZE
10000M REUSE AUTOEXTEND ON NEXT 20971520 MAXSIZE 10000M;
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/RQ8/sapdata1/temp_2/temp.data2'SIZE
10000M REUSE AUTOEXTEND OFF;
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/RQ8/sapdata1/temp_3/temp.data3'SIZE
10000M REUSE AUTOEXTEND OFF;
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/RQ8/sapdata1/temp_4/temp.data4'SIZE
10000M REUSE AUTOEXTEND OFF;
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/RQ8/sapdata1/temp_5/temp.data5'SIZE
10000M REUSE AUTOEXTEND OFF;
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/RQ8/sapdata1/temp_6/temp.data6'SIZE
10000M REUSE AUTOEXTEND OFF;
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/RQ8/sapdata1/temp_7/temp.data7'SIZE
10000M REUSE AUTOEXTEND OFF;
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/RQ8/sapdata1/temp_8/temp.data8'SIZE
10000M REUSE AUTOEXTEND OFF;
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/RQ8/sapdata1/temp_9/temp.data9'SIZE
10000M REUSE AUTOEXTEND OFF;
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/RQ8/sapdata4/temp_10/temp.data10'SIZE
10000M REUSE AUTOEXTEND OFF;
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/RQ8/sapdata1/temp_11/temp.data11'SIZE
30000M REUSE AUTOEXTEND OFF;
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/RQ8/sapdata1/temp_12/temp.data12'SIZE
30000M REUSE AUTOEXTEND OFF;
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/RQ8/sapdata1/temp_13/temp.data13'SIZE
30000M REUSE AUTOEXTEND OFF;
select USERNAME from dba_users;
select SUBSYSTEM from [Link] where SUBSYSTEM='RP9CLNT400';
Cdpro – AP1
Before:
After:
login/no_automatic_user_sapstar
Before:
After:
brconnect -u / -c -f stats -t system_stats
brconnect -u / -c -f stats -t oradict_stats
brconnect -u / -c -f stats -t all -f collect -p 4
brconnect -u / -c -f chpass -o SAPSR3 -p "bss13new"
alert log
DDIC tho
SICK
SM51
ST22
BDLS:
SM13:
SMQ2:
SMQ1:
SM37
SMQR:
Delete Batch Input Sessions and Logs with report RSBDCREO – older than 2 days
Reorganize SNAP table with report RSSNAPDL – older than 1
Delete statistics for job runtime with report RSBPSTDE – older than 5 days
SE38 --> Execute in background- Abap program RSBTCDEL Make it 7 days -> Execute in background
Cleanup locks - SM12
Cleanup tRFCs - SM58 ; Goto Log File->Reorganize
ValidateSAP logon group - SMLG
Validate SAP parallel generator - RZ12
ValidateSAP operation modes
RZ03:
RZ04:
Validateclient settings
ValidateSMTP settings (SCOT)
ValidateSLD details in RZ70, SXMB_ADMIN,SLDAPICUST
RZ70:
SXMB_ADMIN
SLDAPICUST
Pizza2go
TEMSE – SP12
SM51:
ST06:
ST03n
To rename the prod to qa,
SE37,
St03n after:
SM36:
RZ10:
RZ11:
RZ12:
SMQR:
SMQS:
AL11:
Validate below two parametes and these two parameters same as before refresh
sapgui/user_scripting = TRUE
sapgui/user_scripting_per_user = TRUE
S.N Sour Duratio
Target SID Status
o ce SID n
Complete
1 RP9CLNT400 RQ8CLNT400
d
Complete
2 AP9CLNT400 AQ8CLNT400
d
Complete
3 RP9CLNT000 RQ8CLNT000
d
4 RP9CLNT001 RQ8CLNT001 NA
Complete
5 HP9CLNT400 HQ1CLNT400
d
6 CP9CLNT400 CQ8CLNT400 Complete
d
Complete
7 SP9CLNT400 SQ8CLNT400
d
Complete
8 SP9CLNT500 SQ8CLNT500
d
Complete
9 YP9CLNT400 YQ8CLNT400
d
Complete
10 EP9CLNT400 EQ8CLNT400
d
Complete
11 BP9CLNT400 BQ8CLNT400
d
Complete
12 WPSCLNT400 WQ8CLNT400
d
13 G9PCLNT400 G8QCLNT400 LE
Complete
14 XP9CLNT400 XQ8CLNT400
d
Complete
15 XP9AEX XQ8AEX
d
16 MP9CLNT400 MR8CLNT400 LE
Complete
17 MP9CLNT500 MR8CLNT500
d
WQGCLNT40 Complete
18 WPGCLNT400
0 d
WQGCLNT50 Complete
19 WPTCLNT400
0 d
WQGCLNT60 Complete
20 WPACLNT400
0 d
WQGCLNT80 Complete
21 WPFCLNT400
0 d
WPMCLNT40 WQGCLNT90 Complete
22
0 0 d
23 ZP9SRC ZQ8SRC Inprogress
RP9CLNT400 RQ8CLNT400
CP9CLNT400 CQ8CLNT400
EP9CLNT400 EQ8CLNT400
SP9CLNT400 SQ8CLNT400
SP9CLNT500 SQ8CLNT500
AP9CLNT400 AQ8CLNT400
YP9CLNT400 YQ8CLNT400
MP9CLNT400 MR8CLNT400
MP9CLNT500 MR8CLNT500
BP9CLNT400 BQ8CLNT400
WPSCLNT400 WQ8CLNT400
HP9CLNT400 HQ1CLNT400
RP9CLNT000 RQ8CLNT000
WPGCLNT400 WQGCLNT400
WPTCLNT400 WQGCLNT500
WPACLNT400 WQGCLNT600
WPFCLNT400 WQGCLNT800
WPMCLNT400 WQGCLNT900
XP9CLNT400 XQ8CLNT400
XP9AEX XQ8AEX
ZP9SRC ZQ8SRC
SE06 –
STMS configuration-
YES
NO
YES
YES
YES
YES
STMS
After setting up the password in RQ8
Login to RD8 and delete the system RQ8
YES
YES
Login to RQ8
STMS
Go back to RD8
Approve:
YES
YES
Go back to RQ8
Sm36
User Master Data Import:
Scc7:
SCC3:
400 Client – SCC7
RQ8K900155