DBCA SILENT MODE INSTALLATION of 19C DB



CREATE NON-CONTAINER DATABASE ON ORACLE 19C IN SILENT MODE USING DBCA

Step 1: Set the Environment
	[oracle@tesdb dbhome_1]$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
	[oracle@tesdb dbhome_1]$ export PATH=$ORACLE_HOME/bin:$PATH
	[oracle@tesdb dbhome_1]$ which dbca
	/u01/app/oracle/product/19.0.0/dbhome_1/bin/dbca
Step 2: Create Database using DBCA silent mode 
	[oracle@tesdb dbhome_1]$ dbca -silent -createDatabase -templateName
	General_Purpose.dbc -gdbName tesdb -sid TESDB
	-sysPassword sys -systemPassword sys -emConfiguration NONE
	-datafileDestination /u01/app/oracle/oradata -storageType FS
	-characterSet AL32UTF8
OUTPUT:
[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.

CAUSE:
  1. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
  2. The password entered is a keyword that Oracle does not recommend to be used as password
ACTION:

Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.

CAUSE:
  1. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
  2. The password entered is a keyword that Oracle does not recommend to be used as password
ACTION:

Specify a strong password. If required refer Oracle documentation for guidelines. 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/tesdb.

Database Information:
Global Database Name:tesdb
System Identifier(SID):TESDB
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/tesdb/tesdb.log" for further details.

Step 3: Check db up or not 
	[oracle@tesdb dbhome_1]$   cat /etc/oratab | grep -i  TESDB

	TESDB:/u01/app/oracle/product/19.0.0/dbhome_1:N
	[oracle@tesdb dbhome_1]$ ps -ef | grep pmon
	oracle   10766     1  0 22:13 ?        00:00:00 ora_pmon_TESDB
	oracle   11226  6531  0 22:15 pts/0    00:00:00 grep --color=auto pmon

	[oracle@tesdb dbhome_1]$  . oraenv

	ORACLE_SID = [cdb1] ?
	ORACLE_HOME = [/home/oracle] ?
	ORACLE_BASE environment variable is not being set since this

	information is not available for the current user ID oracle.
	You can set ORACLE_BASE manually if it is required.

	Resetting ORACLE_BASE to its previous value or ORACLE_HOME
	The Oracle base remains unchanged with value /u01/app/oracle
	[oracle@tesdb dbhome_1]$  . oraenv

	ORACLE_SID = [cdb1] ? TESDB
	The Oracle base remains unchanged with value /u01/app/oracle

	[oracle@tesdb dbhome_1]$  . oraenv
	ORACLE_SID = [TESDB] ?

	The Oracle base remains unchanged with value /u01/app/oracle
	[oracle@tesdb dbhome_1]$ sqlplus / as sysdba

	SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 12 22:16:53 2023
	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
	--------- -------------------- ---
	TESDB	  READ WRITE	       NO

	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> select name from v$datafile;
	NAME
	------------------------------------------------
	/u01/app/oracle/oradata/TESDB/system01.dbf
	/u01/app/oracle/oradata/TESDB/sysaux01.dbf
	/u01/app/oracle/oradata/TESDB/undotbs01.dbf
	/u01/app/oracle/oradata/TESDB/users01.dbf

	SQL>