Daily Archives: December 26, 2015

12c, dbca

Oracle 12c Create stand-alone database(non-CDB and non-PDB)

Leave a comment

In Oracle 12c, Container Databases were introduced which allowed for multiple separate database to be placed in a single oracle instance to reduce the amount of resource consumed.   However, it is still possible to create a traditional stand-alone database without the features or restriction of a CDB.  This procedure covers the creation of a 12c standalone database using Oracle Database Configuration Assistant in a Windows environment.

 

  1. Logon your windows server as the administrator.

 

  1. Open Oracle Database Configuration Assistant.

  1. At the Database Operation Page select “Create Database”

  1. At the Creation Mode Page select “Advanced Mode”

  1. At the Database Template Page select the Desired type of database, in This example we select “General Purpose or Transaction Processing”

  1. At the Database Identification Page enter the Global Database Name and SID, then unselect “Create as Container Database” and press Next Button.

  1. At the Management Options Page, select Configure Enterprise Manger (EM) Database Express if desired.

 

  1. At the Database Credentials Page, select Use the Same Administrative Password for All Accounts and enter a valid password. Additionally enter a password the administrative account on the windows system.

  1. On the Network Configuration Page, select the Listener to be used by the new database.

  1. At the Storage Location Page, select the appropriate storage for your database.

  1. At the Database Options page select nothing and Press Next button.

 

  1. At the Initialization Parameters Page, select the defaults and Press the Next button.

 

 

  1. At the Creation Options Page, select Create Database and Generate Database Creation Scripts (giving a valid destination directory) and press Next button.

  1. At the Summary Page, press the Finish button.

  1. The Progress Page, a confirmation of script creation will be displayed, once complete press OK.

  1. The CDB will now be created in Windows.

  1. A confirmation screen will appear once the install is completed with the EM information and confirmation of install, Press the Exit button to close.

  1. Once back at the Progress Page, press the Close button to terminate Database Configuration Assistant.

This completes creation of Oracle 12c stand-alone database in Windows environment with Database Configuration Assistant.

 

 

Larry Catt

OCP