CREATE ORACLE 19C DATABASE
19C oracle has lots of enhancements compared to previous versions like automatic index,automatic SQL plan management,real time statistics,automatic dataguard dml redirection,autoupgrade…….
Invoke DBCA from the oracle 19c software path
[oracle@orcl19x oradata]$ cd /data01/product/19.0.0/bin/
[oracle@orcl19x bin]$ ./dbca
Choose create database and next
Click advanced configuration
Leave defaults and click next
Give oracle sid name and choose pdbs if container databases required or else uncheck the checkbox ‘Create as Container database’
Browse datafile directory on filesystem
Browse FRA location and specify the size. Note that specifying less size
Create a new listener or if one exists choose it
Choose AMM
Give number of processes parameter
Choose the character set as ‘al32utf8’. In earlier releases before 19c, default character set might be different. But always ‘al32utf8’ supports all characters and is the recommended one
Configure OEM with port
Set passwords for sys and system accounts
Click yes
Click next leaving defaults
Validate summary of pre installation
Wait for the progress
After completion, you are good to go
Go to putty and check database status
[oracle@orcl19x ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jul 28 21:40:23 2021
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,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
ORCL19X1 READ WRITE