Installing Oracle Database 10g on Windows

Installing Oracle Database 10g on Windows

Purpose

In this tutorial, you learn how to install Oracle Database 10g on Windows.

Topics

This tutorial covers the following topics:

	Overview
	Installing Oracle Database 10g on Windows
	Post Installation Tasks
	Testing Your Installation
	Summary

Overview

Using the Oracle Universal Installer, you install the Oracle Database 10g software and create a database.

Back to Topic List

Installing Oracle Database 10g on Windows

To install the Oracle software, you must use the Oracle Universal installer.

1.	For this installation you need either the DVDs or a downloaded version of the DVDs. In this tutorial, you install from the downloaded version. From the directory where the DVD files were unzipped, double-click setup.exe.
2.	The Oracle Universal Installer starts.
3.	You will perform a basic installation with a starter database. Enter orcl for the Global Database Name and oracle for the Database Password and Confirm Password. Then click Next.
4.	The installer now verifies that the system meets all the minimum requirements for installing and configuring the chosen product. Please correct any reported errors (warnings are OK) before continuing. When the check successfully completes (with or without warnings), click Next.
5.	If you received any warnings, you can proceed. Click Yes.
6.	Review the Summary window to verify what is to be installed. Then, click Install.
7.	The progress window appears.
8.	The Configuration Assistants window appears.
9.	Your database is now being created.
10.	When the database has been created, you can unlock the users you want to use. Click Password Management.
11.	Unlock SH, OE and HR users by clicking on the check mark in the Lock Account? column. Enter the same name as the user in the New Password and Confirm Password fields. For example, to unlock SH user, enter SH in the New Password and Confirm Password fields. Then, click OK.
12.	Click OK again.
13.	Click Exit.
14.	Click Yes to confirm exit.

Back to Topic List

Post Installation Tasks

For additional functionality within DB Control, functionality such as starting and stopping the database, an operating system user must belong to the ORA_DBA group. An existing user can be used or a new user can be created. This topic shows you how to create the operating system user oracle and make the user part of the ORA_DBA group:

Note: The following steps outlined were done in a Windows XP environment. The steps will be slightly different in a Windows NT or 2000 environment.

1.	Click Start > Settings > Control Panel. Select Administrative Tools.
2.	Select Computer Management.
3.	Select Local Users and Groups.
4.	In the right hand panel, right click Users. Select New User ...
5.	In the New User window enter: User name: oracle Description: Oracle Administration User Password: <a secure password> Confirm: <a secure password> For this example the password oracle is used. Deselect User must change password at next logon Click Create.
6.	Another New User window appears. Click Close to close the window.
7.	Double-click Groups.
8.	Double click ora_dba.
9.	In the ora_dba Properties screen, click Add.
10.	In the Select Users screen, click Advanced.
11.	Click Find Now.
12.	Shift-select BATCH and the oracle user from the list at the bottom of the window. Then click OK.
13.	Click OK.
14.	Click OK.
15.	Close the Computer Management window.
16.	You also need to add the oracle to the Security Policy Log on as a batch job. Double-click on Local Security Policy.
17.	Double-click on Log on as a batch job.
18.	Click Add User or Group ...
19.	Click Advanced...
20.	Click Find Now.
21.	Select oracle from the list and click OK.
22.	Click OK.
23.	Click OK again.
24.	Close the Local Security Policy window.
25.	Close the Administrative Tools window.

Back to Topic List

Testing Your Installation

To test that your installation completed successfully, perform the following:

1.	When you click exit from the previous section, a browser opens and the Database Control URL is already launched. If this does not happen, open a browser and enter the following URL: http://<hostname>:1158/em Enter system as the User Name and oracle as the Password and click Login.
2.	The Licensing window appears. Scroll to the bottom and click I agree.
3.	The Database Control Home Page appears. Your Installation was successful.

Summary,

In this tutorial, you learned how to install and test the Oracle Database 10g installation on windows.