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

Leave a Reply

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

WordPress.com Logo

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

Google photo

You are commenting using your Google 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