Thursday, January 22, 2026

DBCA silent mode 12C

 


Create Database using DBCA silent mode

on primary

==========

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName test -sid test -createAsContainerDatabase false -emConfiguration NONE -datafileDestination /u01/data/db_files  -storageType FS -characterSet AL32UTF8 -totalMemory 1500 -recoveryAreaDestination /u01/app/oracle/FRA


Enter SYS user password:  EnterCDB#123

Enter SYSTEM user password:  EnterCDB#123

keep both same


Verify

[oracle@prm ~]$ cat /etc/oratab | grep -i test
ps -ef | grep pmon
sqlplus / as sysdba
SQL> select name,open_mode,cdb from v$database;

NAME      OPEN_MODE            CDB
--------- -------------------- ---
test   READ WRITE           NO <------ NON-CDB

SQL> show con_name

CON_NAME
------------------------------
test
SQL> archive log list

No comments:

Post a Comment

Please do not enter any spam link in the comments

Install Oracle Database 21C and Create a Database on Oracle Linux 7

 This guide provides a practical, step-by-step procedure for installing Oracle Database 21c and creating a database on an Oracle Linux 7 x8...