Silent installation of database in 12C

----open folder where you unzip the database software


[oracle@cdb1 ~]$ cd /u01/app/database/
[oracle@cdb1 database]$ ls -ltr
total 36
-rwxr-xr-x.  1 oracle oinstall  500 Feb  7  2013 welcome.html
-rwxr-xr-x.  1 oracle oinstall 8533 Jul  7  2014 runInstaller
drwxr-xr-x.  2 oracle oinstall 4096 Jul  7  2014 rpm
drwxrwxr-x.  2 oracle oinstall 4096 Jul  7  2014 sshsetup
drwxr-xr-x. 14 oracle oinstall 4096 Jul  7  2014 stage
drwxr-xr-x.  4 oracle oinstall 4096 Jul 24 04:20 install
drwxrwxr-x.  2 oracle oinstall 4096 Jul 25 05:48 response

[oracle@cdb1 database]$cd response

[oracle@cdb1 response]$ ls -ltr
total 216
-rwxrwxr-x. 1 oracle oinstall  6038 Jan 24  2014 netca.rsp
-rw-r--r--. 1 oracle oinstall 25036 Jul 24 04:30 RM.rsp
-rw-rw-r--. 1 oracle oinstall 25233 Jul 24 06:09 db_install.rsp
-rwxr-xr-x. 1 oracle oinstall 74822 Jul 25 05:03 rmdbcarsp
-rwxrwxr-x. 1 oracle oinstall 74797 Jul 25 05:48 dbca.rsp

-----for safety make one duplicate copy of original file.

[oracle@cdb1 response]$ cp dbca.rsp rmdbca.rsp
[oracle@cdb1 response]$ ls -ltr
total 292
-rwxrwxr-x. 1 oracle oinstall  6038 Jan 24  2014 netca.rsp
-rw-r--r--. 1 oracle oinstall 25036 Jul 24 04:30 RM.rsp
-rw-rw-r--. 1 oracle oinstall 25233 Jul 24 06:09 db_install.rsp
-rwxr-xr-x. 1 oracle oinstall 74822 Jul 25 05:03 rmdbcarsp
-rwxrwxr-x. 1 oracle oinstall 74797 Jul 25 05:48 dbca.rsp
-rwxr-xr-x. 1 oracle oinstall 74797 Jul 25 06:14 rmdbca.rsp

[oracle@cdb1 response]$

-------edite dbca.rsp file

[oracle@cdb1 response]$ vi dbca.rsp

---------change below parameter in dbca file

RESPONSEFILE_VERSION = "12.1.0"
OPERATION_TYPE = "createDatabase"
GDBNAME = orcl
SID = orcl
CREATEASCONTAINERDATABASE =true
PDBNAME =pdb1
PDBADMINPASSWORD = "Admin"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "Admin"
SYSTEMPASSWORD = "Admin"
SOURCEDB = "orcl.example.com:1521:orcl"
SYSDBAUSERNAME = "sys"
TEMPLATENAME = "My Copy TEMPLATE"

Note:- comment all other unnecessary parameter


[oracle@cdb1 response]$ dbca -silent -responseFile dbca.rsp
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
46% complete
47% complete
52% complete
57% complete
58% complete
59% complete
62% complete
Completing Database Creation
66% complete
70% complete
74% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.

[oracle@cdb1 response]$

[oracle@cdb1 response]$ cat /etc/oratab | grep orcl

orcl:/u01/app/oracle/product/12.1.0.2/db_1:N

[oracle@cdb1 response]$ sqlplus

SQL*Plus: Release 12.1.0.2.0 Production on Sat Jul 25 06:03:01 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Enter user-name: /as sysdba

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
orcl

SQL> SELECT name, open_mode
FROM   v$pdbs
ORDER BY name;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY

SQL> CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb_adm IDENTIFIED BY Admin
  FILE_NAME_CONVERT=('/u01/app/oracle/oradata/orcl/pdbseed','/u01/app/oracle/oradata/orcl/pdb1/');  2

Pluggable database created.

SQL> COLUMN pdb_name FORMAT A20
SQL> SELECT pdb_name, status
FROM   dba_pdbs
ORDER BY pdb_name;

PDB_NAME             STATUS
-------------------- ---------
PDB$SEED             NORMAL
PDB1                       NEW

SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN READ WRITE;

Pluggable database altered.

SQL> SELECT name, open_mode
FROM   v$pdbs
ORDER BY name;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
PDB1                           READ WRITE

SQL>

                          ----------------END-------------------------