1.1 Installing Oracle Database Software and Creating a Database

«« Previous
Next »»

1. Overview


Purpose

This tutorial shows you how to use the Oracle Universal Installer (OUI) to install the Oracle Database 12c software and create a database. You will also learn how you can use the Database Configuration Assistant (DBCA) to create additional databases.

Time to Complete

Approximately 1 hour

Introduction

The Oracle Universal Installer (OUI) is used to install Oracle Database software. OUI is a graphical user interface utility that enables you to view the Oracle software that is installed on your machine, install new Oracle Database software, and delete Oracle software that you no longer need to use. Online Help is available to guide you through the installation process. One of the installation options is to create a database. If you select database creation, OUI automatically starts Oracle Database Configuration Assistant (DBCA) to guide you through the process of creating and configuring a database. If you do not create a database during installation, you must invoke DBCA after you have installed the software to create a database. You can also use DBCA to create additional databases.

In Oracle Database 12c Release 1 the concept of multitenant environment has been introduced. The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB) that includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12 were non-CDBs.

A CDB includes the following components:
  • Root
The root, named CDB$ROOT, stores Oracle-supplied metadata and common users. An example of metadata is the source code for Oracle-supplied PL/SQL packages. A common user is a database user known in every container. A CDB has exactly one root.
  • Seed
The seed, named PDB$SEED, is a template that you can use to create new PDBs. You cannot add objects to or modify objects in the seed. A CDB has exactly one seed.
  • PDBs
A PDB appears to users and applications as if it were a non-CDB. For example, a PDB can contain the data and code required to support a specific application. A PDB is fully backward compatible with Oracle Database releases before Oracle Database 12c.

Each of these components is called a container. Therefore, the root is a container, the seed is a container, and each PDB is a container. Each container has a unique container ID and name within a CDB.

Hardware and Software Requirements

Before installing the software, OUI performs several automated checks to ensure that your computer fulfills the basic hardware and software requirements for an Oracle Database installation. If your computer does not meet a requirement, then an error message is displayed. The requirements may vary depending upon the type of computer and operating system you are using, but include the following:
  • Minimum of 1 GB of physical memory
  • Sufficient paging space
  • Installation of appropriate service packs and/or patches
  • Use of appropriate file system format
Prerequisites

Before starting this tutorial, you should:
  • Have access to the Oracle Database 12c distribution media or have downloaded the software from the Oracle web site
  • Have general knowledge of product installation

2. Installing Oracle Database Software


There are two types of Oracle Database installations: basic (also known as typical) and advanced. Choose the typical installation to quickly install the software with minimal input. The advanced installation enables you to perform a custom installation.

Please note that the values displayed in the screenshots may vary from your installation values due to differences in disk space and memory.
  • Basic (Typical) Installation.
    • For Non-Container Database
1. Log on to your computer as a member of the administrative group that is authorized to install Oracle Database software and create a database.

2. If you are installing from distribution media, insert the distribution media for Oracle Database into your computer. The Autorun feature opens the Select a Product to Install window automatically. If you have downloaded the installation software from the Oracle Web site, follow the instructions on the site to invoke the Oracle Universal Installer.

3. The Configure Security Updates window appears. Enter your email address and My Oracle Support password to receive security issue notifications via email. If you do not wish to receive notifications via email, deselect "I wish to receive security updates via My Oracle Support". Click Next to continue. Click "Yes" in the confirmation window.

Installing Oracle Database Software and Creating a Database

4. The Download Software Updates window appears. Select "Use My Oracle Support credentials for download" to download and apply the latest software updates. Select "Use pre-downloaded software updates" to apply software updates that you previously downloaded. Select "Skip software updates" if do not want to apply any updates. Click Next to continue.

Installing Oracle Database Software and Creating a Database

5. The Select Installation Option window appears. Select "Create and configure a database." Click Next.

Installing Oracle Database Software and Creating a Database

6. The System Class window appears. Select Desktop Class or Server Class depending on the type of system you are using. In this scenario, we have chosen Server Class. If you choose Desktop Class, the windows that appear may vary slightly from what is shown in this example. Click Next.

Installing Oracle Database Software and Creating a Database

7. The Grid Installation Options window appears. Select "Single instance database installation." Click Next.

Installing Oracle Database Software and Creating a Database.

8. The Select Install Type window appears. Select "Typical install." Click Next.

Installing Oracle Database Software and Creating a Database

9. The Typical Install Configuration window appears. In the "Administrative password" field, specify the password to be used for the SYS, SYSTEM, SYSMAN, and DBSNMP accounts. (A warning is displayed if the password does not meet oracle password standards) De-select Create as Container Database. Click Next.

Installing Oracle Database Software and Creating a Database

10. The Create Inventory window appears. Accept the defaults and click Next.

Installing Oracle Database Software and Creating a Database

11. The prerequisite checks are performed and a Summary window appears. Review the settings and click Install.

Installing Oracle Database Software and Creating a Database

12. The progress window appears.

Installing Oracle Database Software and Creating a Database

13. The Execute Configuration Scripts window appears.

Installing Oracle Database Software and Creating a Database

14. Open a terminal window and log in as the root user. Execute the scripts as instructed. Close your terminal window.

Installing Oracle Database Software and Creating a Database

15. After executing the scripts in your terminal window, return to the Execute Configuration scripts window and click OK.

Installing Oracle Database Software and Creating a Database

16. The Database Configuration Assistant creates the database.

Installing Oracle Database Software and Creating a Database

17. After the Database Configuration Assistant creates the database, you can click "Password Management" to unlock accounts. You can also unlock these accounts after the installation process completes. Click OK to continue.

Installing Oracle Database Software and Creating a Database

18. The Finish window appears indicating the installation of Oracle Database software and creation of the database was successful. Click Close to exit the Oracle Universal Installer.

Installing Oracle Database Software and Creating a Database
    • For Container Database(including Pluggable Database)
1. Log on to your computer as a member of the administrative group that is authorized to install Oracle Database software and create a database.

2. If you are installing from distribution media, insert the distribution media for Oracle Database into your computer. The Autorun feature opens the Select a Product to Install window automatically. If you have downloaded the installation software from the Oracle Web site, follow the instructions on the site to invoke the Oracle Universal Installer.

3. The Configure Security Updates window appears. Enter your email address and My Oracle Support password to receive security issue notifications via email. If you do not wish to receive notifications via email, deselect "I wish to receive security updates via My Oracle Support". Click Next to continue. Click "Yes" in the confirmation window.

Installing Oracle Database Software and Creating a Database

4. The Download Software Updates window appears. Select "Use My Oracle Support credentials for download" to download and apply the latest software updates. Select "Use pre-downloaded software updates" to apply software updates that you previously downloaded. Select "Skip software updates" if do not want to apply any updates. Click Next to continue.

Installing Oracle Database Software and Creating a Database

5. The Select Installation Option window appears. Select "Create and configure a database." Click Next.

Installing Oracle Database Software and Creating a Database

6. The System Class window appears. Select Desktop Class or Server Class depending on the type of system you are using. In this scenario, we have chosen Server Class. If you choose Desktop Class, the windows that appear may vary slightly from what is shown in this example. Click Next.

Installing Oracle Database Software and Creating a Database

7. The Grid Installation Options window appears. Select "Single instance database installation." Click Next.

Installing Oracle Database Software and Creating a Database

8. The Select Install Type window appears. Select "Typical install." Click Next.

Installing Oracle Database Software and Creating a Database

9. The Typical Install Configuration window appears. In the "Administrative password" field, specify the password to be used for the SYS, SYSTEM, SYSMAN, and DBSNMP accounts. (A warning is displayed if the password does not meet oracle password standards) Accept the default value for Create as Container Database and provide a Pluggable database name such as pdborcl. Click Next.

Installing Oracle Database Software and Creating a Database

Note: The Create as Container Database option is enabled to create the database as a CDB that can support zero, one, or many user-created PDBs. If you want DBCA to create a PDB when it creates the CDB, specify the PDB name in the Pluggable database name field.
10. The Create Inventory window appears. Accept the defaults and click Next.

Installing Oracle Database Software and Creating a Database

11. The prerequisite checks are performed and a Summary window appears. Review the settings and click Install.

Installing Oracle Database Software and Creating a Database

12. The progress window appears.

Installing Oracle Database Software and Creating a Database

13. The Execute Configuration Scripts window appears.

Installing Oracle Database Software and Creating a Database

14. Open a terminal window and log in as the root user. Execute the scripts as instructed. Close your terminal window.

Installing Oracle Database Software and Creating a Database

15. After executing the scripts in your terminal window, return to the Execute Configuration scripts window and click OK.

Installing Oracle Database Software and Creating a Database

16. The Database Configuration Assistant creates the database.

Installing Oracle Database Software and Creating a Database

17. After the Database Configuration Assistant creates the database, you can click "Password Management" to unlock accounts. You can also unlock these accounts after the installation process completes. Click OK to continue.

Installing Oracle Database Software and Creating a Database

18. The Finish window appears indicating the installation of Oracle Database software and creation of the database was successful. Click Close to exit the Oracle Universal Installer.

Installing Oracle Database Software and Creating a Database
  • Advanced Installation
    • For Non-Container Database
1. Log on to your computer as a member of the administrative group that is authorized to install Oracle Database software and create a database.

2. If you are installing from distribution media, insert the distribution media for Oracle Database into your computer. The Autorun feature opens the Select a Product to Install window automatically. If you have downloaded the installation software from the Oracle Web site, follow the instructions on the site to invoke the Oracle Universal Installer.

3. The Configure Security Updates window appears. Enter your email address and My Oracle Support password to receive security issue notifications via email. If you do not wish to receive notifications via email, deselect "I wish to receive security updates via My Oracle Support" and Click Next to continue. Click "Yes" in the confirmation window. 

Installing Oracle Database Software and Creating a Database

4. The Download Software Updates window appears. Select "Use My Oracle Support credentials for download" to download and apply the latest software updates. Select "Use pre-downloaded software updates" to apply software updates that you previously downloaded. Select "Skip software updates" if you do not want to apply any updates. Click Next to continue.

Installing Oracle Database Software and Creating a Database

5. The Select Installation Option window appears. Select "Create and configure a database." Click Next.

Installing Oracle Database Software and Creating a Database

6. The System Class window appears. Select Desktop Class or Server Class depending on the type of system you are using. In this scenario, we have chosen Server Class. If you choose Desktop Class the windows that appear may vary slightly from what is shown in this example. Click Next.

Installing Oracle Database Software and Creating a Database

7. The Grid Installation Options window appears. Select "Single instance database installation." Click Next.

Installing Oracle Database Software and Creating a Database

8. The Select Install Type window appears. Select "Advanced install." Click Next.

Installing Oracle Database Software and Creating a Database

9. The Select Product Languages window appears. Accept the default of English or select another language as appropriate. Click Next.

Installing Oracle Database Software and Creating a Database

10. The Select Database Edition window appears. Select Enterprise Edition. Click Next.

Installing Oracle Database Software and Creating a Database

11. The Specify Installation Location window appears. Accept the default values or change as appropriate to your installation. Click Next.

Installing Oracle Database Software and Creating a Database

12. The Create Inventory window appears. Click Next.

Installing Oracle Database Software and Creating a Database

13. The Select Configuration Type window appears. Select "General Purpose/Transaction Processing." Click Next.

Installing Oracle Database Software and Creating a Database

14. The Specify Database Identifiers window appears. Accept the default values or change as necessary for your installation. De-select Create as Container Database. Click Next.

Installing Oracle Database Software and Creating a Database

15. The Specify Configuration Options window appears. Select the "Enable Automatic Memory Management" option on the Memory tab. Click the "Character sets" tab.

Installing Oracle Database Software and Creating a Database

16. On the "Character sets" tab select" Use Unicode (AL32UTF8)" or select as appropriate to your installation. Click the Sample Schemas tab.

Installing Oracle Database Software and Creating a Database

17. On the Sample Schemas tab, select "Create database with sample schemas." Click Next.

Installing Oracle Database Software and Creating a Database

18. The Specify Database Storage Options window appears. Accept the default of File System. Click Next.

Installing Oracle Database Software and Creating a Database

19. The Specify Management Options window appears. Click Next.

Installing Oracle Database Software and Creating a Database

20. The Specify Recovery Options window appears. Select "Enable Recovery." Click Next.

Installing Oracle Database Software and Creating a Database

21. The Specify Schema Passwords window appears. Specify separate passwords for the SYS, SYSTEM, and DBSNMP users or select "Use the same password for all accounts." Enter the password(s) in the Password and "Confirm password" fields. Click Next.

Installing Oracle Database Software and Creating a Database

22. The Privileged Operating System Groups window appears. Select the appropriate operating system groups for each group. Click Next.

Installing Oracle Database Software and Creating a Database

23. The Perform Prerequisite Checks window appears. After the prerequisite checks complete, the Installer advances to the next window.

Installing Oracle Database Software and Creating a Database

24. The Summary window appears. Review the settings. Click Install to install the Oracle Database software and create the database.

Installing Oracle Database Software and Creating a Database

25. The Install Product window appears.

Installing Oracle Database Software and Creating a Database

26. The "Execute Configuration scripts" window appears.

Installing Oracle Database Software and Creating a Database

27. Open a terminal window and log in as the root user. Execute the scripts as instructed. Close the terminal window once you have executed both scripts.

Installing Oracle Database Software and Creating a Database

28. After executing the scripts in the terminal window, return to the "Execute Configuration scripts" window. Click OK to continue.

Installing Oracle Database Software and Creating a Database

29. The Database Configuration Assistant window appears.

Installing Oracle Database Software and Creating a Database

30. After the Database Configuration Assistant completes, a window appears providing database information. You can click Password Management to view and unlock the accounts. You can also unlock them at a later time. Click OK to proceed.

Installing Oracle Database Software and Creating a Database

31. The Finish window appears indicating that the installation of Oracle Database was successful. Click Close to end the Oracle Universal Installer.

Installing Oracle Database Software and Creating a Database
    • For Container Database(including Pluggable Database)
1. Log on to your computer as a member of the administrative group that is authorized to install Oracle Database software and create a database.

2. If you are installing from distribution media, insert the distribution media for Oracle Database into your computer. The Autorun feature opens the Select a Product to Install window automatically. If you have downloaded the installation software from the Oracle Web site, follow the instructions on the site to invoke the Oracle Universal Installer.

3. The Configure Security Updates window appears. Enter your email address and My Oracle Support password to receive security issue notifications via email. If you do not wish to receive notifications via email, deselect "I wish to receive security updates via My Oracle Support" and Click Next to continue. Click "Yes" in the confirmation window. 

Installing Oracle Database Software and Creating a Database

4. The Download Software Updates window appears. Select "Use My Oracle Support credentials for download" to download and apply the latest software updates. Select "Use pre-downloaded software updates" to apply software updates that you previously downloaded. Select "Skip software updates" if you do not want to apply any updates. Click Next to continue.

Installing Oracle Database Software and Creating a Database

5. The Select Installation Option window appears. Select "Create and configure a database." Click Next.

Installing Oracle Database Software and Creating a Database

6. The System Class window appears. Select Desktop Class or Server Class depending on the type of system you are using. In this scenario, we have chosen Server Class. If you choose Desktop Class the windows that appear may vary slightly from what is shown in this example. Click Next.

Installing Oracle Database Software and Creating a Database

7. The Grid Installation Options window appears. Select "Single instance database installation." Click Next.

Installing Oracle Database Software and Creating a Database

8. The Select Install Type window appears. Select "Advanced install." Click Next.

Installing Oracle Database Software and Creating a Database

9. The Select Product Languages window appears. Accept the default of English or select another language as appropriate. Click Next.

Installing Oracle Database Software and Creating a Database

10. The Select Database Edition window appears. Select Enterprise Edition. Click Next.

Installing Oracle Database Software and Creating a Database

11. The Specify Installation Location window appears. Accept the default values or change as appropriate to your installation. Click Next.

Installing Oracle Database Software and Creating a Database

12. The Create Inventory window appears. Click Next.

Installing Oracle Database Software and Creating a Database

13. The Select Configuration Type window appears. Select "General Purpose/Transaction Processing." Click Next.

Installing Oracle Database Software and Creating a Database

14. The Specify Database Identifiers window appears. Accept the default values or change as necessary for your installation. Accept the default value for Create as Container Database and provide a Pluggable database name such as pdborcl. Click Next.

Installing Oracle Database Software and Creating a Database

Note: The Create as Container Database option is enabled to create the database as a CDB that can support zero, one, or many user-created PDBs. If you want DBCA to create a PDB when it creates the CDB, specify the PDB name in the Pluggable database name field.

15. The Specify Configuration Options window appears. Select the "Enable Automatic Memory Management" option on the Memory tab. Click the "Character sets" tab.

Installing Oracle Database Software and Creating a Database

16. On the "Character sets" tab select "Use Unicode (AL32UTF8)" or select as appropriate to your installation. Click the Sample Schemas tab.

Installing Oracle Database Software and Creating a Database

17. On the Sample Schemas tab, select "Create database with sample schemas." Click Next.

Installing Oracle Database Software and Creating a Database

18. The Specify Database Storage Options window appears. Accept the default of File System. Click Next.

Installing Oracle Database Software and Creating a Database

19. The Specify Management Options window appears. Click Next.

Installing Oracle Database Software and Creating a Database

20. The Specify Recovery Options window appears. Select "Enable Recovery." Click Next.

Installing Oracle Database Software and Creating a Database

21. The Specify Schema Passwords window appears. Specify separate passwords for the SYS, SYSTEM, and DBSNMP users or select "Use the same password for all accounts." Enter the password(s) in the Password and "Confirm password" fields. Click Next.

Installing Oracle Database Software and Creating a Database

22. The Privileged Operating System Groups window appears. Select the appropriate operating system groups for each group. Click Next.

Installing Oracle Database Software and Creating a Database

23. The Perform Prerequisite Checks window appears. After the prerequisite checks complete, the Installer advances to the next window.

Installing Oracle Database Software and Creating a Database

24. The Summary window appears. Review the settings. Click Install to install the Oracle Database software and create the database.

Installing Oracle Database Software and Creating a Database

25. The Install Product window appears.

Installing Oracle Database Software and Creating a Database

26. The "Execute Configuration scripts" window appears.

Installing Oracle Database Software and Creating a Database

27. Open a terminal window and log in as the root user. Execute the scripts as instructed. Close the terminal window once you have executed both scripts.

Installing Oracle Database Software and Creating a Database

28. After executing the scripts in the terminal window, return to the "Execute Configuration scripts" window. Click OK to continue.

Installing Oracle Database Software and Creating a Database

29. The Database Configuration Assistant window appears.

Installing Oracle Database Software and Creating a Database

30. After the Database Configuration Assistant completes, a window appears providing database information. You can click Password Management to view and unlock the accounts. You can also unlock them at a later time. Click OK to proceed.

Installing Oracle Database Software and Creating a Database

31. The Finish window appears indicating that the installation of Oracle Database was successful. Click Close to end the Oracle Universal Installer.

Installing Oracle Database Software and Creating a Database

3. Creating an Oracle Database


If you chose to install the Oracle Database software only and did not create a database, or if you want to create additional databases, you can do so by using the Database Configuration Assistant (DBCA). DBCA offers two modes: typical and advanced. If you choose Advanced Mode, you can customize storage locations, initialization parameters, management options, database options, and different passwords for administrator user accounts.

Note: If you created a database as part of the Basic (Typical) Installation or Advanced Installation, you do not need to perform the tasks in this topic.
  • Typical Mode
    • Creation of Non-Container Database
1. Log on to your computer as a member of the administrative group that is authorized to install Oracle Database software and create a database.

2. Invoke DBCA as appropriate to your operating system.

3. The Database Operation window appears. Select Create Database. Click Next.

Installing Oracle Database Software and Creating a Database

4. The Creation Mode window appears. Ensure that Create a database with default configuration is selected. Enter a value in the Global Database Name field. Select File System in the Storage Type menu. Accept the default values for Database Files Location and Fast Recovery Area. Select AL32UTF8 - Unicode UTF - 8 Universal character set in the Database Character Set menu. Enter a password for the SYS and SYSTEM users in the Administrative Password and Confirm Password fields. Un-Check Create As Container Database check box. Click Next.

Installing Oracle Database Software and Creating a Database

5. The Summary window appears. Review the information. Click Finish.

Installing Oracle Database Software and Creating a Database

6. The Progress Page window appears.

Installing Oracle Database Software and Creating a Database

7. The Database Configuration Assistant window appears indicating that the database has been successfully created. You can click Password Management to unlock the user accounts or you can perform this task at a later time. Click Close to close the window.

Installing Oracle Database Software and Creating a Database
    • Creation of Container Database
1. Log on to your computer as a member of the administrative group that is authorized to install Oracle Database software and create a database.

2. Invoke DBCA as appropriate to your operating system.

3. The Database Operation window appears. Select Create Database. Click Next.

Installing Oracle Database Software and Creating a Database

4. The Creation Mode window appears. Ensure that Create a database with default configuration is selected. Enter a value in the Global Database Name field. Select File System in the Storage Type menu. Accept the default values for Database Files Location and Fast Recovery Area. Select AL32UTF8 - Unicode UTF - 8 Universal character set in the Database Character Set menu. Enter a password for the SYS and SYSTEM users in the Administrative Password and Confirm Password fields. Ensure that Create As Container Database check box is selected and provide a Pluggable database name such as pdborcl. Click Next.

Installing Oracle Database Software and Creating a Database

Note: The Create as Container Database option is enabled to create the database as a CDB that can support zero, one, or many user-created PDBs. If you want DBCA to create a PDB when it creates the CDB, specify the PDB name in the Pluggable database name field.
5. The Summary window appears. Review the information. Click Finish.

Installing Oracle Database Software and Creating a Database

6. The Progress Page window appears.

Installing Oracle Database Software and Creating a Database

7. The Database Configuration Assistant window appears indicating that the database has been successfully created. You can click Password Management to unlock the user accounts or you can perform this task at a later time. Click Close to close the window.

  • Advanced Mode
    • Creation of Non-Container Database
Installing Oracle Database Software and Creating a Database
1. Log on to your computer as a member of the administrative group that is authorized to install Oracle Database software and create a database.

2. Invoke DBCA as appropriate to your operating system.

3. The Database Operation window appears. Select Create Database. Click Next.

Installing Oracle Database Software and Creating a Database

4. The Creation Mode window appears. Select Advanced Mode. Click Next.

Installing Oracle Database Software and Creating a Database

5. The Database Template window appears. Select "General Purpose or Transaction Processing." Click Next.

Installing Oracle Database Software and Creating a Database

6. The Database Identification window appears. Enter a value in the Global Database Name field. Click Next.

Installing Oracle Database Software and Creating a Database

7. The Management Options window appears. Accept the defaults and click Next.

Installing Oracle Database Software and Creating a Database

Note: EM Express Port number can be modified as per the requirement.
8. The Database Credentials window appears. Select "Use the Same Administrative Password for All Accounts." Enter your password in the Password and Confirm Password fields. Click Next.

Installing Oracle Database Software and Creating a Database

9. The Network Configuration window appears. This page is displayed only if there are any listeners in the current home. Click Next.

Installing Oracle Database Software and Creating a Database

10. The Storage Locations window appears. In the Database Files region, select File System in the Storage Type menu. Select "Use Database File Locations from Template." In the Recovery Related Files regions, select File System in the Storage Type menu. Accept the default value for the Fast Recovery Area. Click Next.

Installing Oracle Database Software and Creating a Database

11. The Database Options window appears. On the Sample Schemas tab, select Sample Schemas. Click the "Database Vault & Label Security" tab.

Installing Oracle Database Software and Creating a Database

12. View the selections on the "Database Vault & Label Security" tab. Select Configure Database Vault and/or Configure Label Security if appropriate for your installation. Click Next.

Installing Oracle Database Software and Creating a Database

13. The Initialization Parameters window appears. Accept the default value of Memory Size(SGA and PGA) and select Use Automatic Memory Management under Typical Settings option. Modify the value in Memory Size if necessary for your installation . Click the Sizing tab.

Installing Oracle Database Software and Creating a Database

14. On the Sizing tab accept the default value in the Processes field or change it as appropriate for your installation. Click the Character Sets tab.

Installing Oracle Database Software and Creating a Database

15. On the Character Sets tab select "Use Unicode (AL32UTF8) " or change it as appropriate for your installation. Click the Connection Mode tab.

Installing Oracle Database Software and Creating a Database

16. On the Connection Mode tab accept the default of Dedicated Server Mode. Click Next.

Installing Oracle Database Software and Creating a Database

17. The Creation Options window appears. Review the details and click Next.

Installing Oracle Database Software and Creating a Database

18. The Summary window appears. Review the configuration summary information. Click Finish.

Installing Oracle Database Software and Creating a Database

19. The Progress Page window appears.

Installing Oracle Database Software and Creating a Database

20. The Database Configuration Assistant window appears indicating the database has been created. Select Password Management to unlock the user accounts or perform this task at a later time. Click Close.

Installing Oracle Database Software and Creating a Database
    • Creation of Container Database
1. Log on to your computer as a member of the administrative group that is authorized to install Oracle Database software and create a database.

2. Invoke DBCA as appropriate to your operating system.

3. The Database Operation window appears. Select Create Database. Click Next.

Installing Oracle Database Software and Creating a Database

4. The Creation Mode window appears. Select Advanced Mode. Click Next.

Installing Oracle Database Software and Creating a Database

5. The Database Template window appears. Select "General Purpose or Transaction Processing." Click Next.

Installing Oracle Database Software and Creating a Database

6. The Database Identification window appears. Enter a value in the Global Database Name field. Check Create As Container Database check box and provide a Pluggable database name such as pdborcl. Click Next.

Installing Oracle Database Software and Creating a Database

Note: The Create as Container Database option is enabled to create the database as a CDB that can support zero, one, or many user-created PDBs. If you want DBCA to create a PDB when it creates the CDB, specify the PDB name in the Pluggable database name field.
7. The Management Options window appears. Accept the defaults and click Next.

Installing Oracle Database Software and Creating a Database

Note: EM Express Port number can be modified as per the requirement.
8. The Database Credentials window appears. Select "Use the Same Administrative Password for All Accounts." Enter your password in the Password and Confirm Password fields. Click Next.

Installing Oracle Database Software and Creating a Database

9. The Network Configuration window appears. This page is displayed only if there are any listeners in the current home. Click Next.

Installing Oracle Database Software and Creating a Database

10. The Storage Locations window appears. In the Database Files region, select File System in the Storage Type menu. Select "Use Database File Locations from Template." In the Recovery Related Files regions, select File System in the Storage Type menu. Accept the default value for the Fast Recovery Area. Click Next.

Installing Oracle Database Software and Creating a Database

11. The Database Options window appears. On the Sample Schemas tab, select Sample Schemas. Click the "Database Vault & Label Security" tab.

Installing Oracle Database Software and Creating a Database

12. View the selections on the "Database Vault & Label Security" tab. Select Configure Database Vault and/or Configure Label Security if appropriate for your installation. Click Next.

Installing Oracle Database Software and Creating a Database

13. The Initialization Parameters window appears. Accept the default value of Memory Size(SGA and PGA) and select Use Automatic Memory Management under Typical Settings option. Modify the value in Memory Size if necessary for your installation . Click the Sizing tab.

Installing Oracle Database Software and Creating a Database

14. On the Sizing tab accept the default value in the Processes field or change it as appropriate for your installation. Click the Character Sets tab.

Installing Oracle Database Software and Creating a Database

15. On the Character Sets tab select "Use Unicode (AL32UTF8) " or change it as appropriate for your installation. Click the Connection Mode tab.

Installing Oracle Database Software and Creating a Database

16. On the Connection Mode tab accept the default of Dedicated Server Mode. Click Next.

Installing Oracle Database Software and Creating a Database

17. The Creation Options window appears. Review the details and click Next.

Installing Oracle Database Software and Creating a Database

18.  The Summary window appears. Review the configuration summary information. Click Finish.

Installing Oracle Database Software and Creating a Database

19. The Progress Page window appears.

Installing Oracle Database Software and Creating a Database

20. The Database Configuration Assistant window appears indicating the database has been created. Select Password Management to unlock the user accounts or perform this task at a later time. Click Close.

Installing Oracle Database Software and Creating a Database

«« Previous
Next »»