Oracle database installation and configuration (Oracle19c)

Article directory

foreword
1. Download the installation package
2. Decompress the compressed package
3. Installation steps
- 1. Configuration options
- 2. Database installation options
- 3. Database version
- 4.Oracle home directory user
- 5. Installation location
- 6. Prerequisite Check
- 7. Summary
- 8. Install the product
- 9. finish
Fourth, create a database
- 1. Database operation
- 2. Create mode, deployment type
- 3. Database identification
- 4. Storage options
- 5. Quick recovery option
- 6. Network configuration
- 7. Data Vault option
- 8. Configuration options
- 9. Management options
- 10. User identification
- 11. Create options
- 12. Summary
- 13. Progress page
- 14. Done
Summarize

Foreword

Oracle Database 19c is the latest version of the relational database management system released by Oracle Corporation. It is an upgraded version of Oracle Database 12c Release 2, which provides more functions and performance optimization. Some of the new features in 19c include:

Automated machine learning: You can use automated machine learning to identify and resolve database issues.
Enhanced Security: Includes enhanced encryption and authentication, and better auditing and monitoring.
Big data support: including support for JSON data types and enhanced spatial data support.
Better performance: including faster queries and higher concurrency performance.
Better management tools: including better automation and management tools, and better cloud integration support.
In general, Oracle Database 19c is a powerful, superior performance, safe and reliable database management system, suitable for various enterprise-level applications and data management needs.
Next, I will install Oracle 19c with Windows 10 for your reference.

1. Download the installation package

Go to the official website to download, download address: https://www.oracle.com/database/technologies/oracle19c-windows-downloads.html

PS: If you do not have an oracle account, you can register one with your email.

2. Decompress the compressed package

After decompressing the compressed package, click the setup application to install it (PS: right click and run as administrator)

3. Installation steps

1. Configuration options

Select only setup software, and then click [Next].

2. Database installation options

Select single-instance database installation, and then click [Next].

3. Database version

Select Enterprise Edition, and click [Next].

4.Oracle home directory user

Select the default virtual account here, and click [Next].

5. Installation location

Select the path you want to install, and click [Next].

6. Prerequisite check

Wait for the condition to be checked

7. Summary

click to install

8. Install the product

9. Complete

Click to close

4. Create database

Start dbca, [win + R], enter cmd, run as administrator

Enter dbca and press Enter

dbca

1. Database operation

Select to create a database, and then click [Next].

2. Create mode, deployment type

Select advanced settings and click [Next]. , select oracle single-instance database for database type, select general purpose or transaction processing for template name, and then click [Next].