cpadmin.sh – alternate for cmclean.sql in R12.2
R12 E-Business Suite Concurrent Processing Script Cpadmin.sh Command Line Utility Which Consolidates Existing CP Tools…
How to apply opatch in silent mode
$ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /d01/oracle/patches/ocm_opatch.rsp 1> patch 27264965 cd /d01/oracle/patches/27264965 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./$ORACLE_HOME/OPatch/opatch apply…
owm issue
export PATH=$FMW_HOME/webtier/bin:$FMW_HOME/oracle_common/bin:$PATH owm now it work
SAR report for past 1 month
cd /var/log/sa ls -ltrtotal 63488-rw-r–r– 1 root root 990899 Oct 17 23:53 sar17-rw-r–r– 1 root…
Live workshops
https://bit.ly/golivelabs
Pluggable database refresh cancel
To cancel refresh mode alter pluggable database pdb1 refresh mode manual; alter pluggable database pdb1…
Transportable Tablespace
V4 Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 2471245.1) https://dohdatabase.com/2020/11/23/minimal-downtime-migration-with-full-transportable-export-import-and-incremental-backups/ https://dohdatabase.com/2020/12/09/how-to-migrate-a-database-using-full-transportable-export-import-and-incremental-backups/
DG Status
— From Dgmgrl side:# dgmgrl /DGMGRL> show configuration verboseDGMGRL> show database verbose <primary_db>DGMGRL> show database…
Standby Settings for archive logs
Here are the setting, do you want to change as given by you Primary CONFIGURE…
Step by Step Oracle 19c Physical Standby CDB Database Setup
http://mydbspace.com/?p=269