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. 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.