Usually to create database we will use DBCA graphical user interface.

Some times may not have access to a graphical user interface then we can use the DBCA silent mode to create a database.

We are going to create NON-CONTAINER database as COKE 

Database Binary Version: 19.3.0.0.0
OS                     : Linux x86_64

[oracle@rac1 ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
[oracle@rac1 ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@rac1 ~]$ which dbca
/u01/app/oracle/product/19.0.0/dbhome_1/bin/dbca
[oracle@rac1 ~]$ dbca 

-- No need to create directory COKE, it will create automatically by dbca

[oracle@rac1 ~]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName COKE.rajasekhar.com -sid COKE -sysPassword Coke123$ -systemPassword Coke@123 -emConfiguration NONE -datafileDestination /u01/app/oracle/oradata -storageType FS -characterSet AL32UTF8
Prepare for db operation
10% complete
Copying database files
40% complete
Creating and starting Oracle instance
42% complete
46% complete
50% complete
54% complete
60% complete
Completing Database Creation
66% complete
69% complete
70% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /u01/app/oracle/cfgtoollogs/dbca/COKE.
Database Information:
Global Database Name:COKE.rajasekhar.com
System Identifier(SID):COKE
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/COKE/COKE.log" for further details.
[oracle@rac1 ~]$

[oracle@rac1 ~]$ cat /etc/oratab | grep -i COKE
COKE:/u01/app/oracle/product/19.0.0/dbhome_1:N
[oracle@rac1 ~]$

[oracle@rac1 ~]$ ps -ef | grep pmon
oracle    4273     1  0 19:53 ?        00:00:00 ora_pmon_COKE
oracle    5240  2552  0 19:56 pts/0    00:00:00 grep --color=auto pmon
[oracle@rac1 ~]$

[oracle@rac1 ~]$ . oraenv
ORACLE_SID = [dell] ? COKE
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jan 26 19:57:31 2020
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,cdb from v$database;

NAME      OPEN_MODE            CDB
--------- -------------------- ---
COKE      READ WRITE           NO <----

SQL>

SQL> show con_name

CON_NAME
------------------------------
COKE
SQL>
SQL> archive log list
Database log mode              No Archive Mode <----
Automatic archival             Disabled
Archive destination            /u01/app/oracle/product/19.0.0/dbhome_1/dbs/arch
Oldest online log sequence     3
Current log sequence           5
SQL>
SQL> select name from v$datafile
UNION
select name from v$tempfile; 

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/COKE/sysaux01.dbf
/u01/app/oracle/oradata/COKE/system01.dbf
/u01/app/oracle/oradata/COKE/temp01.dbf
/u01/app/oracle/oradata/COKE/undotbs01.dbf
/u01/app/oracle/oradata/COKE/users01.dbf

SQL> 

listener.ora

LISTENER_COKE =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = rac1.rajasekhar.com)(PORT = 1523))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1523))
    )
  )

SID_LIST_LISTENER_COKE =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = COKE.rajasekhar.com)
      (ORACLE_HOME = /u01/app/oracle/product/19.0.0/dbhome_1)
      (SID_NAME = COKE)
    )
  )

  
tnsnames.ora
 
COKE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac1.rajasekhar.com)(PORT = 1523))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = COKE.rajasekhar.com)
    )
  )


[oracle@rac1 admin]$ tnsping COKE

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 26-JAN-2020 20:07:59

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

Used parameter files:
/u01/app/oracle/product/19.0.0/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1.rajasekhar.com)(PORT = 1523)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = COKE.rajasekhar.com)))
OK (10 msec)
[oracle@rac1 admin]$

[oracle@rac1 admin]$ lsnrctl status LISTENER_COKE

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 26-JAN-2020 20:09:54

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1.rajasekhar.com)(PORT=1523)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_COKE
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                26-JAN-2020 20:03:42
Uptime                    0 days 0 hr. 6 min. 12 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/rac1/listener_coke/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac1.rajasekhar.com)(PORT=1523)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1523)))
Services Summary...
Service "COKE.rajasekhar.com" has 1 instance(s).
  Instance "COKE", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@rac1 admin]$

[oracle@rac1 ~]$ sqlplus sys@coke as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jan 26 20:15:24 2020
Version 19.3.0.0.0

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

Enter password:

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

SQL> select to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') "SYSDATE" FROM DUAL;

SYSDATE
-----------------------------
26-JAN-2020 20:15:45

SQL>