Installing Oracle Database 19c

To download and install Oracle Database, refer to the Oracle Technology Network (OTN) website at http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html.

To install Oracle Database 19c for a Simphony installation, from the database server:

1. Select the Accept License Agreement option to download the software.
2. Select the server’s compatible operating system, typically Microsoft Windows x64 (64–bit).
3. Since the downloaded file is compressed, beginning with Oracle Database 19c, Image Based Installation has been introduced. With Oracle Database 19c, via Image Based Installation, the Oracle Universal Installer takes the location of the setup.exe file and assigns its db_home location.
   1. Prior to performing the Oracle Database 19c software download, create a new folder on the database server’s ‘C’ drive named: Oracle19c (with no spaces in the folder name).
   2. Logon as a Windows Administrator and, download and extract the Oracle 19c installation file into the newly created Oracle19c folder. Since the file is nearly 10GB in size, the extraction takes some time.
4. Once extracted, locate and right-click on the setup.exe and select Run as administrator.
5. Select Set Up Software Only, and then click Next.

   Figure 2-29 Select Configuration Option

   
   
   
6. Select Single instance database installation, and then click Next.

   Figure 2-30 Select Database Installation Option

   
   
   
7. Select Enterprise Edition, and then click Next.

   Figure 2-31 Select Database Edition

   
   
   
8. Select Use Virtual Account and then click Next. *(Optional) - You can specify an existing (or create a new) Microsoft Windows user account.

   Figure 2-32 Specify Oracle Home User

   
   
   
9. From the Oracle base field, enter or browse to select the database installation location, and then click Next. This is where the path is identified to store the Oracle Database software and configuration files.

   Figure 2-33 Specify Installation Location

   
   
   
10. The installer performs several installation prerequisite checks and shows a progress bar until the checks are completed.
11. The Summary window shows your previous selections. Once reviewed, select Install to proceed.

    Figure 2-34 Installation Summary

    
    
    
12. The Finish window shows your Oracle Database registration was successful. Click Close.
13. Open a Command prompt session. Enter and run this command:./dbca from the $ORACLE_HOME/bin.
14. Select Create a database, and then click Next.

    Figure 2-35 Select Database Operation

    
    
    
15. Select Advanced configuration, and then click Next.

    Figure 2-36 Select Database Creation Mode

    
    
    
16. From the Database type drop-down list, select Oracle Single Instance database from the drop-down list. Select the General Purpose or Transaction Processing template option, and then click Next.

    Figure 2-37 Select Database Deployment Type

    
    
    
17. From the Global database name field, enter the database name.
    1. From the SID field, enter the Service ID name.
    2. Enable the Create as Container database checkbox.
    3. Enable the Use Local Undo tablespace for PDBs checkbox.
    4. Select Create a Container database with one or more PDBs.
    5. From the Number of PDBs drop-down list, select 1.
    6. From the PDB name field, enter a name for your pluggable database (PDB).

    Figure 2-38 Specify Database Identification Details

    
    
    
18. Select Use following for the database storage attributes.
    1. Ensure the Database files storage type drop-down list is set to File System.
    2. From the Database files location field, enter or browse to select the database file path.
    3. Enable the Use Oracle-Managed Files (OMF) checkbox, and then click Next.

    Figure 2-39 Select Database Storage Option

    
    
    
19. Select the Specify Fast Recovery Area checkbox.
    1. Ensure the Recovery files storage type drop-down list is set to File System.
    2. From the Fast Recovery Area field, enter or browse to select the database files recovery location.
    3. From the Fast Recovery Area size drop-down list, select the size of the database files recovery area.
    4. Enable the Enable archiving checkbox, and then click Next.

       Figure 2-40 Select Fast Recovery Option

       
       
       
20. Enable the Create a new listener checkbox.
    1. Enter LISTENER in the Listener name field.
    2. Assign a port number in the Listener port field, and then click Next.

       Figure 2-41 Specify Network Configuration Details

       
       
       
21. Enable the Configure Oracle Database Vault checkbox.
    1. Enter the name of the Database Vault owner and their associated Password in the appropriate fields.
    2. Re-enter the password in the Confirm password field.
    3. Enable the Create a separate account manager checkbox.
    4. Enter the name of the Account manager and their associated Password in the appropriate fields.
    5. Re-enter the password in the Confirm password field, and click Next.

       Figure 2-42 Select Oracle Data Vault Config Option

       
       
       
22. From this window, select the Sizing tab and specify the maximum number of operating system user processes that can be simultaneously connected to the database in the Processes field. Click Next.

    Figure 2-43 Specify Configuration Options — Sizing tab

    
    
    
23. From the Character sets tab, select Use Unicode (AL32UTF8) as the character set. *(Optional) - You can click the Sample schemas tab and install a sample schema in the starter database, and then click Next.

    Figure 2-44 Specify Configuration Options — Character sets tab

    
    
    
24. *(Optional) - Configuring enterprise managers from the Specify Management Options window is an optional step. Click Next.
25. Select Use different administrative passwords, and enter and confirm unique passwords for the following users:

    • SYS

    • SYSTEM

    • PDBADMIN

    Figure 2-45 Specify Database User Credentials

    
    
    
26. *(Optional) - Enable Use the same password for all accounts and enter and confirm the sole administrative password, and then click Next.
27. Enable the Create database checkbox, and then click Next.

    Figure 2-46 Select Database Creation Option

    
    
    
28. Review the Summary window to ensure that your previous selections are correct. If edits are required, click Back until you reach the window that contains the setting that needs to be changed. If no edits are necessary, click Finish.

    Figure 2-47 Summary

    
    
    
29. An installation Progress Page appears that allows you to track the ongoing database creation.
30. Once complete, the Finish window appears and indicates a successful installation. Click Close to exit the installation program.