Skip to content

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

We click on Database Configuration Assistant (DBCA) in the menu to initiate the database creation process.

Start Menu - Database Configuration Assistant (DBCA)

Start Menu - Database Configuration Assistant (DBCA)

Create Oracle Database 19c - 1

Create Oracle Database 19c - 1

Create Oracle Database 19c - 2

Create Oracle Database 19c - 2

Create Oracle Database 19c - 3

Create Oracle Database 19c - 3

Create Oracle Database 19c - 4

Create Oracle Database 19c - 4

Create Oracle Database 19c - 5

Create Oracle Database 19c - 5

Create Oracle Database 19c - 6

Create Oracle Database 19c - 6

Create Oracle Database 19c - 6 - 1

Create Oracle Database 19c - 6 - 1

Create Oracle Database 19c - 7

Create Oracle Database 19c - 7

Create Oracle Database 19c - 8

Create Oracle Database 19c - 8

Create Oracle Database 19c - 9 -1

Create Oracle Database 19c - 9 -1

Create Oracle Database 19c - 9 -2

Create Oracle Database 19c - 9 -2

Create Oracle Database 19c - 9 -3

Create Oracle Database 19c - 9 -3

Create Oracle Database 19c - 9 -4

Create Oracle Database 19c - 9 -4

Create Oracle Database 19c - 9 -6

Create Oracle Database 19c - 9 -6

Create Oracle Database 19c - 10

Create Oracle Database 19c - 10

Create Oracle Database 19c - 11

Create Oracle Database 19c - 11

Create Oracle Database 19c - 11 - 1

Create Oracle Database 19c - 11 - 1

Create Oracle Database 19c - 12

Create Oracle Database 19c - 12

Create Oracle Database 19c - 12 - 1

Create Oracle Database 19c - 12 - 1

Create Oracle Database 19c - 12 - 2

Create Oracle Database 19c - 12 - 2

Create Oracle Database 19c - 12 - 3

Create Oracle Database 19c - 12 - 3

Create Oracle Database 19c - 12 - 4

Create Oracle Database 19c - 12 - 4

Create Oracle Database 19c - 12 - 5

Create Oracle Database 19c - 12 - 5

Create Oracle Database 19c - 13 - 1

Create Oracle Database 19c - 13 - 1

Create Oracle Database 19c - 13 - 2

Create Oracle Database 19c - 13 - 2

Create Oracle Database 19c - 13 - 3

Create Oracle Database 19c - 13 - 3

Create Oracle Database 19c - 14 - 1

Create Oracle Database 19c - 14 - 1

Create Oracle Database 19c - 14 - 2

Create Oracle Database 19c - 14 - 2

Create Oracle Database 19c - 14 - 3

Create Oracle Database 19c - 14 - 3

Create Oracle Database 19c - 14 - 4

Create Oracle Database 19c - 14 - 4

Create Oracle Database 19c - 14 - 5

Create Oracle Database 19c - 14 - 5

Create Oracle Database 19c - 15

Create Oracle Database 19c - 15

Create Oracle Database 19c - 15 - 1

Create Oracle Database 19c - 15 - 1

Create Oracle Database 19c - 15 - 2

Create Oracle Database 19c - 15 - 2

Create Oracle Database 19c - 16

Create Oracle Database 19c - 16

We had better to restart both nodes to verify the success of installation.

Post RAC Installation Check

1. Check Cluster Resources

Let's see statuses of all cluster resources.

C:\Users\Administrator>crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               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
ora.proxy_advm
               OFFLINE OFFLINE      primary01                STABLE
               OFFLINE OFFLINE      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.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.orclcdb.db
      1        ONLINE  ONLINE       primary01                Open,HOME=C:\app\ora
                                                             cle\product\19.3.0\d
                                                             bhome_1,STABLE
      2        ONLINE  ONLINE       primary02                Open,HOME=C:\app\ora
                                                             cle\product\19.3.0\d
                                                             bhome_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
--------------------------------------------------------------------------------

As you can see, cluster resources including database are all online.

2. Check Database Status

Then we check the database.

C:\Users\Administrator>sqlplus / as sysdba
...
SQL> select name, open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
ORCLCDB   READ WRITE

3. Open the pluggable database.

Don't forget to specify INSTANCES=ALL to open it on all nodes.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB                        MOUNTED
SQL> alter pluggable database orclpdb open instances=all;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB                        READ WRITE NO

To open all PDB automatically whenever CDB is open, we save the configuration of all pluggable databases.

SQL> alter pluggable database all save state instances=all;

Pluggable database altered.

4. Check Listener

We switch the present directory to the binary of grid to check listener's status.

C:\Users\Administrator>cd C:\app\19.3.0\grid\bin

C:\app\19.3.0\grid\bin>lsnrctl status

LSNRCTL for 64-bit Windows: Version 19.0.0.0.0 - Production on 26-MAY-2022 14:18:45

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 19.0.0.0.0 - Production
Start Date                26-MAY-2022 14:01:37
Uptime                    0 days 0 hr. 17 min. 12 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\app\19.3.0\grid\network\admin\listener.ora
Listener Log File         C:\app\grid\diag\tnslsnr\PRIMARY01\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\LISTENERipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.11)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.111)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=PRIMARY01)(PORT=5500))(Security=(my_wallet_directory=C:\APP\ORACLE\admin\ORCLCDB\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+asm1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
  Instance "+asm1", status READY, has 1 handler(s) for this service...
Service "ORCLCDB" has 1 instance(s).
  Instance "orclcdb1", status READY, has 1 handler(s) for this service...
Service "ORCLCDBXDB" has 1 instance(s).
  Instance "orclcdb1", status READY, has 1 handler(s) for this service...
Service "d48ea9663a19427891aeab343d6148b2" has 1 instance(s).
  Instance "orclcdb1", status READY, has 1 handler(s) for this service...
Service "orclpdb" has 1 instance(s).
  Instance "orclcdb1", status READY, has 1 handler(s) for this service...
The command completed successfully

We're done.

Leave a Reply

Your email address will not be published.