Oracle 19C Non Container Database creation

 DB creation Methods:

1. GUI Mode
2. Silent Mode
3. Manual Database creation

Pre-requisites:
you have already installed the oracle 19c software
if you have seperate data directory you can create and change the owner and permission

login as root and Run the following command.

xhost +

check bash_profile or environment variable and run
su - oracle
vi .bash_profile

export TMP=/tmp
export TMPDIR=$TMP

export ORACLE_HOSTNAME=192.168.31.204
export ORACLE_UNQNAME=pearl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export ORA_INVENTORY=/u01/app/oraInventory
export ORACLE_SID=pearl
export DATA_DIR=/u02/oradata

export PATH=/usr/sbin:/usr/local/bin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

run the bash_profile and export the display variables
. .bash_profile

export DISPLAY=:0.0;

export DISPLAY=localhost:10.0

GUI Mode:

run the dbca

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Silent Mode:

run the bash_profile and export the display variables

. .bash_profile

export DISPLAY=:0.0;

export DISPLAY=localhost:10.0

Run the below Command:

dbca -silent -createDatabase                       \
-templateName General_Purpose.dbc                  \
-gdbname ${ORACLE_SID} -sid  ${ORACLE_SID}         \
-characterSet AL32UTF8                             \
-sysPassword enterDB#123                           \
-systemPassword enterDB#123                        \
-createAsContainerDatabase false                   \
-totalMemory 2000                                  \
-storageType FS                                    \
-datafileDestination /u01/${ORACLE_SID}            \
-emConfiguration NONE                              \
-ignorePreReqs -sampleSchema true

 

 Manual DB Creation:

step1. Create a Directories:

cd /u02
mkdir tada
cd tada
mkdir data redo control log arch diag

step2. Create the parameter file:

cd $ORACLE_HOME/dbs

vi inittada.ora

db_name=tada
memory_terget=500m (use SGA & PGA)
control_files='/u02/tada/control/control01.ctl',' u02/tada/control /control02.ctl'
diagnostic_dest='/u02/tada/diag'
compatible='12.2.0'

step3. create SQL Script for Database Creation:
cd $ORACLE_HOME/dbs

vi dbcreation.sql

create database tada
datafile '/u02/tada/data/system.dbf' size 300m autoextend on
sysaux datafile '/u02/tada/data/sysaux.dbf' size 300m autoextend on
default tablespace user_data datafile '/u02/tada/data/user01.dbf' size 500m
undo tablespace undotbs datafile '/u02/tada/data/undotbs.dbf' size 300m
logfile group 1 '/u02/tada/redo/redo1.log' size 100m,
group 2 '/u02/tada/redo/redo1.log' size 100m'

(OR)

create database tada
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
LOGFILE
GROUP 1 '/u02/tada/redo/redo1.log' SIZE 10M,
GROUP 2 '/u02/tada/redo/redo2.log' SIZE 10M,
DATAFILE '/u02/tada/data/system.dbf' size 300m autoextend on
sysaux datafile '/u02/tada/data/sysaux.dbf' size 300m autoextend on
default tablespace user_data datafile '/u02/tada/data/user01.dbf' size 500m
undo tablespace undotbs datafile '/u02/tada/data/undotbs.dbf' size 300m
CHARACTER SET AL32UTF8;

step4. Run the db creation sql file and needed files

su – oracle
. .bash_profile

sqlplus / as sysdba
startup nomount
@$ORACLE_HOME/dbs/dbcreation.sql    #run the db creation sql file
@$ORACLE_HOME/rdbms/admin/catalog.sql # create the data dictionary objects
@$ORACLE_HOME/rdbmsadmin/catproc.sql #create the packages, functions and procedures
set serveroutput off;
@$ORACLE_HOME/sqlplus/admin/pupbld.sql

step5. Restart the databse

Verify the Database

select name from v$database;
select name from v$controlfile;
select name from v$datafile;
select * from dual;
select sysdate from dual;

step6. Check the database files:

cd /u02/tada/data

Check system tablespace size:
SELECT file_name, bytes / 1024 / 1024 mb FROM dba_data_files WHERE tablespace_name = 'SYSTEM' ORDER BY  file_name;

If you need you can create a new tablespace:
create tablespace mytablespace datafile '/u02/tada/data/mytablespace.dbf' size 500M autoextend on next 250M maxsize 10G;