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 - Production on Wed Jul 28 21:40:23 2021

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

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

SQL> select name,open_mode from v$database;

--------- --------------------

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s