SAP, Linux and Oracle Fixes

edit MailNotifierApp.props this file under SUM folder /usr/sap/<sid>/SUM/abap/mailNotifier sum.host    = servername sum.port    = 1128 sum.user    = <SID>adm sum.pwd     = PASSWORD sum.sid     = <SID> sum.type    = sumabap sum.ssl     = false mail.host  = MAIL SERVERNAME mail.port  = 25 mail.user  = mail.pwd   = mail.from  = senderid@test.com mail.to    = receiver@test.com mail.debug = false save this and exit  then run this following command in terminal you have to keep this terminal open to run notification program. java -jar MailNotifierApp.jar properties=MailNotifierApp.props you will get test email after this

First Create Client via SCC4 THEN COPY Client via SCCL profile SAP_CUST After copy login into Client 000 and export default users tcode scc8 create transport Via selecting profiles “ USERS” then import that transport via stms_import Then login into new client and import transport via tcode SCC7 .

Lock user (unlock) lock - is  a record in the field  uflag, "0" - the user is not locked, To Unlock - need to switch field  uflag to "0": Locked SQL> select uflag from sapsr3.usr02 where mandt='000' and bname='SAP*';      UFLAG ----------        128 Not locked: SQL> select uflag from sapsr3.usr02 where mandt='431' and bname='USERNAME';      UFLAG ----------          0 Unlocking: SQL> update sapsr3.usr02 set uflag='0' where mandt='000' and bname='DDIC'; 1 row updated. SQL> commit work; UNLOCK your self update sapr3.usr02 set uflag='0' where mandt='830' and bname='USER';   commit work; RESET PASSWORD PROCESS: SQL> select bcode, passcode from sapsr3.usr02 where mandt='000' and bname= 'DDIC'; BCODE            PASSCODE ---------------- ---------------------------------------- EF82F150AB6136BF 6BBFC576

select owner, table_name, round((num_rows*avg_row_len)/1024) "Size in KB" from All_tables where owner = 'SAPR3' order by "Size in KB" desc; SELECT DS.TABLESPACE_NAME, SEGMENT_NAME, ROUND(SUM(DS.BYTES) / 1024) "SIZE in KB"   FROM DBA_SEGMENTS DS   WHERE SEGMENT_NAME IN (SELECT TABLE_NAME FROM ALL_TABLES where OWNER='SAPR3')  GROUP BY DS.TABLESPACE_NAME,        SEGMENT_NAME;

Please follow below documents to take VNC Session. You need to run highlighted command with Yellow on servers. Need a vnc-server installed;  it’s tigervnc-server for RHEL7 Team will start VNC server process(es) as desired May be one “shared” session for particular/common account to be used across timezones/globe May be one per actual user (A vs. B) Vncserver starts using ports at 5901, but user could specify any port number, even one in their 10,000 list of port exceptions for EIP Team must launch vncserver with the -localhost directive This prevents from binding to any network interface other than localhost Forces them to use an SSH tunnel to access the VNC server No firewall rules for any of the vnc ports, aka 5901…must be over SSH tunnel Any other VNC configuration is on the DBAs; is not a root managed daemon that is started on boot vncserver -autokill -IdleTimeout 900 -localhost

[root@XXXXX ~]# /opt/pbis/bin/find-user-by-name --level 2 username User info (Level-2): ==================== Name:                         username SID:                          S-1-5-21-1960408961-1844823847-1417001333-122211 UPN:                          username@xyz.COM Generated UPN:                NO DN:                           CN=xx\,XXX,OU=XX,OU=XXX,OU=01_Users,DC=aXXX,DC=ixyz,DC=com Uid:                          1971859108 Gid:                          1972229393 Gecos:                        <null> Shell:                        /bin/bash Home dir:                     /home/Domain/username LMHash length:                0 NTHash length:                0 Local User:                   NO Account disabled (or locked): FALSE Account expired:              FALSE Password never expires:       FALSE Password expired:             FALSE Prompt for password change:   YES User can change password:     YES Days till password expires:   6 Logon restriction:   

netstat -ntulp | grep vnc