Steps to create Database for 19c Rac ~ Blog for oracle RAC Goldengate Dataguard ASM database

Hello Friend's,

In This post we will discuss how to install oracle database for 19c Database Rac setup

Step 1: Login to Oracle user move to database home directory $ORACLE_HOME/bin and run the dbca command on os prompt

Step 2 : Select the option create database and click next.

Step 3 : Click on Advance configuration tab and click next

Step 4 : Select general purpose or data warehouse as per the need of env .

we will select general purpose OLTP

Step 5 : Select all and click next

Step 6 : Provide the database and pdb database name ,In our case its CDBBCRM

Step 7 : For ASM select the 2nd option

Step 8 : Enable Archiving and change the archive extension from dbf to arc

Step 9 : We are not creating any vault so leave it blank.

Step 10 : Provide the value for memory target ,

we can change the sizing process value and character set from the tabs available

character set ask for the character set before installation is there any special need to default can be used

Step 11 : we are not configuring EM for this so choose option 1 and click next

Step 12 : Provide the password and click next

Step 13 : check the box create database and click next

Step 14 : check the summary page if all things are ok click on finish button

Step 15 : Database installation completes here click on close and login to sqlplus and check the database.


[oracle@dm19nd01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jun 27 10:07:46 2020
Version 19.3.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> set pages 9999 lines 300
col OPEN_MODE for a10
col HOST_NAME for a30
select INST_ID,INSTANCE_NAME, name DB_NAME,HOST_NAME,DATABASE_ROLE,LOG_MODE,OPEN_MODE,version DB_VERSION,LOGINS,to_char(STARTUP_TIME,'DD-MON-YYYY HH24:MI:SS') "DB UP TIME" from v$database,gv$instance;
SQL> SQL> SQL>
   INST_ID INSTANCE_NAME    DB_NAME   HOST_NAME                      DATABASE_ROLE    LOG_MODE     OPEN_MODE  DB_VERSION        LOGINS     DB UP TIME
---------- ---------------- --------- ------------------------------ ---------------- ------------ ---------- ----------------- ---------- -----------------------------
         1 CDBBCRM1         CDBBCRM   dm19nd01.database.com          PRIMARY          ARCHIVELOG   READ WRITE 19.0.0.0.0        ALLOWED    27-JUN-2020 10:05:12
         2 CDBBCRM2         CDBBCRM   dm01nd02.database.com          PRIMARY          ARCHIVELOG   READ WRITE 19.0.0.0.0        ALLOWED    27-JUN-2020 09:21:46

Steps to create Database for 19c Rac

Related Post