Summary: This tutorial guides you through the step-by-step process of installing Oracle Database 12c on Windows 10.
Installing Oracle Database #
To install the Oracle database on your computer, you must download the installer from the Oracle website’s download page.
After having the installation files in ZIP format, you need to extract them into a specific folder on your computer.
The following picture shows the structure of the folder of the Oracle installation files after extraction.
Now, double-click the setup.exe file to initiate the installation process. There will be 9 steps that execute mostly automatically.
Step 1. The installer asks you to provide your email address to receive the latest security updates and information about new issues. You can ignore it by clicking the Next button:
Since I didn’t provide the email address, the Oracle database installer confirmed it. You need to click the ‘No’ button to continue.
Step 2. In step 2, the Oracle installer prompts you to choose whether you want to create and configure a database, install database software only, or upgrade an existing database. Since you are installing the Oracle database for the first time, choose option 1 and click the Next button.
Step 3. The installer allows you to choose the system class. Since you are installing Oracle on your computer, not a server, choose the first option, Desktop Class, and click the Next button.
Step 4. This step enables you to specify the Windows user account for installing and configuring the Oracle Home, providing enhanced security. Choose the third option: “Use Windows Built-in Account”.
Step 5. In this step, you can (1) choose the folder in which the Oracle database will be installed, (2) the Global database name and password, and (3) the pluggable database name.
Step 6. The installer performs the prerequisite check.
Step 7. The installer displays a summary of the information, including global settings and database details. 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 the SYS and SYSTEM accounts and then click the OK button.
Step 9. Once the installation is completed successfully, the installer will inform you, as shown in the following screenshot. Click the Close button to close the window.
Connecting to Oracle Database #
First, launch the SQL developer application provided by the Oracle Database.
Second, right-click the connections node and choose the 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 successfully installed Oracle Database 12c. Let’s start exploring Oracle.
Adding an entry to the tnsnames.ora file #
The tnsnames.ora file is typically located in the following directory:
C:\app\<user>\product\12.1.0\dbhome_1\network\admin\Code language: SQL (Structured Query Language) (sql)If you follow the above installation steps, then the file is located in the following directory:
C:\app\product\12.1.0\dbhome_1\network\admin\Code language: SQL (Structured Query Language) (sql)You first open the tnsnames.ora file using any text editor such as Notepad or Notepad++. Then, you need to add the following lines at the end of the file:
PDBORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdborcl)
)
)Code language: SQL (Structured Query Language) (sql)After that, you can save the file and close it. It is time to download and load a sample database into the Oracle Database server.
