Wishing everyone a very Happy New Year! 2020 was challenging for all of us and full of uncertainties. I pray the coming year is the opposite, filled with hope and good health. I want to thank all of you for the love and support. God bless us all and hope that we all have a great 2021!
“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in December 2020. It’s a short list this month, and I slacked during the holidays 🙂 I hope you find these helpful to learn something new or to remind you of its existence and use.
| #OraTidbit #db19c In Oracle Grid Infrastructure, you can use Fleet Patching and Provisioning to automate relocation of a pluggable database (PDB) from one multitenant container database (CDB) to another. |
| #OraTidbit #db19c The Observe-only mode for Oracle Data Guard Broker’s Fast-Start Failover allows you to test automatic fast-start failover without any impact on the production database in an Oracle Data Guard broker configuration. |
| #OraTidbit #db19c Oracle Network Log File Segmentation feature allows you to configure the maximum size and number of text log files for Oracle Network components such as Oracle Net Listener Connection Manager (CMAN) and global services manager. |
| #OraTidbit #ADBDedicated Autonomous Database fleet administrators create, monitor, and manage the core (Autonomous Exadata Infrastructure, Exadata Infrastructure, and Autonomous Exadata VM Cluster) and Autonomous Container Database resources. Database administrators create, monitor, and manage Autonomous Databases. |
| #OraTidbit #ADBDedicated On Autonomous Database Dedicated Infrastructure, Oracle schedules and performs all patching and other maintenance operations on all infrastructure resources. You can specify when such maintenance operations can occur and what kind of database patching is performed. |
| #OraTidbit #ADBDedicated Autonomous Data Guard creates and maintains a primary database that your applications connect to and use, and a standby database that is a synchronized copy of the primary database. In Oracle Autonomous Database Dedicated Infrastructure, the Fleet administrator configures and manages Autonomous Data Guard at the Autonomous Container Database level. |
| #OraTidbit #ADBDedicated Using the compartment quotas feature of Oracle Cloud Infrastructure, Autonomous Database Dedicated Infrastructure fleed administrators can restrict the availability of OCPUs and data storage on a compartment by compartment basis. |
| #OraTidbit Oracle Autonomous Database is integrated with the Oracle Cloud Infrastructure Work Requests feature. Work requests allow you to monitor long-running operations like the creation of an Autonomous Database. A work request is an activity log that enables you to track each step in the operation’s progress. |
| #OraTidbit New features announced for Oracle Database #db20c are now part of #db21c – 20c is no longer a GA database version. Oracle Database 19c is the current long-term version, the next innovation release is Oracle Database 21c. |
| #OraTidbit #db21c Oracle Database 12c Release 2 family supports direct upgrade to 21c (12.2.0.1, 12.2.0.2 or 18c, 12.2.0.3 or 19c). If your Oracle Database is a release earlier than release 12.2, then you cannot directly upgrade your Oracle Database to 21c. |
| #OraTidbit #db21c Starting with Oracle Database 21c #AutoUpgrade automates the steps necessary to upgrade a database in an Oracle Data Guard configuration. AutoUpgrade 21c also automates all the steps needed to upgrade an Oracle Real Application Clusters (Oracle RAC) database. |
| #OraTidbit #db21c Starting with Oracle Database 21c #AutoUpgrade automates steps to convert a database from a non-CDB to a PDB as part of a database upgrade. AutoUpgrade automates unplugging a PDB from a CDB plugging it into a higher version CDB and upgrading the PDB to that new target version. |
| #OraTidbit #db21c All upgrades to Oracle Database 21c must use the multitenant architecture. If you are (manually) upgrading a non-CDB you must convert the non-CDB to a PDB before upgrade or you plug in the non-CDB Oracle Database to an Oracle Database 21c CDB. (Or use #AutoUpgrade which automates the conversion) |
| #OraTidbit #OrclAPEX Oracle APEX Application Development (APEX Service) is an Oracle Cloud service offering convenient access to the Oracle Application Express platform for rapidly building and deploying low-code applications. APEX Service instance creates an underlying Oracle Autonomous Database. |
| #OraTidbit #OrlAPEX Oracle APEX Service on OCI does not allow Oracle Net Services (SQL*Net) connectivity, no instance cloning, and Oracle Machine Learning (OML) Zeppelin notebook not included. |