Create a DB instance

A database in Oracle is also known as a DB instance, and Oracle can choose to create a database during the installation process, or it can be installed and then created.

Generally, the creation of a database can use graphical interface and SQL instructions, because of the complexity of SQL instructions, this is only a graphical interface approach.

1. Create a DB instance using the Database Configuration Assistant visualization tool.

(1) Start the Database Configuration Assistant tool in the Start menu first.

　　

(2) After the start page is as follows:

　　

Here we select the operation of the DB instance, and we choose to create the database.

　　

Here you select the template used by the DB instance. Select according to the use.

　　

This fills in the name of the DB instance (very important, the name of the data to be connected in the future)

　　

Here's the next step:

　　

Here enter the database with the user's password, can be set separately, can also be set to the same password

　　

Here Select the location where the database files are saved: File system

　　

Database Recovery area: Default

　　

Choose whether to install the sample data table, size 130M, and select Install as needed.

　　

Memory Size: Default

　　

When all is set, the summary page is displayed.

　　

As a final step, tick create database to start installing the DB instance, which takes about 5-10 minutes to wait.

　　

These are the installation steps for an Oracle DB instance.

Create a DB instance