Creating Oracle Multitenant Databases - OCP: Oracle Database 12c Administrator Certified Professional - page 513

e xe RCiSe 11.1
Creating a New CDB Using SQl*Plus
In this exercise you will create a new CDB on a Windows 7 server, using Oracle Managed
Files. This is meant to be a simplified example and does not include all available parameters
and features. We will follow the basic steps outlined in the Database Administrators Guide:
1. Specify an instance identifier (SID) unique to this server and database domain.
C:\ set ORACLE_SID=NDLNE
2. Set the required environment variables. ORACLE_HOME is required on some operating
systems.
C:\ set ORACLE_HOME=C:\Oracle\product\12.1.0\dbhome_2
3. Determine the database administrator authentication method. By default, in the
Windows OS the user who installed the Oracle RDBMS software is automatically
added to the Administrators group, so no additional steps are necessary.
4. Create the initialization parameter file ( init.ora ) and database directory folders. In
the admin\<ORACLE_SID>\pfile directory for the new database, create the init.ora
file: Here's an example of an Oracle-supplied init.ora file:
##############################################################################
# Copyright (c) 1991, 2013 by Oracle Corporation
##############################################################################
###########################################
# Cache and I/O
###########################################
db_block_size=8192
###########################################
# Cursors and Library Cache
###########################################
open_cursors=300
###########################################
# Database Identification
###########################################
db_domain=""
db_name="NDLNE"