Skip to content

Oracle Database Installation

  • Oracle Database version 10.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 recieve 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.

Disable password expire and failed login attempts

  • 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

Remove the brackets < >, they are not needed

Start command prompt and enter the following commands

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
/* 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;

After running this script have the user login. if they still can’t, you may have to reset each one since their passwords already expired.

If they still can’t log in – replace <username> and <password> with each user’s info. Assign each user a new password. It can also stay the same as it was but it's best to change it to eliminate possible problems.

1
2
3
4
5
6
/* Reconnect as the user SYS */
Sqlplus/nolog
Connect Sys/<password_for_sys> as sysdba

Alter user <username> identified by <password>;
Commit;

Remove case sensitive logon

Remove the requirement for case sensitive user name and passwords.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
/* Connect to the Oracle Database as 
   the user SYS */
set oracle_sid = `<database_name>`
sqlplus/nolog
connect sys/`<password>` as sysdba;

/* Disable case sensitive user name and passwords */

ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;

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

  1. Oracle Listener service LISTENER
  2. Oracle Database service DEMO