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

Oracle 12cR2 Silent Install

 Oracle 12cR2 Silent Install

silent install is much faster and cuts down time

What actually makes it faster 🚀

1️⃣ No GUI = no waiting

• No OUI screens

• No mouse clicks

• No UI rendering delays

👉 Installer runs directly in background, faster on:

• Servers

• VMs

• Cloud instances

Create response file under /tmp with bellow details:

oracle#vi /tmp/12c_response.rs

oracle.install.responseFileVersion=

/oracle/install/rspfmt_dbinstall_response_schema_v12.2.0
oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=prm

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/u01/app/oraInventory

SELECTED_LANGUAGES=en

ORACLE_HOME=/u01/app/oracle/product/12.2.0.1

ORACLE_BASE=/u01/app/oracle

oracle.install.db.InstallEdition=EE

oracle.install.db.OSDBA_GROUP=dba

oracle.install.db.OSOPER_GROUP=dba

oracle.install.db.OSBACKUPDBA_GROUP=dba

oracle.install.db.OSDGDBA_GROUP=dba

oracle.install.db.OSKMDBA_GROUP=dba

oracle.install.db.OSRACDBA_GROUP=dba

SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

DECLINE_SECURITY_UPDATES=true

oracle.installer.autoupdates.option=SKIP_UPDATES




Start the run installer in silent mode to begin the installation

cd /u02/database

runInstaller

run runInstaller in Silent mode

./runInstaller -ignoreSysPrereqs -showProgress -silent -responseFile /tmp/12c_response.rsp

Once installation is completed, run the root scripts and you can move to DBCA create database.

Oracle 12c GUI Install

Start the runInstaller and follow the below screens to install Oracle 12cR2 software

cd /u01/database
./runinstaller

Uncheck to disable receiving security updates and click on next. You will get a warning, just click OK to proceed