Databases Reference
In-Depth Information
This case shows how the DBCA creates a database in silent mode with clone template.
dbca -silent -createDatabase -cloneTemplate -responseFile <response file>
A database can also be removed using the batch mode:
dbca -silent -deleteDatabase -responseFile <response file>
DBCA response file example
In this example a minimum response file was edited to have a database created.
[GENERAL]
RESPONSEFILE_VERSION = "10.0.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "sigma"
SID = "sigma"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "oracle"
SYSTEMPASSWORD = "oracle"
CHARACTERSET = "WE8ISO8859P1"
NATIONALCHARACTERSET= "UTF8"
MEMORYPERCENTAGE = "12"
This example creates a database named sigma whose global name and instance
name are the same. This database is based on a predefined template used to
create a General Purpose database. In this example only the SYSPASSWORD and
SYSTEMPASSWORD parameters have been defined as no Enterprise Manager DB
Control Console configuration has been requested. This can either be configured here
or it can be configured using the emca command (The emca command offers a more
flexible way to configure the Enterprise Manager interface).
The Template name is the name of the *.dbc file, not the name
displayed in the DBCA template list. If this parameter is not properly
configured, then an error message will be displayed letting the user
know that the template doesn't exist.
A percentage of the physical memory is defined for this instance, it is important to
define this value; otherwise DBCA will take 40% by default.
And finally, the database character set and the national character set are defined.
 
Search WWH ::




Custom Search