We will use create service wizard to create a service in oracle cloud.
The wizard takes you through below options.
Service Level
Oracle 12.2 is not available in oracle database cloud service virtual image service level.
Oracle Database Cloud Service - Virtual Image
It is a compute environment with pre-installed virtual machine that include all software needed to create and run an Oracle Database.
We connect to the virtual machine and run the DBCA to create database.
All maintenance operations like backup, patching and upgrades should be done manually, They are not automated.
Oracle Database Cloud Service
It is a Virtual machine plus database created according to specifications provided in the Create Service wizard.
It will have tools that provides automatic and on-demand backups, patching and upgrading, and point-in-time recovery for Oracle Databases.
Cloud Tools
bkup_api utility used to perform on-demand backups where as in RAC environments we use raccli. We can chnage the configuration of how backups are configured.
orec of dbaascli utility used to restore from backups where as in RAC environments we use raccli.
dbpatchm of dbaascli utility used for automatic patching where as in RAC environments we use raccli.
We use DBaaS Monitor web application to monitor Oracle databases and computing resources. It is not available on the Oracle RAC deployments on cloud.
Metering Frequency is of 2 types
Hourly - Pay only for hours used during your billing period. We cannot switch the metering frequency from hourly to monthly once database has been deployed in cloud.
Monthly - Pay one price per month irrespective of number of hours used. We cannot switch the metering frequency from monthly to hourly once database has been deployed in cloud. Deployments that are created in middle of month the price is pro-rated. We only pay partial month amount from the start date.
Oracle Database Software Release
We can create Oracle database 11g R2, 12c R1 and 12c R2 deployments in cloud. Oracle 12.2 is not available in oracle database cloud service virtual image service level.
We can install following Oracle Database Software Editions.
Standard Edition
Enterprise Edition
Enterprise Edition - High Performance
Enterprise Edition - Extreme Performance
If we choose Enterprise Edition or Enterprise Edition - High Performance, all available database enterprise management packs and Enterprise Edition options are included in the database deployment.
The packs and options that are not part of the software edition you chose are available to you for use on a trial basis.
We can create following types of database deployments in Oracle cloud.
Single instance - Instance and database data store in a single compute node.
Database Clustering with RAC - A two node clustered database, Each compute node has one instance and two instances access the same shared database data store.
Single instance with dataguard standby - Two single-instance databases, one acting as the primary database and one acting as the standby database in an Oracle Data Guard configuration.
Database clustering with RAC and datagaurd standby - Two two-node Oracle RAC databases, one acting as the primary database and one acting as the standby database in an Oracle Data Guard configuration.
Dataguard standby fr hybrid DR - Single-instance database acting as the standby database in an Oracle Data Guard configuration. The primary database is on your own system.
Single instance is the only supported type for Oracle database cloud sevice - virtual image service level.
Single instance is the only supported type in standard edition.
The two RAC types are only supported in Enterprise Edition - Extreme Performance.
The wizard takes you through below options.
Service Level
Oracle 12.2 is not available in oracle database cloud service virtual image service level.
Oracle Database Cloud Service - Virtual Image
It is a compute environment with pre-installed virtual machine that include all software needed to create and run an Oracle Database.
We connect to the virtual machine and run the DBCA to create database.
All maintenance operations like backup, patching and upgrades should be done manually, They are not automated.
Oracle Database Cloud Service
It is a Virtual machine plus database created according to specifications provided in the Create Service wizard.
It will have tools that provides automatic and on-demand backups, patching and upgrading, and point-in-time recovery for Oracle Databases.
Cloud Tools
bkup_api utility used to perform on-demand backups where as in RAC environments we use raccli. We can chnage the configuration of how backups are configured.
orec of dbaascli utility used to restore from backups where as in RAC environments we use raccli.
dbpatchm of dbaascli utility used for automatic patching where as in RAC environments we use raccli.
We use DBaaS Monitor web application to monitor Oracle databases and computing resources. It is not available on the Oracle RAC deployments on cloud.
Metering Frequency is of 2 types
Hourly - Pay only for hours used during your billing period. We cannot switch the metering frequency from hourly to monthly once database has been deployed in cloud.
Monthly - Pay one price per month irrespective of number of hours used. We cannot switch the metering frequency from monthly to hourly once database has been deployed in cloud. Deployments that are created in middle of month the price is pro-rated. We only pay partial month amount from the start date.
Oracle Database Software Release
We can create Oracle database 11g R2, 12c R1 and 12c R2 deployments in cloud. Oracle 12.2 is not available in oracle database cloud service virtual image service level.
We can install following Oracle Database Software Editions.
Standard Edition
Enterprise Edition
Enterprise Edition - High Performance
Enterprise Edition - Extreme Performance
If we choose Enterprise Edition or Enterprise Edition - High Performance, all available database enterprise management packs and Enterprise Edition options are included in the database deployment.
The packs and options that are not part of the software edition you chose are available to you for use on a trial basis.
We can create following types of database deployments in Oracle cloud.
Single instance - Instance and database data store in a single compute node.
Database Clustering with RAC - A two node clustered database, Each compute node has one instance and two instances access the same shared database data store.
Single instance with dataguard standby - Two single-instance databases, one acting as the primary database and one acting as the standby database in an Oracle Data Guard configuration.
Database clustering with RAC and datagaurd standby - Two two-node Oracle RAC databases, one acting as the primary database and one acting as the standby database in an Oracle Data Guard configuration.
Dataguard standby fr hybrid DR - Single-instance database acting as the standby database in an Oracle Data Guard configuration. The primary database is on your own system.
Single instance is the only supported type for Oracle database cloud sevice - virtual image service level.
Single instance is the only supported type in standard edition.
The two RAC types are only supported in Enterprise Edition - Extreme Performance.
