How To Use The Database Configuration Assistant (Dbca) To Create Database In Oracle 19c
Description:-
In this article we are going t0 create a oracle 19c database using the DBCA tool.
In Oracle, typically you create a database when you install the software. However if you either skipped the database creation part during installation or if you want to create one more database on the same host, then there are two ways of doing this.
1)Database Configuration Assistant (DBCA) graphical tool.
2)CREATE DATABASE SQL statement (Manual Method)
DBCA (database configuration assistant) is a utility provided by oracle to create and configure a database.
Log in as the Oracle software owner.
Go to a command prompt.
Type dbca.
Step1:-Create Database(Database Creation)
Step2:-Select the Advanced option.(Creation Mode)
Click Next.
Step3:-We will see output. Optional database templates are shown below:(Database Type)
General Purpose
Data Warehouse
Custom Database
Click Next.
Step4:-A screen asks you to choose the database name. (Database Identification)
Fill in these fields:
Global Database Name:
SID
Create as container database
Select PDBName
Step5:- Select Database Storage Option
Step6:- Fast Recovery Option.
Step7:-Network Configuration
Step8:- Data Vault
Step9:- Configuration Option
Step10:-Management Option
Step11:- Database User Credentials
Step12:- Database Creation Option
Step13:- Summary
Step14:-Progress Page
Step15:-Database creation is completed
Step16:-Database Ready For Use
[oracle@dev19c ~]$ export ORACLE_SID=orcldb [oracle@dev19c ~]$ sqlplus '/as sysdba' SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 13 19:49:14 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 instance_name from v$instance; INSTANCE_NAME ---------------- orcldb
Catch Me On:- Hariprasath Rajaram
Telegram App: https://t.me/joinchat/I_f4DkeGfZvN1z5wyt_f4w
LinkedIn:https://www.linkedin.com/in/hari-prasath-a65bb19/
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/hariprasathdba
