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

Logical Standby in Oracle Data Guard Overview

  In Oracle Data Guard , a Logical Standby Database is a standby database that: Receives redo data from the Primary database Convert...