Download Oracle Database
To install Oracle database on your computer, you need to download the installer from the download page of the Oracle website. After the download is complete, the installation files are in ZIP format and you need to extract them into a specific folder on your computer.
- Oracle Database 19c Download for Microsoft Windows x64 (64-bit)
- Oracle Database Software Downloads (Enterprise Edition)
To start the installation process, you need to double-click the setup.exe file. There will be 9 steps that mostly automatically execute. Let’s start.
Install Oracle Database
Step 1. The installer asks you to enter your email address to get the latest security issues and updates. By clicking the Next button, you can ignore it. If you didn’t provide the email address, the Oracle database installer confirm it, you just need to click the No button to continue.
Step 2. In this step, the Oracle installer asks you whether you want to create and configure a database, install database software only, or just upgrade an existing database. If you install the Oracle database for the first time on your computer, choose option 1 (Create and configure a database) and click the Next button.
Step 3. The installer allows you to choose the system class. Because you install Oracle on your computer, not a server, therefore, you choose the first option: desktop-class and click the Next button.
Step 4. This step allows you to specify the Windows user account to install and configure Oracle Home for enhanced security. Choose the third option: “Use Windows Built-in Account”.
Step 5. in this step you can (1) choose the folder on which Oracle database will be installed, (2) Global database name and password, (3) pluggable database name. We install to database app folder in C drive as the following image.
Step 6. The installer performs the prerequisite check.
Step 7. The installer shows you the summary of the information such as global settings, database information, etc. You need to review the information and click the install button if everything is fine.
Step 8. The installer starts installing the Oracle database. It will take a few minutes to complete, depending on your computer. You will see the Database Configuration Assistant window. Click the Password management… button to enter the password for Oracle database accounts. Enter the password for SYS and SYSTEM accounts and then click the OK button.
Step 9. Once installation completes successfully, the installer will inform you as shown in the following screenshot. Click the Close button to close the window. We think you can easily install Oracle Database now.
Connect to Oracle Database
First, launch the SQL developer application provided by the Oracle Database.
Second, right-click the connections node and choose New Connection … menu item to create a new connection.
Third, enter the information that you provided during the installation process as shown in the following screenshot. Click the Connect button to connect to the Oracle Database.
SQL Developer will display all objects as shown below. Congratulation! you have installed Oracle Database 12c successfully. Let’s start exploring Oracle. You follow Oracle Apex Guide for a serial tutorial to learn Oracle Apex.
The article was published on June 12, 2020 @ 11:10 AM