Creating Non CDB database in silent mode – ORACLE 19C

In this example, we are using oracle 19c and going to learn how to Creating Non-CDB database in silent mode. As you know, we can also create a database using the DBCA utility but in some cases, we don't have access to the GUI. So here we will learn silent mode database creation step by step.

How to Create Pluggable Database Oracle

Creating Non-CDB database in silent mode

Step 1. Set the environment variables.

$ export ORACLE_SID =ORCLDB19C
$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
$ export PATH=$ORACLE_HOME/bin:$PATH

Check the current dbca environment using the below command.

$ which dbca
/u01/app/oracle/product/19.0.0/dbhome_1/bin/dbca

Create a new directory for the new database.

$ mkdir -p /u01/app/oracle/oradata/ORCLDB19C

Step 2. Create non cdb database in silent mode using the below dbca command.

$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName ORCLDB19C -sid ORCLDB19C -sysPassword Oracle$123 -systemPassword Oracle$123 -emConfiguration NONE -datafileDestination /u01/app/oracle/oradata -storageType FS -characterSet AL32UTF8

Output from the above query:

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/ORCLDB19C.
Database Information:
Global Database Name:ORCLDB19C
System Identifier(SID):ORCLDB19C
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ORCLDB19C/ORCLDB19C.log" for further details.

Once the database is successfully created, login in the database and check the details.

$ sqlplus sys@ORCLDB19C AS SYSDBA

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

SYSDATE
--------------------
24-APR-2020 19:10:23

Check the Listener and tns details also.

$ lsnrctl status LISTENER | grep -i ORCLDB19C
$ tnsping ORCLDB19C

I hope you found this article very useful, please write your fillings in the comment box.