SAP – How to reduce space on HANA DB

Februari 19, 2017 Tinggalkan komentar

#ALTER SYSTEM RECLAIM DATA SPACE
#ALTER SYSTEM RECLAIM VERSION SPACE
#ALTER SYSTEM SAVEPOINT
#ALTER SYSTEM RECLAIM LOG
#ALTER SYSTEM RECLAIM DATAVOLUME 110 DEFRAGMENT

Kategori:SAP

SAP – Create trusted RFC between system

Februari 19, 2017 Tinggalkan komentar

STEPS : 

FIO : 100 

1. TRUSTED-USER/mypassword (Dialog)
3. PFCG –> ZRFC
5. Standard RFC WS1CLNT100
7. SMT1
10. Check Generated RFC (TRUSTING@WS1) –> SMT1 –> System that trust current system –> WS1 –> Maintain Destination

WS1: 100
2. TRUSTED-USER/mypassword (Dialog)
4. PFCG –> ZRFC
6. Standard RFC FIOCLNT100
8. Check Generated RFC (TRUSTING@FIO) –> SMT1 –> System that trust current system –> FIO –> Maintain Destination
9. SMT1

Kategori:SAP

SAP HANA configuration path

Februari 19, 2017 Tinggalkan komentar

/hana/shared/<SID>/global/hdb/custom/config

Kategori:SAP

Change Instance Number SAP

Februari 19, 2017 Tinggalkan komentar

# stopsap r3
# cd /usr/sap/BIW/SYS/profile
# cp DEFAULT.PFL DEFAULT.PFL.bak
# cp BIW_D00_idnipcbiw BIW_D00_idnipcbiw.bak
# cp BIW_ASCS01_idnipcbiw BIW_ASCS01_idnipcbiw.bak
# cd /usr/sap/BIW
# cp -r D00 D20
# cd /usr/sap/BIW/SYS/profile
# mv BIW_D00_idnipcbiw BIW_D20_idnipcbiw
# vi BIW_D20_idnipcbiw
change values :
SAPSYSTEM = 20
INSTANCE_NAME = D20
_PF = $(DIR_PROFILE)/BIW_D20_idnipcbiw
Execute_00 = immediate $(DIR_CT_RUN)$(DIR_SEP)sapcpe$(FT_EXE) pf=$(DIR_PROFILE)$(DIR_SEP)BIW_D20_idnipcbiw
Start_Program_02 = local $(_IG) -mode=profile pf=$(DIR_PROFILE)$(DIR_SEP)BIW_D20_idnipcbiw
# startsap r3

ERROR :
Instance profile /usr/sap/BIW/SYS/profile/BIW_D20_idnipcbiw
was not imported because it wasn’t different from the previous version.

SOLUTION :
Change profile files until date modified newest on OS level.

Kategori:SAP

Port Forwarding using IPTables

Februari 19, 2017 Tinggalkan komentar

# echo “1”>/proc/sys/net/ipv4/ip_forward

## Add route :
#iptables -t nat -A PREROUTING -p tcp –dport 3200 -j DNAT –to-destination 10.1.19.33:3200
#iptables -t nat -A PREROUTING -p tcp –dport 3210 -j DNAT –to-destination 10.1.19.47:3210
#iptables -t nat -A PREROUTING -p tcp –dport 3220 -j DNAT –to-destination 10.1.19.46:3220
#iptables -t nat -A POSTROUTING -j MASQUERADE

## Delete Route :
#iptables -t nat -D PREROUTING -p tcp –dport 3220 -j DNAT –to-destination 10.1.19.46:3210

Kategori:Linux