Join David Yahalom for an in-depth discussion in this video Create an Oracle 12c R2 database, part of Oracle 12c Release 2 New Features & The Oracle Cloud.
- [Instructor] To create the new database in the Oracle cloud, all you have to do is log in to the Oracle Database Cloud Service console, which we did in our previous video, and click on the Create Service button. Here, you will be guided through a wizard and fill some information that is required to provision and create your new Oracle database in the cloud. First, we'll have to name our database. So, under Service Name, let's type: DemoDB. Next, we'll have to select a metering frequency.
Hourly means pay for the number of hours used and Monthly means pay one low reduced price for the entire month, irrespective of the number of hours used. As long as you are in the trial period and do not exceed the amount of credits Oracle provides no billing should occur, but I would suggest choosing Hourly just in case. You will also need to select the Oracle database version you want for your Oracle database.
You can choose between previous Oracle releases such as Oracle 11g Release 2 and Oracle 12c Release 1 or, and this is what we are all here for, choose Oracle 12c Release 2, the latest and greatest Oracle database version. For this course, we will, of course, choose Oracle 12c Release 2. You can also choose your Oracle database edition. We will keep the regular Enterprise Edition option selected for the sake of our demos.
You can also choose if you want to create a Single Instance Oracle database or add Rack or Data Guard functionalities. Oracle Rack and Oracle Data Guard are two different Oracle, high availability technologies but are well outside the scope of this course, so let's choose and keep the default Oracle Single Instance option for now. Now that that's done, let's click on the Next button. Over in the next screen, you can specify your Oracle instance name.
Let's keep the default ORCL for our demos and since this is an Oracle 12c Release 2 database which has a multi-tenant architecture, you need to specify the name for your first pluggable database. This database will be automatically created for you inside the Oracle instance. Let's keep the default value of PDB1. You will also need to specify a password for the all-powerful SysDBA Administrator User. This is the user you will use to manage and administer your Oracle database.
Note that this password has to be fairly complex and include both uppercase and lowercase letters as well as numbers and a special character.
- Registering for a new Oracle Cloud free trial account
- Creating an Oracle 12c R2 database in the Oracle Cloud
- Configuring SSH access to the database
- Advanced database configuration
- Connecting to your Oracle Cloud database
- PDB resource management
- PDB cloning
- PDB flashback
- Read-only partitions
- Transforming non-partitioned tables to partitioned tables automatically
- Creating a table for Exchange automatically
- Automatic list partitioning