How to install Database 12C Oracle on Windows

How to install Database 12C Oracle on Windows.
Follow my blog with Bloglovin

Oracle Database has many features that make it an indispensable tool in the world of modern business. Each time Oracle releases a new version of a database, new features are added to help improve existing operations and processes in corporations around the world.

Oracle Database 12c is a popular update, and we’ll walk you through how to install a new database on a Windows 10 machine. Let’s see.

Steps for Installing and Setting-up Oracle 12c

Before setting up Oracle Database on Windows, you need to download the installation package from the official website first. Once you receive the ZIP file, you can extract it to any folder on your system, then double-click the setup.exe file to start the installation.

Note. You will need an Oracle account to download the package. Otherwise, you will need to complete registration to get started.

STEP 1. Run setup.exe and enter your email address if you want to be notified of security updates from Oracle. If you are not interested, you can ignore it and click “Next”.

STEP 2. In the second step, the installer will ask you if you want to:

Create and configure a database
Install only the database software
Update existing database

In this article, we are installing a new database, so we will choose the first option.

STEP 3: Now at this point the installer will ask you to select the system class. Since we are installing the database on a desktop system and not on a server, we will choose the Desktop Class. Click Next to continue.

STEP 4. In this step, we must select the type of Windows user account that will be used to configure Oracle Home. For security reasons, you should choose the standard Windows user account. It is not recommended to use an administrator account. In our case, we chose the built-in Windows account.

STEP 5: On the next screen, you will need to configure the following three parameters:

Select the folder where you want to install the Oracle database.

You can continue from the default location provided by the installer. The default location is drive C of the desktop. However, you can also change this location if you like. This is where Oracle will store all important files such as data files, control files, and redo logs.

Enter the name and password for the global database.

Enter the administrator password for the Oracle Recommended Standards database. The password created for the global database will be used later in step 8 to log into administrator accounts such as SYS and SYSTEM.

A pluggable database is a compilation of schema, schema, and non-schema objects that appears as a non-CDB to the Oracle Net Client.

Note. By default, the installer creates a container database and a “pdborcl” pluggable database. The pluggable database has the same HR schema.

STEP 6. At this point, you don’t need to do anything other than wait for the installer to finish checking the prerequisites.

STEP 7: At this point in the installation process, summary information such as global settings, database information, etc. will be displayed. Be sure to review all such information and then click the Install button if everything is in order.

STEP 8: The database files will now be installed and this process will take some time depending on your system.

At some point, the Database Tuning Assistant popup will appear. Click the Manage Passwords button to set a password for the Oracle Database accounts.

Enter the password twice for the SYS and SYSTEM user accounts created for the global database in step 5.

STEP 9: The last window will display a success message if no errors occurred during installation. You can click the Close button.

It takes just 9 easy steps to install Oracle Database 12c on Windows. When you are done with the installation, you can begin the process of connecting to the Oracle database.

Connect to Oracle Database

To connect to an Oracle database, you need to open the SQL developer application that is provided by the Oracle database itself. Then right-click the connections and select New Connection to create a new connection.

After that, you can proceed to fill in the information that you provided during the installation process. Click the Connect button and you will be connected to the Oracle database.

At this point, SQL Developer will display all objects in the database:

The Oracle 12c database installation is complete and you are now ready to start exploring Oracle.