create non-cdb (traditional) oracle database 12c on windows
DESCRIPTION
Create a non-CDB Oracle database 12c on Windows using DBCA.TRANSCRIPT
![Page 1: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/1.jpg)
Create Non-CDB Oracle Database 12c on Windows
Oracle documentation to create a database…
http://docs.oracle.com/cd/E16655_01/server.121/e17643/install.htm#CHDGJGHB
Invoke DBCA: Click Start, select All Programs, then Oracle – OraDB12Home1, then Configuration and
Migration Tools, and then Database Configuration Assistant.
Click Yes.
![Page 2: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/2.jpg)
Click Next.
Click Help button in any screen to get context sensitive help. Few of the help screens are shown here.
![Page 3: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/3.jpg)
![Page 4: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/4.jpg)
Choosing the “Default Configuration” is easy and quick way to create a database. To install Container
Database, the “Create as Container Database” checkbox must be checked.
![Page 5: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/5.jpg)
![Page 6: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/6.jpg)
Create Database - Summary
Database Configuration Summary
Global Database Name: o12c01
Database Configuration Type: Single Instance
SID: o12c01
Create As Container Database No
Storage Type: File System
Memory Configuration Type: Automatic Shared Memory Management
Template Name: General Purpose or Transaction Processing
Database Configuration Details
Database Components
Component Selected
Oracle JVM true
![Page 7: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/7.jpg)
Oracle Text true
Oracle Multimedia true
Oracle OLAP true
Oracle Spatial true
Oracle Label Security true
Sample Schemas false
Oracle Application Express true
Oracle Database Vault true
Oracle Database Extensions for .NET true
Initialization Parameters
Name Value
audit_file_dest {ORACLE_BASE}\admin\{DB_UNIQUE_NAME}\adump
audit_trail db
compatible 12.1.0.0.0
db_block_size 8KB
db_create_file_dest {ORACLE_BASE}\oradata
db_domain
db_name o12c01
db_recovery_file_dest {ORACLE_BASE}\fast_recovery_area
db_recovery_file_dest_size 6930MB
diagnostic_dest {ORACLE_BASE}
dispatchers (PROTOCOL=TCP) (SERVICE={SID}XDB)
open_cursors 300
pga_aggregate_target 806MB
processes 300
remote_login_passwordfile EXCLUSIVE
sga_target 2419MB
undo_tablespace UNDOTBS1
Character Sets
Name Value
Database Character Set AL32UTF8
National Character Set AL16UTF16
Data Files
Name Tablespace Size(M)
![Page 8: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/8.jpg)
<OMF_SYSTEM _DATAFILE> SYSTEM 770
<OMF_SYSAUX _DATAFILE> SYSAUX 660
<OMF_UNDOTBS1 _DATAFILE> UNDOTBS1 725
<OMF_USERS _DATAFILE> USERS 5
<OMF_TEMP _TEMPFILE> TEMP 64
Redo Log Groups
Group Size(K)
1 51200
2 51200
3 51200
Let’s change to “Advanced Mode” and see the difference in DB Creation screens… In this demo, I am not
changing any defaults, but screens are to show you the options available.
![Page 9: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/9.jpg)
Click show details to see what products are installed in the pre-configured database…
![Page 10: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/10.jpg)
![Page 11: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/11.jpg)
![Page 12: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/12.jpg)
![Page 13: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/13.jpg)
![Page 14: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/14.jpg)
![Page 15: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/15.jpg)
![Page 16: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/16.jpg)
![Page 17: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/17.jpg)
![Page 18: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/18.jpg)
![Page 19: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/19.jpg)
![Page 20: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/20.jpg)
Check the “Sample Schemas” checkbox. This will install the HR and other sample schemas and tables
with data to practice SQL.
![Page 21: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/21.jpg)
![Page 22: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/22.jpg)
![Page 23: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/23.jpg)
![Page 24: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/24.jpg)
![Page 25: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/25.jpg)
![Page 26: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/26.jpg)
![Page 27: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/27.jpg)
![Page 28: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/28.jpg)
Create Database - Summary
Database Configuration Summary
Global Database Name: o12c01
Database Configuration Type: Single Instance
SID: o12c01
Create As Container Database No
Storage Type: File System
Memory Configuration Type: Automatic Shared Memory Management
Template Name: General Purpose or Transaction Processing
Database Configuration Details
Database Components
Component Selected
Oracle JVM true
![Page 29: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/29.jpg)
Oracle Text true
Oracle Multimedia true
Oracle OLAP true
Oracle Spatial true
Oracle Label Security true
Sample Schemas true
Oracle Application Express true
Oracle Database Vault true
Oracle Database Extensions for .NET true
Initialization Parameters
Name Value
audit_file_dest {ORACLE_BASE}\admin\{DB_UNIQUE_NAME}\adump
audit_trail db
compatible 12.1.0.0.0
control_files ("{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\control01.ctl",
"{ORACLE_BASE}\fast_recovery_area\{DB_UNIQUE_NAME}\control02.ctl")
db_block_size 8KB
db_domain
db_name o12c01
db_recovery_file_dest {ORACLE_BASE}\fast_recovery_area
db_recovery_file_dest_size
6930MB
diagnostic_dest {ORACLE_BASE}
dispatchers (PROTOCOL=TCP) (SERVICE={SID}XDB)
open_cursors 300
pga_aggregate_target 728MB
processes 300
remote_login_passwordfile EXCLUSIVE
sga_target 2048MB
undo_tablespace UNDOTBS1
Character Sets
Name Value
Database Character Set AL32UTF8
National Character Set AL16UTF16
Data Files
![Page 30: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/30.jpg)
Name Tablespace Size(M)
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\SYSTEM01.DBF SYSTEM 770
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\SYSAUX01.DBF SYSAUX 660
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\UNDOTBS01.DBF UNDOTBS1 725
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\USERS01.DBF USERS 5
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\TEMP01.DBF TEMP 64
Control Files
Name
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\control01.ctl
{ORACLE_BASE}\fast_recovery_area\{DB_UNIQUE_NAME}\control02.ctl
Redo Log Groups
Group Size(K)
1 51200
2 51200
3 51200
![Page 31: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/31.jpg)
![Page 32: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/32.jpg)
![Page 33: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/33.jpg)
The EM Database Express URL is https://computername:5500/em
Click on Password Management if you would like to unlock any of the system accounts. Usually not
needed to do, you may unlock and set password for the sample schemas such as HR, OE, etc.
![Page 34: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/34.jpg)
![Page 35: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/35.jpg)
Connect to the database using sqlplus to verify the database. Unlock the Sample Schemas to start using
them for demo purposes.
Click Start, select All Programs, then Oracle – OraDB12Home1, then Application Development, and
then SQL Plus.
![Page 36: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/36.jpg)
Now you are ready to connect to the database as HR user and start playing with the tables.
![Page 37: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/37.jpg)
Verify Enterprise Manager access using the URL provided by DBCA in the summary screen after database
creation.
![Page 38: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/38.jpg)
![Page 39: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/39.jpg)
Another tool to login to the database is SQL Developer, which is also installed by default along with 12c
Database Software Install.
Click Start, select All Programs, then Oracle – OraDB12Home1, then Application Development, and
then SQL Developer.
First time, a configuration screen appears asking the java location. I used the location installed by the
Oracle DB 12c software.
![Page 40: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/40.jpg)
Click on the green “+” to add database connection information.
![Page 41: Create non-cdb (traditional) oracle database 12c on windows](https://reader034.vdocuments.us/reader034/viewer/2022052505/55524c34b4c9059a4f8b4d15/html5/thumbnails/41.jpg)
Enjoy the Oracle12c Database learning!