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
Step 1 - Configure Security Updates¶
Fill out if you'd like to recieve these notifications from Oracle or Skip and select NEXT.
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.
Step 3 - Select System Class¶
Select Server Class and NEXT.
Step 4 - Select Database Installation Option¶
Select Single instance database installation and NEXT.
Step 5 - Select Install Type¶
Select Advanced install and NEXT
Step 6 - Select Database Edition¶
Select Standard Edition 2 and NEXT
Step 7 - Specify Oracle Home User¶
Select Use Windows Built-in Account and NEXT.
Step 8 - Specify Installation Location¶
Accept the defaults and select NEXT. Change these directories only if necessary.
Step 9 - Select Configuration Type¶
Select General Purpose / Transaction Processing and NEXT.
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.
Database name must be less than 8 characters. We recommend a max of 4 characters.
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.
Step 11 - Specify Configuration Options¶
Select default options and NEXT
Step 12 - Specify Database Storage Options¶
Select File system default and NEXT
Step 13 - Specify Management Options¶
Select default (none) and NEXT
Step 14 - Specify Recovery Options¶
Select default (none) and NEXT
Step 15 - Specify Schema Passwords¶
You can select either option here. It's up to you to chose which fits your organizations security protocol.
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.
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 16 - Perform Prerequisite Checks¶
After the system check is complete select NEXT if there are no major issues flagged.
Step 17 - Summary¶
Review the summary and Select INSTALL
Save Response File - You can save this file for multiple installations. The response file serves as a template.
Step 18 - Install Product¶
Step 19 - Finish¶
Take note of the URL provided. This is the address of the Oracle Enterprise Manager. See Oracle documentation for more information
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¶
<database_name>with your database name
<password_for_sys>with the password for SYS
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
<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;
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.
In most cases you'll want to assign a static IP address to the server.
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
serviceswe can browse to the Oracle Database service. We should also verify that we have a Oracle listener service running as well.
- Oracle Listener service LISTENER
- Oracle Database service DEMO