Oracle Tutorial

  • Home
  • Start Here
  • Basics
  • Advanced
    • Oracle View
    • Oracle Index
    • Oracle Synonym
    • Oracle Sequence
    • Oracle Administration
  • PL/SQL
  • Functions
    • Aggregate Functions
    • Analytic Functions
    • Comparison Functions
    • Date Functions
    • String Functions
  • API
    • Python Oracle
Home / Getting Started with Oracle Database / Install Oracle

Install Oracle

Summary: this tutorial shows you step by step how to install Oracle Database 12c in Windows 10.

Installing Oracle Database

To install Oracle database on your computer, you need to download the installer from the download page of Oracle website.

After having the installation files which are 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.

Install Oracle Database

Now you need to double-click the setup.exe file to start the installation process. There will be 9 steps which mostly automatically execute.

Step 1. The installer asks you to provide your email address to get the latest security issues and updates. You can ignore it by clicking the Next button

Install Oracle Database - Step 1

Because I 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 step 2, Oracle installer ask you to whether you want to create and configure a database, install database software only or just upgrade an existing database. Because you install the Oracle database at the first time, choose the option 1 and click the Next button.

Install Oracle Database - Step 2

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.

Install Oracle Database - Step 3

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”.

Install Oracle Database - Step 4

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.

Install Oracle Database - Step 5

Step 6. The installer performs the prerequisite check.

Install Oracle Database - Step 6

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.

Install Oracle Database - Step 7

Step 8. The installer starts installing Oracle database. It will take a few minutes to complete, depending on your computer.

Install Oracle Database - Step 8

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 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.

Install Oracle Database - Step 9

Connecting 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.

SQL Developer - Connected

Congratulation! you have installed Oracle Database 12c successfully. 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\

If you follow the above installation steps, then the file is located at the following directory:

C:\app\product\12.1.0\dbhome_1\network\admin\

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) ) )

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.

  • Was this tutorial helpful?
  • YesNo
Previous What Is Oracle Database
Next Oracle Sample Database

Getting Started

  • What Is Oracle Database
  • Install Oracle Database Server
  • Download Oracle Sample Database
  • Create Oracle Sample Database
  • Connect To Oracle Database Server

Oracle Data Manipulation

  • SELECT
  • Oracle DUAL Table
  • ORDER BY
  • SELECT DISTINCT
  • WHERE
  • Table & Column Aliases
  • AND
  • OR
  • FETCH
  • BETWEEN
  • IN
  • LIKE
  • IS NULL
  • Joins
  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL OUTER JOIN
  • CROSS JOIN
  • Self Join
  • GROUP BY
  • HAVING
  • UNION
  • INTERSECT
  • MINUS
  • GROUPING SETS
  • CUBE
  • ROLLUP
  • PIVOT
  • UNPIVOT
  • INSERT
  • INSERT INTO SELECT
  • INSERT ALL
  • UPDATE
  • DELETE
  • MERGE
  • Subquery
  • Correlated Subquery
  • EXISTS
  • NOT EXISTS
  • ANY
  • ALL

Oracle Data Types

  • Oracle Data Types
  • NUMBER
  • FLOAT
  • BINARY_FLOAT
  • CHAR
  • NCHAR
  • VARCHAR2
  • NVARCHAR2
  • DATE
  • INTERVAL
  • TIMESTAMP
  • TIMESTAMP WITH TIME ZONE

Oracle Data Definition

  • CREATE TABLE
  • Identity Column
  • ALTER TABLE
  • ALTER TABLE ADD Column
  • ALTER TABLE MODIFY Column
  • Drop Columns
  • DROP TABLE
  • TRUNCATE TABLE
  • RENAME Table
  • Oracle Virtual Column

Oracle Constraints

  • PRIMARY KEY
  • FOREIGN KEY
  • UNIQUE
  • CHECK
  • NOT NULL

Oracle Views

  • CREATE VIEW
  • DROP VIEW
  • Updatable Views
  • Inline Views
  • WITH CHECK OPTION

About Oracle Tutorial

OracleTututorial.com website provides Developers and Database Administrators with the updated Oracle tutorials, scripts, and tips.

Search

Recent Tutorials

  • Oracle Implicit Statement Results
  • Calling PL/SQL Stored Functions in Python
  • Calling PL/SQL Procedures in Python
  • Managing Transaction in Python
  • Deleting Data From Oracle Database in Python

Site Links

  • Oracle Books
  • About
  • Contact
  • Privacy Policy
  • Terms of Use

Copyright © 2021 Oracle Tutorial. All Rights Reserved.