How to Build 19c RAC - 4 of 4 - Creating a RAC Database

  • by

After Oracle database 19c software has been installed, we can now create a RAC database by Database Configuration Assistant (DBCA).

[oracle@primary01 ~]$ dbca
Oracle 19c Database Creation by DBCA - 01

Oracle 19c Database Creation by DBCA - 01

Oracle 19c Database Creation by DBCA - 02

Oracle 19c Database Creation by DBCA - 02

Oracle 19c Database Creation by DBCA - 03

Oracle 19c Database Creation by DBCA - 03

Oracle 19c Database Creation by DBCA - 04

Oracle 19c Database Creation by DBCA - 04

We would like to use a Container Database (CDB) to host our PDB.

Oracle 19c Database Creation by DBCA - 05

Oracle 19c Database Creation by DBCA - 05

In this case, the CDB is ORCLCDB, the PDB is ORCLPDB. Don't forget about the template of PDB is PDB$SEED.

Oracle 19c Database Creation by DBCA - 06 - 01

Oracle 19c Database Creation by DBCA - 06 - 01

Since we choose NOT to use Oracle-Managed Files (OMF), we'd better to create some directories by grid for data files in case of ORA-15173: entry 'pdbseed' does not exist in directory.

It's due to non-existing paths during RMAN restoration.

[grid@primary01 ~]$ asmcmd mkdir +DATA/ORCLCDB
[grid@primary01 ~]$ asmcmd mkdir +DATA/ORCLCDB/pdbseed
[grid@primary01 ~]$ asmcmd mkdir +DATA/ORCLCDB/ORCLPDB

I know it sounds weird, but it did happen if I don't create necessary directories in advance.

Oracle 19c Database Creation by DBCA - 06 - 02

Oracle 19c Database Creation by DBCA - 06 - 02

Oracle 19c Database Creation by DBCA - 07

Oracle 19c Database Creation by DBCA - 07

Oracle 19c Database Creation by DBCA - 08

Oracle 19c Database Creation by DBCA - 08

Oracle 19c Database Creation by DBCA - 09 - 01

Oracle 19c Database Creation by DBCA - 09 - 01

Oracle 19c Database Creation by DBCA - 09 - 02

Oracle 19c Database Creation by DBCA - 09 - 02

Oracle 19c Database Creation by DBCA - 09 - 03

Oracle 19c Database Creation by DBCA - 09 - 03

Oracle 19c Database Creation by DBCA - 09 - 04

Oracle 19c Database Creation by DBCA - 09 - 04

Oracle 19c Database Creation by DBCA - 09 - 05

Oracle 19c Database Creation by DBCA - 09 - 05

Oracle 19c Database Creation by DBCA - 10

Oracle 19c Database Creation by DBCA - 10

Oracle 19c Database Creation by DBCA - 11

Oracle 19c Database Creation by DBCA - 11

Oracle 19c Database Creation by DBCA - 12 - 01

Oracle 19c Database Creation by DBCA - 12 - 01

I made an animated image for showing all initialization parameters including advanced ones. It will rotate next image in two seconds.

Oracle 19c Database Creation by DBCA - 12 - 01 - Initialization Parameters including Advanced

Oracle 19c Database Creation by DBCA - 12 - 01 - Initialization Parameters including Advanced

For static images, please refer to the post: Complete Initialization Parameters List in DBCA 19c.

Oracle 19c Database Creation by DBCA - 12 - 02

Oracle 19c Database Creation by DBCA - 12 - 02

Oracle 19c Database Creation by DBCA - 12 - 02 - 01

Oracle 19c Database Creation by DBCA - 12 - 02 - 01

Oracle 19c Database Creation by DBCA - 12 - 02 - 02

Oracle 19c Database Creation by DBCA - 12 - 02 - 02

Oracle 19c Database Creation by DBCA - 12 - 02 - 03

Oracle 19c Database Creation by DBCA - 12 - 02 - 03

Did you see those directories? That's why we created 3 directories in advanced after step 6. If you forgot to create them, it's still OK to create them now.

[grid@primary01 ~]$ asmcmd mkdir +DATA/ORCLCDB
[grid@primary01 ~]$ asmcmd mkdir +DATA/ORCLCDB/pdbseed
[grid@primary01 ~]$ asmcmd mkdir +DATA/ORCLCDB/ORCLPDB
Oracle 19c Database Creation by DBCA - 12 - 02 - 04 - 01

Oracle 19c Database Creation by DBCA - 12 - 02 - 04 - 01

Oracle 19c Database Creation by DBCA - 12 - 02 - 04 - 02

Oracle 19c Database Creation by DBCA - 12 - 02 - 04 - 02

Oracle 19c Database Creation by DBCA - 12 - 02 - 04 - 03

Oracle 19c Database Creation by DBCA - 12 - 02 - 04 - 03

Oracle 19c Database Creation by DBCA - 12 - 02 - 04 - 05

Oracle 19c Database Creation by DBCA - 12 - 02 - 04 - 05

Oracle 19c Database Creation by DBCA - 12 - 02 - 04 - 06

Oracle 19c Database Creation by DBCA - 12 - 02 - 04 - 06

Oracle 19c Database Creation by DBCA - 12 - 02 - 05

Oracle 19c Database Creation by DBCA - 12 - 02 - 05

Oracle 19c Database Creation by DBCA - 12 - 03

Oracle 19c Database Creation by DBCA - 12 - 03

Oracle 19c Database Creation by DBCA - 13 - 01

Oracle 19c Database Creation by DBCA - 13 - 01

Oracle 19c Database Creation by DBCA - 13 - 02

Oracle 19c Database Creation by DBCA - 13 - 02

Oracle 19c Database Creation by DBCA - 13 - 03

Oracle 19c Database Creation by DBCA - 13 - 03

Oracle 19c Database Creation by DBCA - 14 - 01

Oracle 19c Database Creation by DBCA - 14 - 01

Oracle 19c Database Creation by DBCA - 14 - 02

Oracle 19c Database Creation by DBCA - 14 - 02

Oracle 19c Database Creation by DBCA - 14 - 03

Oracle 19c Database Creation by DBCA - 14 - 03

Oracle 19c Database Creation by DBCA - 14 - 04

Oracle 19c Database Creation by DBCA - 14 - 04

Oracle 19c Database Creation by DBCA - 15 - 01

Oracle 19c Database Creation by DBCA - 15 - 01

Oracle 19c Database Creation by DBCA - 15 - 02

Oracle 19c Database Creation by DBCA - 15 - 02

Oracle 19c Database Creation by DBCA - 16

Oracle 19c Database Creation by DBCA - 16

Let's check all cluster services, they should all be online.

[grid@primary01 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       primary01                STABLE
               ONLINE  ONLINE       primary02                STABLE
ora.chad
               ONLINE  ONLINE       primary01                STABLE
               ONLINE  ONLINE       primary02                STABLE
ora.net1.network
               ONLINE  ONLINE       primary01                STABLE
               ONLINE  ONLINE       primary02                STABLE
ora.ons
               ONLINE  ONLINE       primary01                STABLE
               ONLINE  ONLINE       primary02                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       primary01                STABLE
      2        ONLINE  ONLINE       primary02                STABLE
      3        ONLINE  OFFLINE                               STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       primary01                STABLE
      2        ONLINE  ONLINE       primary02                STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       primary01                STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       primary02                STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       primary02                STABLE
ora.LISTENER_SCAN4.lsnr
      1        ONLINE  ONLINE       primary02                STABLE
ora.MGMT.dg(ora.asmgroup)
      1        ONLINE  ONLINE       primary01                STABLE
      2        ONLINE  ONLINE       primary02                STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       primary02                169.254.6.64 192.168
                                                             .24.12,STABLE
ora.OCR.dg(ora.asmgroup)
      1        ONLINE  ONLINE       primary01                STABLE
      2        ONLINE  ONLINE       primary02                STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       primary01                Started,STABLE
      2        ONLINE  ONLINE       primary02                Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       primary01                STABLE
      2        ONLINE  ONLINE       primary02                STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       primary02                STABLE
ora.mgmtdb
      1        ONLINE  ONLINE       primary02                Open,STABLE
ora.orclcdb.db
      1        ONLINE  ONLINE       primary01                Open,HOME=/u01/app/o
                                                             racle/product/19.0.0
                                                             /db_1,STABLE
      2        ONLINE  ONLINE       primary02                Open,HOME=/u01/app/o
                                                             racle/product/19.0.0
                                                             /db_1,STABLE
ora.primary01.vip
      1        ONLINE  ONLINE       primary01                STABLE
ora.primary02.vip
      1        ONLINE  ONLINE       primary02                STABLE
ora.qosmserver
      1        ONLINE  ONLINE       primary02                STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       primary01                STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       primary02                STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       primary02                STABLE
ora.scan4.vip
      1        ONLINE  ONLINE       primary02                STABLE
--------------------------------------------------------------------------------

On the other side, check the status of the database.

[oracle@primary01 ~]$ srvctl status database -d orclcdb
Instance ORCLCDB1 is running on node primary01
Instance ORCLCDB2 is running on node primary02

So far so good.

Next, you should check at least two things:

  1. Database Connection
  2. You should try to connect the database from an outside client by SQL*Plus or other tools.

    By default, Oracle provides only one service name for each PDB, which is the same as the PDB name. If you want more services to be added to your PDB, you can do it by yourself.

  3. Oracle Enterprise Manager Database Express
  4. I think you may counter some problems when first logon the utility.

Leave a Reply

Your email address will not be published. Required fields are marked *