SAP SYSTEM STOP | START | MEMORY CLEAN ON UNIX

This blog covers all SAP Unix commands to Bounce SAP systems and clean memory: <iframe src=”//www.googletagmanager.com/ns.html?id=GTM-NKZ9FM” height=”0″ width=”0″ style=”display:none;visibility:hidden”></iframe> SAP System Bounce Sequence with all commands on Unix: Batch Job Hold To hold critical batch jobs and check active jobs before bringing down application Shutdown System stopsap all(stop sap system) Kill remaing processes ps –ef|grep sidadm ( check if any process is running) kill -9 PID (kill the process) Clean Memory cleanipc <systen no>remove (clean shared memory) for ex:- cleanipc 00 remove cleanipc 01 remove ipcs|grep sidadm ( to check if shared memory still exists if entries found) clean as ……

TDMS- TEST DATA MIGRATION SERVER — PRESTEPS

SAP Test Data Migration Server (SAP TDMS) is a high-speed data tool that transfers business data from your SAP production system to your development, test, quality training system. By enabling the transfer of just the relevant set of application data from the SAP production system, SAP TDMS allows you to create a lean and consistent non-production system. Recommended system settings for TDMS Refer to OSS Note 890797 for the recommended settings for Control / Central / Sender / Receiver systems. Some of the required system settings are given below: Central system:  Dialog work processes – 15 (minimum 6)  ……

HOW TO CHANGE SCHEMA PASSWORD FROM BRTOOLS

PASSWORD CHANGE FROM BRTOOLS: Please follow similar steps as below: Open brtools >> brtools BR0651I BRTOOLS 7.20 (33) BR0280I BRTOOLS time stamp: 2013-08-05 12.28.27 BR0656I Choice menu 1 – please make a selection ——————————————————————————- BR*Tools main menu 1 = Instance management 2 – Space management 3 – Segment management 4 – Backup and database copy 5 – Restore and recovery 6 – Check and verification 7 – Database statistics 8 – Additional functions 9 – Exit program Standard keys: c – cont, b – back, s – stop, r – refr, h – help ——————————————————————————- BR0662I Enter your choice: 8 ……

HOW TO CHECK ORACLE TABLESAPCE USAGE

OPEN SQLPLUS — sqlplus / as sysdba Execute below query : select a.TABLESPACE_NAME, round(total,1) Total_M, round(free) Free_M, round(100*(1-free/total),1) Usage from (select TABLESPACE_NAME,sum(BYTES)/(1024*1024) total from dba_data_files group by TABLESPACE_NAME) a ,(select TABLESPACE_NAME,sum(BYTES)/(1024*1024) free from dba_free_space group by TABLESPACE_NAME) b where a.TABLESPACE_NAME=b.TABLESPACE_NAME(+) order by 4 DESC; Output will show all tablesapce usages :

Oracle Database Query Important -Blog1

How to change archive to no archive-log Mode shutdown db and follow below steps >startup mount; >alter database noarchivelog; >alter databse open; select log_mode from v$database;   tablespace growth history SELECT TO_CHAR (sp.begin_interval_time,’DD-MM-YYYY’) days , ts.tsname , max(round((tsu.tablespace_size* dt.block_size )/(1024*1024*1024),2) ) cur_size_GB , max(round((tsu.tablespace_usedsize* dt.block_size )/(1024*1024*1024),2)) usedsize_GB FROM DBA_HIST_TBSPC_SPACE_USAGE tsu , DBA_HIST_TABLESPACE_STAT ts , DBA_HIST_SNAPSHOT sp , DBA_TABLESPACES dt WHERE tsu.tablespace_id= ts.ts# AND tsu.snap_id = sp.snap_id AND ts.tsname = dt.tablespace_name AND ts.tsname NOT IN (‘SYSAUX’,’SYSTEM’) and sp.begin_interval_time > sysdate -16 and ts.tsname=’PSAPSR3′ GROUP BY TO_CHAR (sp.begin_interval_time,’DD-MM-YYYY’), ts.tsname ORDER BY ts.tsname, days; list out Active session in db   SELECT a.sid,a.serial#, ……