Step-by-Step Instructions:

How to Install Oracle 10g on your own Windows Machine

(will add how to create the course database shortly!)

1) Download the Oracle 10g version that is for your particular platform (Unix, Windows, Linux) from the Oracle download site at –

http://www.oracle.com/technology/software/products/database/oracle10g/index.html

For e.g., to download Oracle 10g 32 bit version for Windows, you would click on the link that would take you to:

http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/winsoft.html

The page above instructs you to download the zip file 10g_win32_db.zip into an empty directory. The Oracle course setup instructions suggest that you create a directory structure of empty directories on your main disk drive, say C, of so that in C:\stage\Disk1 you download and then unzip the 10g_win32_db.zip file.

2) Now, double click on the “setup” cmd icon in the Disk1 subdirectory from above. This will launch Oracle’s Universal Installer.

You will see the “Welcome” screen below. Leave everything as the default on this screen. Note, my drive I am installing on is my D drive, for you this may be your C drive. You need to type in a password for the privileged users of the Starter Database that will be created. The name of the database is ‘orcl’. Use the password ‘oracle’ (don’t type in any quote marks, though) for your privileged users of the database. These are the built-in users/administrators known as sys, system, sysman and dbsnmp. Once you have filled in and confirmed your password, press the “Next” button.

3) The installation will now proceed. And you will see the progress in percentages. Note the directory in which a log of the install is being created near the bottom of the screen.

4) Eventually, the screen that shows progress through the Configuration Assistants will launch. You can simply watch – no input should be necessary – while this part of the installation proceeds.

5) For e.g., while the Database Configuration Assistant is running and creating your starter database, you will see the progress on a screen such as the one below:

6) Once the Database Configuration Assistant has completed creation of your starter database, you will see this screen –

Click the password management button and you will see the other accounts that have been created within the starter database. All of the accounts except for sys and system are initially locked by default. Click on the check mark in the box for the account ‘scott’ so that account is not initially locked and you can log into it later. ‘scott’ is one of the ‘default users’ that Oracle like to create in its sample databases and this ‘scott’ account initially has the password ‘tiger’. Having this account open may come in handy in testing that this sample database is started and accessible.

7) You will now see the “Successful End of Installation” screen below:

Click on the Exit button.

8) You will now see the Oracle Enterprise Manager Console launch within a browser menu and tell you the status of your starter database (whether it is started or not). If your database is started, you can log in as a user.