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

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 sqlplus or other tools.

  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 *