Before installing the software, OUI performs several automated checks to ensure that your computer fulfills the basic hardware and software requirements for an Oracle Database installation. If your computer does not meet the requirements, an error message is displayed. Some of the requirements to install the software are:
Before starting this tutorial, you should:
To install Oracle database on your computer, you need to download the installer from the download page of Oracle website.
If you want to download Oracle Database, you have to be an account in oracle.com. So go to https://profile.oracle.com/myprofile/account/create-account.jspx to create an account and submit the form. After notifying, you will able to login.
Now time to start Oracle Installation. You need to double-click the setup.exe file to start the installation process.
There will be 9 steps which mostly automatically execute.
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.
Enter your email address and My Oracle Support password to receive security issue notifications via email. If you do not wish to receive notifications via email, deselect "I wish to receive security updates via My Oracle Support". Click Next to continue. Click "Yes" in the confirmation window to confirm your preference.
Because I didn’t provide the email address, the Oracle database installer confirm it, you just need to click the No button to continue.
The Select Installation Option window appears with the following options:
In this OBE, we create and configure the database. Select the Create and configure a database option and click Next.
The System Class window appears. Select Desktop Class or Server Class depending on the type of system you are using. In this OBE, we will perform the installation on a desktop/laptop. Select Desktop class and click Next.
The Oracle Home User Selection window appears. Starting with Oracle Database 12c Release 1 (12.1), Oracle Database on Microsoft Windows supports the use of an Oracle Home User, specified at the time of installation. This Oracle Home User is used to run the Windows services for a Oracle Home, and is similar to the Oracle User on Oracle Database on Linux. This user is associated with an Oracle Home and cannot be changed to a different user post installation.
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.
Note that by default, the installer creates a container database along with a pluggable database called "pdborcl". The pluggable database contains the sample HR schema. Change the Global database name to orcl. Enter the "Administrative password" as Oracle_1. This password will be used later to log into administrator accounts such as SYS and SYSTEM. Click Next.
The installer performs the prerequisite check.
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.
The installer starts installing 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 OK button.
Once installation completes successfully, the installer will inform you as shown in the following screenshot. Click the Close button to close the window.
You need to connect Oracle Database Server to check two ways that installation is okay or not.
1. Using SQL*Plus
2. SQL Developer
Open cmd and type sqlplus and enter or You can also find the SQL*Plus program in the Program folder of the Start Menu on Windows as shown below:
Enter user-name: sys as sysdba Enter password: Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> show con_name; CON_NAME ------------------------------ gabc
It means that you have connected to the Oracle Database Server.
At now, Playground is ready, so you start to play and enjoy.