Description:-
In this is the article we are going to see Step by Step Creating Oracle 19c Rac Database
Demo:-
Step:-1 Double Check from ASMCMD Tool
[oracle@rac1 grid]$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 40956 40824 0 40824 0 N DATA/
MOUNTED EXTERN N 512 512 4096 4194304 12284 11948 0 11948 0 Y OCR_VOTING/
Step:-2 Check Asm diskgroup created and sufficient space Through ASMCA Tool
Node 1
[oracle@rac1 ~]$ cat .db.env
export ORACLE_SID=oradbwr1
export ORACLE_HOME=$DB_HOME
export PATH=$ORACLE_HOME/bin:$BASE_PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
Node 2
[oracle@rac2 ~]$ cat .db.env
export ORACLE_SID=oradbwr2
export ORACLE_HOME=$DB_HOME
export PATH=$ORACLE_HOME/bin:$BASE_PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
Step:-3 Select Create database
Step:- 4 Click Advanced configuration
Step:-5 Check Database type and General purpose
Step:-6 Check both nodes are selected
Step:-7 Enter database name
Step:-8 Check database file location
Step:-9 Deselect FRA and archivelog
Step:-10 Leave as it is
Step:- 11 Select ASMM
Step:- 12 Enter Password
Step:-13 select create database
Step:-14 Double check and click finish
Step:-15 Oracle 19c rac database creation is completed
Step:-16 Check database status
[oracle@rac1 ~]$ . .db.env
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Wed Dec 25 16:15:18 2019
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> select name,host_name,instance_name from gv$database,GV$instance;
NAME HOST_NAME INSTANCE_NAME
——— —————————— —————-
ORADBWR rac1.localdomain.com oradbwr1
ORADBWR rac1.localdomain.com oradbwr1
ORADBWR rac2.localdomain.com oradbwr2
ORADBWR rac2.localdomain.com oradbwr2
Connect with me:-
Telegram App:https://t.me/oracledbwr
LinkedIn:https://www.linkedin.com/in/hariprasathdba
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page : https://www.facebook.com/dbahariprasath/?
Twitter : https://twitter.com/oracledbwr