Oracle Database Installation¶

Oracle Database version 12.2.0.1.0
Unzip Oracle Database installation files (winx64_12201_database.zip) to a folder on desktop
Open the folder and run the setup.exe as administrator
Oracle Database Universal Installer guide

Oracle Database Universal Installer¶

Launch the Oracle Database Universal Installer by right clicking on the setup.exe file and selecting run as administrator.

Oracle DB Universal Installer GIF

Oracle Database Universal Installer GIF

Step 1 - Configure Security Updates¶

Fill out if you'd like to receive these notifications from Oracle or Skip and select NEXT.

Step 1 database

Step 2 - Select Installation Option¶

Select Create and configure a database. You can also select Install database software only if you are going to create a database later using the Database Configuration Assistant.

Select NEXT

Step 2 database

Step 3 - Select System Class¶

Select Server Class and NEXT.

Step 3 database

Step 4 - Select Database Installation Option¶

Select Single instance database installation and NEXT.

Step 4 database

Step 5 - Select Install Type¶

Select Advanced install and NEXT

Step 5 database

Step 6 - Select Database Edition¶

Select Standard Edition 2 and NEXT

Step 6 database

Step 7 - Specify Oracle Home User¶

Select Use Windows Built-in Account and NEXT.

Step 7 database

Step 8 - Specify Installation Location¶

Accept the defaults and select NEXT. Change these directories only if necessary.

Step 8 database

Step 9 - Select Configuration Type¶

Select General Purpose / Transaction Processing and NEXT.

Step 9 database

Step 10 - Specify Database Identifiers¶

Under Global database name you can enter your desired database name. If necessary you can also enter your domain name. Oracle system identifier (SID) will populate automatically based on the Global name.

Attention

Database name must be less than 8 characters. We recommend a max of 4 characters.

Example

The screen shot shows our recommended name convention. If you want to use your domain name you would add it before the database name separated by a period.

domain_name.database_name

for example:

lodedata.demo

Step 10 database

Step 11 - Specify Configuration Options¶

Select default options and NEXT

Step 11 database

Step 12 - Specify Database Storage Options¶

Select File system default and NEXT

Step 12 database

Step 13 - Specify Management Options¶

Select default (none) and NEXT

Step 13 database

Step 14 - Specify Recovery Options¶

Select default (none) and NEXT

Step 14 database

Step 15 - Specify Schema Passwords¶

You can select either option here. It's up to you to chose which fits your organizations security protocol.

Select NEXT

Warning

Take note of your password(s). Lode Data Corporation does not keep record of this information. Losing these passwords will result in re-installation of Oracle and possible loss of data.

Tip

If you received training from Lode Data Corporation and did not specify this information during installation then the Use same password for all accounts was selected and the password is the same name as the database (SID)

Step 15 database

Step 16 - Perform Prerequisite Checks¶

After the system check is complete select NEXT if there are no major issues flagged.

Step 16 database

Step 17 - Summary¶

Review the summary and Select INSTALL

Step 17 database

Tip

Save Response File - You can save this file for multiple installations. The response file serves as a template.

Step 18 - Install Product¶

Step 18 database

Step 19 - Finish¶

Select CLOSE

Step 19 database

Tip

Take note of the URL provided. This is the address of the Oracle Enterprise Manager. See Oracle documentation for more information

Optional Settings¶

Oracle has a few default settings that can cause issues for non-system administrators down the road. Two of these settings are a default password life time and failed login attempts. Both of these settings lock the user out until the password is reset. If you'd like to disable these settings then follow the steps below.

Replace <database_name> with your database name
Replace <password_for_sys> with the password for SYS

Note

Use the password you setup for SYS in step number 15

Start command prompt and enter the following commands

-- Remove the brackets < >, they are placeholders and are not needed
-- Connect to the Oracle Database as the user SYS
Set oracle_sid=<database_name>
Sqlplus/nolog
Connect Sys/<password_for_sys> as sysdba;

/***************************
 Unlimited log in attempts
 Password never expires
***************************/

ALTER PROFILE DEFAULT LIMIT
FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_LIFE_TIME UNLIMITED;

Commit;
Exit;

Final checklist¶

Now that you've successfully installed the Oracle Database software, we'll want to confirm that everything is working properly and that clients will be able to connect.

Static IP

In most cases you'll want to assign a static IP address to the server.

Firewall

Oracle uses port 1521 so make sure you've opened the server firewall to allow incoming and outgoing connections on port 1521

Verify the database and listener is running

The database is a service. In our example we named our database DEMO. By selecting the Windows Key and typing in services we can browse to the Oracle Database service. We should also verify that we have a Oracle listener service running as well.

Windows Services

Oracle Listener service LISTENER
Oracle Database service DEMO