Author: biju.thomas

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.

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in November 2020. I hope you find these helpful to learn something new or to remind you of its existence and use.

#OraTidbit #SQLcl Oracle SQLcl (SQL Developer Command-Line) is a Java-based command-line interface for Oracle Database. Using SQLcl, you can interactively or batch execute SQL and PL/SQL statements. SQLcl provides inline editing, statement completion, command recall, and supports existing SQL*Plus scripts.

#OraTidbit #Liquibase is an open-source database-independent library for tracking, managing, and applying database schema changes. With the Liquibase feature in SQLcl, you can generate and execute single object changelogs.

#OraTidbit #SQLDev There are two options for working with databases other than Oracle in SQL Developer: Creating database connections so that you can view schema objects and data. Migrating these databases to Oracle to take advantage of the full range of Oracle Database features and capabilities.

#OraTidbit #SQLDev The SQL Developer unit testing feature provides a framework for testing PL/SQL objects, such as functions and procedures, and monitoring such objects’ results over time. You create tests, and for each, you provide information about what is to be tested and what result is expected.

#OraTidbit Users of #AutonomousDB can subscribe to events and get notified. An event could be a resource lifecycle state change or a system event impacting a resource. Example events are DatabaseDownBegin, DatabaseDownEnd, MaintenanceBegin, MaintenanceEnd, DatabaseConnection.

#OraTidbit #OracleCloud Zero Downtime Migration lets you quickly and smoothly move your Oracle databases from on-premises environments and Oracle Cloud Infrastructure Classic to the Oracle Cloud without incurring significant downtime.

#OraTidbit #AutonomousLinux #Linux Every system running Autonomous Linux is patched automatically. This helps keep systems secure and compliant, eliminating the risk of unpatched systems. Ksplice technology allows patching for kernel and key userspace libraries without restarting or scheduled downtime.

#OraTidbit #AutonomousLinux #Linux Oracle Autonomous Linux automatically tunes memory management, network algorithms, and disk I/O based on workload, so applications run at higher performance and better reliability.

#OraTidbit #AutonomousDB #Azure You can use Shared Access Signatures (SAS) URL in any DBMS_CLOUD procedure that takes a URL to access files in Azure Blob Storage, without the need to create a credential. (New Feature)

#OraTidbit #AutonomousDB #AWS You can use a presigned URL in any DBMS_CLOUD procedure that takes a URL to access files in Amazon Simple Storage Service, without the need to create a credential. (New Feature)

#OraTidbit #VirtualBox Oracle VM VirtualBox supports importing of cloud instances from an Oracle Cloud Infrastructure service. When you import a cloud instance, Oracle VM VirtualBox creates and registers a new VM automatically on the localhost.

#OraTidbit #DB20c Starting in Oracle Database 20c, the parameter to enable or disable password file case sensitivity is removed. All passwords in new password files are case-sensitive.

#OraTidbit #DB20c MAX_IDLE_BLOCKER_TIME sets the number of minutes that a session holding needed resources can be idle before it is a candidate for termination. Unlike MAX_IDLE_TIME, MAX_IDLE_BLOCKER_TIME terminates resources only when they are needed.

#OraTidbit #DB20c Oracle ASM Flex Disk Group supports Cloning a PDB in one CDB to a new PDB in a different CDB. Previously point-in-time database clones could only clone a pluggable database (PDB) in a multitenant container database (CDB) to a new PDB in the same CDB.

#OraTidbit Oracle Database AutoUpgrade enables you to upgrade one or many Oracle Database instances at the command-line using a single command and a single configuration file. AutoUpgrade runs the pre-upgrade tasks, performs automated fix-ups where needed, runs the database upgrade, and finishes by completing post-upgrade tasks.