Instance Architecture Enhancements In 12.2(12c R2) From Oracle Database 12c Release 2 (12.2), read-only and read/write instances can co-exist within a single database. It supports for read/write and read-only instances in the same database. As we know that every database instance is either read/write or read-only. Read-Only Instances Read-only instances Read more…
Direct Upgrade to Oracle Database 12c A direct upgrade is one where either the Database Upgrade Assistant (DBUA) or command-line upgrade script is used to upgrade your database to Oracle Database 12c. Direct upgrade is supported when the source database is running one of the releases shown in the following Read more…
Starting Order Of Mandatory Background Process In Oracle Database 12cR2-: Starting Order Of Mandatory Background Process In Oracle Database 12cR2-: 1-PMON 2-CLMN 3-MMAN 4-PMAN 5-DBWR 6-LGWR 7-CKPT 8-SMON 9-RECO 10-LREG 11-MMON 12-MMNL You can check the order in Alert Lg File ============================================================ Starting background process PMON———————-PMON-1 2018-11-19T09:53:01.153343+05:30 PMON started with Read more…
New Mandatory Background Processes In Oracle Database 12cR2-: Mandatory background processes are present in all typical database configurations. These processes run by default in a read/write database instance started with a minimally configured initialization parameter file. BWnn (Database Writer Processes) Cleanup Main Process (CLMN) Cleanup Helper Processes (CLNN) LGnn (Log Read more…