Tasks Completed So Far
The following steps have been completed up to this point:
Now it is time to create the database on dc1, also known as datacenter1.
Setting the Oracle Environment
To do this, we need to export the local environment variables in the operating system.
One simple way is to first identify the ORACLE_HOME path:
[oracle@dc1 ~]$ cd /u01/app/oracle/product/19c/dbhome/
[oracle@dc1 dbhome]$ pwd
/u01/app/oracle/product/19c/dbhome
Now, by running the following command, we assign a temporary SID name and set the Oracle home:
[oracle@dc1 dbhome]$ . oraenv
ORACLE_SID = [oracle] ? test
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/19c/dbhome
The Oracle base has been set to /u01/app/oracle
We can see that everything is set correctly:
[oracle@dc1 dbhome]$ echo $ORACLE_HOME
/u01/app/oracle/product/19c/dbhome
[oracle@dc1 dbhome]$ echo $ORACLE_BASE
/u01/app/oracle
[oracle@dc1 dbhome]$ echo $LD_LIBRARY_PATH
/u01/app/oracle/product/19c/dbhome/lib
Creating the Database Using DBCA
Now we can safely run DBCA.
-
Select Create Database
-
Choose Advanced Configuration
-
On the next page, select General Purpose
On the next screen, enter the database name and instance name.
I selected vahiddb as the database name and vahidpdb as the PDB name.
Storage Configuration
On the next page, as shown in the image below, we use ASM.
Make sure to check Use Oracle-Managed Files.
Archive Log Configuration
On this page, check both options to enable ARCHIVELOG mode and specify the archive log destination.
Listener Selection
Use the listener that was created during the Grid Infrastructure installation.
Optional Components
We skip the Data Vault page.
On the next page, make sure to check Add Sample Schemas.
On the following page, uncheck the option.
Password Configuration
Set your desired passwords.
On the next page, no changes are required.
Start Database Creation
Click Finish to start the database creation process.
Video Link
YouTube video link for this section in persian