Objective: How to delete/remove Non-CDB or 11g database or database home from ExaCC Prerequisite: Should have Non-CDB or 11g home and database on ... Read More
Oracle Announced “Ampere A1 Shapes for VMDB” for the BaseDB Cloud Service – Oracle Database 19c on Arm Platform in OCI
Last week, June 28th, 2023 Oracle released an Arm-based shape for DBCS to use in OCI which supports Oracle Database 19c.
This flexible shape lets us customize OCPUs allocated to an instance.
Writing this blog to provide some insight into using Arm-based shapes for your DBCS.
If you like to read about what is Arm and why we used Arm processor and what are the benefits, please check the below link from Oracle.
Here are the steps to setup Arm shape based DBCS:
Go to OCI –> Click on Oracle Database –> Click on Oracle Base Database Service
Click Create DB System –> Provide the name (I used Arm-DBCS)
Click on Change Shape and select Ampere (Arm-based processors). We have only one shape available Ampere VM.Standard.A1.Flex shape, it’s flexible and you can configure OCPU
I choose 2 OCPU
Next Configure storage, Click on Change Storage
Note: Ampere A1 Shape is only supported on Logical Volume Manager, see below other option greyed out
Next, configure the DB System
Note: Ampere A1 Shape is only supported on single-node DB systems, see below we cant change node count
Also, the Oracle Database standard Edition is not supported on Ampere A1 Shape-based DBCS
Add SSH keys and network details and click next
Provide DB name (I used Armdb) and click on Change database Image)
Note: A database software image can not be used for creating a database on an Ampere A1-shaped DB system, see below I can’t select a database version
So I have to Choose the Oracle Database Software Image
Note: Ampere A1 shape is available for Database version 19c with the 18.104.22.168 and later release updates (RU) only
Provide Database SYS Password (it will be same for TDE Wallet)
Configure Database backups
Note: Ampere A1 shape-based DB system provisioning and restoration are not supported if the backup destination for the database is Autonomous Recovery Service. see below I can not choose that option.
For now, I am disabling the backups
Click on Create DB System, it will take a few mins to provision
Once it’s provisioned, you can see the state available.
Now using a private key I can access the DBCS node and check the database, you can see it 22.214.171.124.0
Also, you can see the Processor Info where you see the architecture is aarch64 using lscpu output
Here Oracle database is ready and running on Arm-based Platform
There are a few important things I like to mention here…
1. The shape of Ampere A1 shape-based DB systems cannot be changed to Intel or AMD shape-based DB systems, and vice versa. see below, I tried to change the shape.
2. Ampere A1 shape-based DB systems do not support Data Guard associations with Intel or AMD shape-based DB systems. see below I tried to enable Data Guard but only possible shape in Ampere only
3. Also, A backup of an Ampere A1 shape-based database cannot be restored on Intel or AMD shape-based DB systems, and vice versa
Note: Oracle Database 19c on LINUX ARM is also available to download now
More from this Author
Introduction: In this blog, I will show you how to use Ansible to automate Oracle database patching. I applied the latest Oracle 19c RU Patch ... Read More