Higher Performance Storage and AMD Standard E4 Flex Shapes are now available for Oracle Database Service

AMD Standard E4 Flex Shapes and Higher Performance Storage is now available for Oracle Database Service.

This blog post by Tammy Bednar Senior Director of Product Management at Oracle highlights these exciting new additions to the already expansive array of features boasted by Oracle Database Cloud Service.

This blog post summarizes already available features within the Oracle Database Cloud Service.

• Flexible Provisioning of Compute Resources
• Higher Performance Storage for Greater Throughput & IOPS
• Scaling your Database VM System
• Develop and Deploy Database Applications in OCI

Enjoy this blog post announcing these exciting new capabilities available for Oracle Database Cloud Service.

Cheers.

Now Available: In-Place Upgrade for Oracle Database Cloud Service (DBCS) VM DB Systems

Now Available: In-Place Upgrade for Oracle Database Cloud Service (DBCS) VM DB Systems.

There is a very good blog post by Pravin Jha and Sebastian Solbach at Oracle announcing the In-Place Upgrade General Availability for Oracle Database Cloud Service (DBCS) VM DB Systems.

Here is a quick recap.

• You can now perform an in-place upgrade keeping the characteristics of your existing Oracle VM DB System e.g. SCAN Name, SCAN IPs, private IP addresses, and hostnames remain the same throughout the upgrade process.
• You can now upgrade Oracle Linux version from OL6 to OL7.
• You can upgrade the Grid Infrastructure to the latest or the previous GI 19c version (N-1).
• You can upgrade with minimal downtime in approximately 2 hours using cloning technology.
• You can fallback to a snapshot if a roll back is required.
• OCI console experience.

Enjoy this blog post announcing the In-Place Upgrade General Availability for Oracle Database Cloud Service (DBCS) VM DB Systems.

Cheers.

Moving Your Oracle Database into the Cloud with the Spring 2022 Update of OCI Database Migration

 Moving Your Oracle Database into the Cloud with the Spring 2022 Update of OCI Database Migration.

There is a very good blog post by Alex Kotopoulis Director of Product Management at Oracle on Moving Your Oracle Database into the Cloud with the Spring 2022 Update of OCI Database Migration.

Here is a quick recap.

• Oracle Cloud Infrastructure Database Migration is a fully-managed service that provides users with a fast and easy-to-use self-service experience for migrating databases to Oracle Cloud Infrastructure (OCI).
• Oracle Cloud Infrastructure Database Migration provides logical online and offline migration for enterprise-level database migration with minimal downtime.
• Oracle Cloud Infrastructure Database Migration is based on industry-leading Oracle Zero Downtime Migration engine utilizing Oracle GoldenGate replication.

New Features:

•     Amazon RDS as a source..
•     Interactive Cloud Premigration Advisor (CPAT) results.
•     Auto-create tablespaces.
•     Dynamic display of excluded objects.  

Enjoy this blog post on Moving Your Oracle Database into the Cloud with the Spring 2022 Update of OCI Database Migration.

Cheers.

Quick Into: How to use OCI Tagging to enhance and improve Oracle Cloud Governance

Quick Into: How to use OCI Tagging to enhance and improve Oracle Cloud Governance.

There is a very good blog post by Kris Bhanushali and Adithya Raam Sankar Senior Product Managers at Oracle on How to use OCI Tagging to enhance and improve Oracle Cloud Governance.

Here is a quick intro on How to use OCI Tagging to enhance and improve Oracle Cloud Governance.

• The constant challenge of keeping track of cloud resources can be resolved by applying  the same set of corporate standards to cloud resources as they are applied to on-prem resources.
• Oracle Cloud Infrastructure (OCI) has introduced a standardized best practice approach to managing cloud resources using a set of standard tags.
• Oracle Standard Tags is a set of tag namespaces that governance administrators can deploy in their tenancy to enhance Oracle Cloud governance.
• The namespaces are a collection of most commonly used tags which allow oracle cloud customers to categorize resources for improving security / availability, managing costs as well as improving/enhancing the overall Oracle cloud experience. 
• You can simply select the Oracle Standard Tag namespaces to make these tags available for assignment across the Oracle Cloud Infrastructure (OCI) tenancy.

Enjoy this blog post on How to use OCI Tagging to enhance and improve Oracle Cloud Governance.

Cheers.

Excellent Workshop: How to get started with Oracle Autonomous Database?

Excellent Workshop: How to get started with Oracle Autonomous Database?

There is a very good workshop by Keith Laker and Marty Gubar on How to get started with Oracle Autonomous Database?.Here is a quick recap of this workshop.

• Deploying an Autonomous Database instance optimized for Oracle Data Warehousing workloads.
• How to use Oracle Autonomous Database tools to load object storage sources.
• How to use advanced SQL to find customers at risk?

Enjoy this workshop on getting started with Oracle Autonomous Database.

Cheers.

Exadata Cloud Infrastructure X9M - Exadata becomes even more faster!

 Exadata Cloud Infrastructure X9M - Exadata becomes even more faster!

There is a very good blog post by Tammy Bednar Senior Director of Product Management at Oracle introducing the new Exadata Cloud Infrastructure X9M.

Here is a quick recap:

• The world’s fastest public cloud database platform is now even faster. 
• Exadata Cloud Infrastructure X9M now offers extreme scale out capabilities that benefit both Autonomous Database and Exadata Database Service.
• With more amounts of compute, storage, and networking resources in this latest version of Exadata,  mixed database workloads can be consolidated even more on lesser infrastructure.
• The granular scalability of Exadata Cloud Infrastructure X9M also lowers costs by starting out with smaller configurations.
• Exadata Smart System Software
• Exadata Database Service on Dedicated Infrastructure
• Autonomous Database on Dedicated Exadata Infrastructure
• Exadata Cloud Infrastructure X9M is now available globally. 
• Provisioning/Trying out a new system can be done in as little as 48 hours. 

Enjoy this blog post about the advent of the new Exadata Cloud Infrastructure X9M.

Cheers.

How to use Ansible with Oracle Autonomous Database on Dedicated Exadata Infrastructure?

Quick Into: How to use Ansible with Oracle Autonomous Database on Dedicated Exadata Infrastructure?

There is a very good blog post by Jeffrey Cowen Senior Principal Product Manager on How to use Ansible with Oracle Autonomous Database on Dedicated Exadata Infrastructure.

Here is a quick recap.

• Two Ansible files are needed:
• sample.yaml is the main script which will 
• 1. Create a new Autonomous Container Database (ACD).
• 2. Create a new Autonomous Database (ADB) on top of the newly created ACD.
• 3. List ADBs in a compartment filtered by display name.
• 4. Get facts of the ADB that was created earlier.
• 5. Stop/Start the ADB.
• 6. Kick off the cleanup script.
• teardown.yaml is the cleanup script which can be run by itself.

Enjoy this blog post on How to use Ansible with Oracle Autonomous Database on Dedicated Exadata Infrastructure?

Cheers. 

Oracle Database 21c New Feature: Hybrid Scans with In-Memory

Oracle Database 21c New Feature: Hybrid Scans with In-Memory.

This blog post by Andy Rivenes Product Manager at Oracle highlights this exciting new feature in 21c to the already expansive array of features boasted by Oracle Database In-Memory.

Here is a brief summary.

• Columns are excluded from being populated to save space. If one or more columns of a table are never accessed by analytic queries then, there is no point in using the space in the IM column store to populate them.
• In previous versions, the problem with excluding columns was that, you had to make sure that none of the excluded columns were accessed by your analytic queries or else performance for those queries suffered because the object had to be accessed from the row store.
• Now that In-Memory Hybrid Scans are available in 21c, even if the columns of a table have been excluded and are then part of some analytic queries there usually won't be a huge drop off in performance.
• The cost of running the query in the IM column store and then retrieving a large number of column values from the row store may not be any better than just accessing the data in the row store.
• The query will run slower than if all the columns were populated, but in many instances, it will still run much faster than, if the entire table has to be accessed from the row store. 
• If you are only returning a relatively small number of values then the query can run almost as fast as if all the columns were populated. 
• There is a tradeoff but the space savings can be quite dramatic.

Enjoy this blog post announcing this exciting new capability now available for Oracle Database In-Memory.

Cheers.

Step-by-Step: How to migrate from AWS RDS to Oracle Autonomous Database via Data Pump

Step-by-Step: How to migrate from AWS RDS to Oracle Autonomous Database via Data Pump.

There is a very good blog post by SATYABRATA MISHRA Senior Product Manager at Oracle on How to migrate from AWS RDS to Oracle Autonomous Database via Data Pump.

Here is a quick recap of the steps involved.

• Step 1 - Identify the Source Oracle database on AWS RDS.
• Step 2 - Prepare target Autonomous Database on Oracle DB Cloud.
• Step 3 - Validate compatibility using CPAT (Cloud Premigration Advisory Tool).
• Step 4 - Start the export of the source schema.
• Step 5 - Create an Amazon S3 bucket to upload the data pump dump file. 
• Step 6 - Import the data pump dump file from the  Amazon S3 bucket to Oracle Autonomous Database.

Enjoy this blog post on How to migrate from AWS RDS to Oracle Autonomous Database via Data Pump.

Cheers.

Quick Intro: Database Tools in Oracle Cloud Infrastructure (OCI)

Quick Intro: Database Tools in Oracle Cloud Infrastructure (OCI)

There is a very good blog post by Brian Spendolini Product Manager at Oracle on Database Tools Service in Oracle Cloud Infrastructure (OCI).

Here is a quick recap.

• In November 2021, the Oracle Database Development Tools team launched a service in OCI. This service, called  Database Tools enabled the customerto create a reusable resource for connecting to cloud databases via REST enabled SQL by consolidating all of the pieces of information you need to have to connect to a database.
• No need to remember which database on which server or remembering passwords for database connections.
• Added ability for using OCI policies and defining dynamic groups on who can use these connections.
• Securely store the hostname, port, database name, username, and password creating a reusable, portable resource that can be utilized across clouds, development tools, services, and pipelines.

Enjoy this Quick Intro blog post on the Database Tools service in Oracle Cloud Infrastructure (OCI).

Cheers.

Automatic failover for Autonomous Data Guard enabled Autonomous Databases on Exadata Cloud at Customer and Dedicated Infrastructure

Quick Into: Automatic failover for Autonomous Data Guard enabled Autonomous Databases on Exadata Cloud at Customer and Dedicated Infrastructure

There is a very good blog post by Ranganath Srirangapatna Ramachandra Principal Product Manager at Oracle on Automatic failover for Autonomous Data Guard enabled Autonomous Databases on Exadata Cloud at Customer and Dedicated Infrastructure.

Here is a quick recap.

• Automatic failover AKA Fast-start Failover in Oracle Data Guard.
• Automatic Failover allows Autonomous Data Guard to automatically fail over to your standby Autonomous database in the event of an outage on your primary database.
• Automatic failover rapidly fails over the standby Autonomous database to the primary database role without requiring any manual steps.
• Automatic failover is optional and can be enabled/disabled on your Autonomous Container Databases with Autonomous Data Guard.
• Both maximum performance and maximum availability protection modes are available with automatic failover. 
• Automatic failover guarantees zero data loss in Maximum Availability mode.
• Automatic failover ensures no data is lost that is more than the amount of data (in seconds) specified by the FastStartFailoverLagLimit configuration property in Maximum Performance mode. 
• FastStartFailoverLagLimit is set to 30 seconds and applies only to maximum performance mode. Automatic failover is only possible when the configured data loss guarantee can be upheld.
• Oracle automatically troubleshoots and repairs the failure conditions related to the primary database and reinstates it to the standby database role after an automatic failover occurs.
• You can perform a switchover operation to change the database roles to the original state after the failed primary is reinstated to the standby database.

Enjoy this blog post on Automatic failover for Autonomous Data Guard enabled Autonomous Databases on Exadata Cloud at Customer and Dedicated Infrastructure.

Cheers.

Creating Non-CDB Database in ExaCS - Step by Step

This is a short step-by-step using dbaascli on how to create an Oracle Non-CDB database in Oracle Exadata Cloud Service (ExaCS). Here, we will see high-level steps with example to create 19c Non-CDB Database in ExaCS 

There is a very good blog post by Sathis Muniyasamy Principal Cloud Architect at Oracle detailing the following steps.

• List Available Images
• Download the Image
• Create DB Home
• Create Database
• Verify the Database
• Viewing the Non-CDB Database and Home in OCI Console

Enjoy the Oracle Non-CDB database in Oracle Exadata Cloud Service (ExaCS).

Cheers.