We click on Database Configuration Assistant (DBCA) in the menu to initiate the database creation process.
Start Menu - Database Configuration Assistant (DBCA)
Create Oracle Database 19c - 1
Create Oracle Database 19c - 2
Create Oracle Database 19c - 3
Create Oracle Database 19c - 4
Create Oracle Database 19c - 5
Create Oracle Database 19c - 6
Create Oracle Database 19c - 6 - 1
Create Oracle Database 19c - 7
Create Oracle Database 19c - 8
Create Oracle Database 19c - 9 -1
Create Oracle Database 19c - 9 -2
Create Oracle Database 19c - 9 -3
Create Oracle Database 19c - 9 -4
Create Oracle Database 19c - 9 -6
Create Oracle Database 19c - 10
Create Oracle Database 19c - 11
Create Oracle Database 19c - 11 - 1
Create Oracle Database 19c - 12
Create Oracle Database 19c - 12 - 1
Create Oracle Database 19c - 12 - 2
Create Oracle Database 19c - 12 - 3
Create Oracle Database 19c - 12 - 4
Create Oracle Database 19c - 12 - 5
Create Oracle Database 19c - 13 - 1
Create Oracle Database 19c - 13 - 2
Create Oracle Database 19c - 13 - 3
Create Oracle Database 19c - 14 - 1
Create Oracle Database 19c - 14 - 2
Create Oracle Database 19c - 14 - 3
Create Oracle Database 19c - 14 - 4
Create Oracle Database 19c - 14 - 5
Create Oracle Database 19c - 15
Create Oracle Database 19c - 15 - 1
Create Oracle Database 19c - 15 - 2
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 WRITE3. 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 SQL> alter pluggable database all save state instances=all;
Pluggable database altered. We save current status for opening all PDB automatically in the future.
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.