Wednesday, March 11, 2015

Using dbca to setup Oracle 12c CDB & PDB via a silent response file



One of the key new features for Oracle 12c are the new Container Database (CDB) to a Pluggable Database (PDB).Naturally these are a big part of the OCP exam (IZO-060).

I have started investigating this new feature by setting up a dbca response file:

[oracle@ora12c66 ~]$ cat /vagrant/dbca_cdb_pdb.rsp
[GENERAL]
RESPONSEFILE_VERSION=12.1.0
[CREATEDATABASE]
OPERATION_TYPE=createDatabase
createAsContainerDatabase=true
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "qwe123"
SYSTEMPASSWORD = "qwe123"
SYSMANPASSWORD = "qwe123"
DBSNMPPASSWORD = "qwe123"
pdbAdminPassword = "qwe123"
CHARACTERSET = "UTF8"
NATIONALCHARACTERSET= "UTF8"
createAsContainerDatabase="true"
pdbName="pdb1"
numberOfPDBs="1"
sid="cdborcl"
gdbName="cdborcl"
emConfiguration="DBEXPRESS"
storageType="FS"
datafileDestination="/u01/oradata"

and running dbca


[oracle@ora12c66 ~]$ dbca -silent -createDatabase -responseFile  /vagrant/dbca_cdb_pdb.rsp
Enter PDBADMIN User Password:

Copying database files
1% complete
2% complete
8% complete
13% complete
19% complete
24% complete
27% complete
Creating and starting Oracle instance
29% complete
32% complete
33% complete
34% complete
38% complete
42% complete
43% complete
45% complete
Completing Database Creation
48% complete
51% complete
53% complete
62% complete
64% complete
72% complete
Creating Pluggable Databases
78% complete
100% complete
Look at the log file "/u01/cfgtoollogs/dbca/cdborcl/cdborcl.log" for further details.


as above, this worked as expected, excepted I had to enter the pdbAdminPassword password above? This looks a bit like the currently unanswered question (ie "but it must manuallly input PDBADMIN password") in:



Lastly, for the record here is my install log:

[oracle@ora12c66 ~]$ cat /u01/cfgtoollogs/dbca/cdborcl/cdborcl.log

Unique database identifier check passed.

/ has enough space. Required space is 8260 MB , available space is 29709 MB.
File Validations Successful.
Copying database files
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 2%
DBCA_PROGRESS : 8%
DBCA_PROGRESS : 13%
DBCA_PROGRESS : 19%
DBCA_PROGRESS : 24%
DBCA_PROGRESS : 27%
Creating and starting Oracle instance
DBCA_PROGRESS : 29%
DBCA_PROGRESS : 32%
DBCA_PROGRESS : 33%
DBCA_PROGRESS : 34%
DBCA_PROGRESS : 38%
DBCA_PROGRESS : 42%
DBCA_PROGRESS : 43%
DBCA_PROGRESS : 45%
Completing Database Creation
DBCA_PROGRESS : 48%
DBCA_PROGRESS : 51%
DBCA_PROGRESS : 53%
DBCA_PROGRESS : 62%
DBCA_PROGRESS : 64%
DBCA_PROGRESS : 72%
Creating Pluggable Databases
DBCA_PROGRESS : 78%
DBCA_PROGRESS : 100%
Database creation complete. For details check the logfiles at:
/u01/cfgtoollogs/dbca/cdborcl.
Database Information:
Global Database Name:cdborcl
System Identifier(SID):cdborcl

No comments:

Post a Comment