Oracle 11g XE: Install and configure on Windows7 environment

 

Hello folks, here I am outlining the steps to install and configure Oracle 11g Express Edition on a Windows 7 environment. (including 64 bit).

  1.             Go to www.oracle.com, register for an account and download the 32-bit Windows install file to your system from the below.

http://www.oracle.com/technetwork/products/express-edition/downloads/index.html

    2.    Once you download the Oracle files for the Win 32 environment, extract it to a folder.
          Double-click on setup.exe file as shown below.

3.    Upon double-clicking, the install process starts with the screen as below: 

 

4.      Click Next in the screen below

 

5.      Select accepting the terms and click Next

 

6.      Click Next

 

7.      Enter passwords and click Next

 

8.      Click Install.

9.      The install process starts, below are a few install screenshots.

 

(You may get the below error on a Windows 64 envt.)

 

I have tested this install both by making the below changes and without. I have so far not yet ran into issues without making the below changes, though the below may be needed later.

 

(Registry Changes)

·        Start-> Run and type “regedit” to edit the registry. Please be careful in making these changes.

 

•   Navigate to

HKEY_CLASSES_ROOT\Installer\Products\266B7A503A089BE4EAD1986A429434C1\SourceList\Media

 

·        Now copy the below text

C:\Users\hostname\AppData\Local\Temp\<enter the value as in your screenshot>

C:\Users\hostname\AppData\Local\Temp\1253E89F-A88D-4ECA-A0E9-503B6C9578DC}\

 

10.      After entering this, click OK in the error you got in the Oracle install process (Once I clicked OK, I again got the error message, so repeated OK, and was able to continue).

 

 

11.      Click Finish. Then go to All Programs->Oracle Database 11g Express Edition and select “Start Database”.

                 You get a screen as below:

 

12.      Now go to to All Programs->Oracle Database 11g Express Edition and select “Run SQL Command Line”.

           You should be prompted to a screen with SQL> in a new window. Enter “connect”. Then   enter “system” as the username and the password you used while installing for the password entry. Press Enter.You should get a screen as below:

 

           

           

 

13.      Enter a command line “select * from tab”

 

(shows 174 rows, not all of them are shown in the screenshot here).

          

14.      Go to Oracle -> Get Started Page.

15.      Enter the username as ‘system’ and the password you had created earlier below:

16.      Enter values for “Create New” database user and click “Create a workspace”.

17.      Select ‘click here’ as shown below

 

18.      Enter the credentials and click Login.

 

You are now successfully logged in to Oracle Application Express!