DBATechGuide

 Oracle Application Express : https://docs.oracle.com/database/apex-5.1/HTMIG/overview.htm#HTMIG363 alter system set compatible='19.0.0' scope=spfile; alter system set sec_case_sensitive_logon=TRUE scope=both; alter system reset sec_case_sensitive_logon scope=spfile; tdpoconf showenv -tdpo_optfile=tdpo.opt tdpoconf password -tdpo_optfile=tdpo.opt ========================================================================== select SID, SID_CATEGORY from oracle_adm.sid_v4 where appl_grp not in ('SAP','DECOM','EXTERNAL') and sid like '%\_S%' escape '\'; ========================================================================== If agent goes down multiple time after restarting it again & again, please try below oS cmd :- <AGENT_INST_HOME>/bin/emctl setproperty agent -allow_new -name CollectionResults.MaximumRowsFloodControlMax -value 80000 <AGENT_INST_HOME>/bin/emctl setproperty agent -allow_new -name CollectionResults.MaximumRow...

This Blog will help you to do database refresh from Prod(source) database to Test/Dev(target) database :- Prechecks :- ------------------------ To finding the size of each databases source and target :- ================================= select sum(bytes)/1024/1024/1024 from dba_data_files; ============================================== Do test connection from prod and test separately. show parameter undo (both servers) ===================================================== 1. Stop the database on target server. > shut immediate (Target) Database closed. Database dismounted. ORACLE instance shut down. $ nslookup zne-db1021 Truncated, retrying in TCP mode. Server:         143.97.1.115 Address:        143.97.1.115#53 Name:   zne-db1021.statoil.no Address: 10.80.129.25 ======================================== On Source : Check for any scheduled backup, if yes the stopped it during activity. crontab -l crontab -e put # in archivelog fi...