After Oracle database 19c software has been installed, we can now create a RAC database by Database Configuration Assistant (DBCA).
[oracle@primary01 ~]$ dbca
We would like to use a Container Database (CDB) to host our PDB.
In this case, the CDB is ORCLCDB, the PDB is ORCLPDB. Don't forget about the template of PDB is PDB$SEED.
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.
I made an animated image for showing all initialization parameters including advanced ones. It will rotate next image in two seconds.
For static images, please refer to the post: Complete Initialization Parameters List in DBCA 19c.
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
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:
- Database Connection
- Oracle Enterprise Manager Database Express
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.
I think you may counter some problems when first logon the utility.