Installing Oracle Database 10g Express Edition on Windows Vista

Post date: Oct 26, 2010 10:42:25 PM

I had a lot of trouble installing Oracle Database on my Windows Vista machine.

Enjoy a step by step tutorial from installation to working with demonstration data.

1. Download:
   1. Oracle Database 10g Express Edition.
   2. "Single-byte LATIN1 database for Western European language storage, with the Database Homepage user interface in English only".
   3. http://www.oracle.com/technetwork/database/express-edition/downloads/102xewinsoft-090667.html
2. Installation:
   1. Unzip both archives.
   2. Right click on Setup.exe and click Properties. Select the Compatibility tab and check the box to run the program in compatibility mode for Windows XP (Service Pack 2).
   3. Open System by clicking the Start button , clicking Control Panel, clicking System and Maintenance, and then clicking System.
   4. In the left pane, click Advanced system settings.
   5. On the Advanced tab, under Performance, click Settings.
   6. Click the Advanced tab, and then, under Virtual memory, click Change.
   7. Clear the Automatically manage paging file size for all drives check box.
   8. Under Drive [Volume Label], click the drive that contains the paging file you want to change.
   9. Click Custom size, type 4603 megabytes in the Initial size (MB) and Maximum size (MB) box, click Set, and then click OK.
   10. Run Setup.exe in the ds_windows_x86_101202_disk1 folder.
   11. When requested, navigate to the stage folder in the ds_windows_x86_101202_disk2 folder.
   12. Follow on-screen instructions to complete installation.
   13. NOTE: Be sure to remember the SYSTEM account password.
3. Access demonstration data:
   1. Navigate to Oracle Database 10g Express Edition in your start menu.
   2. Click Run SQL Command Line.
   3. Enter the following commands (with a carriage return at the end of each line):
      1. conn system/[SYSTEMPASSWORDSEENOTE]@xe
      2. alter user hr account unlock;
      3. conn hr/hr@xe
   4. Follow instructions to change hr account password.
4. Working with demonstration data in comand line:
   1. Enter the following commands to list the available tables to the hr accout:
      1. select table_name from user_tables;
   2. Other SQL commands can be executed here.
5. Working with demonstration data in GUI:
   1. Navigate to Oracle Database 10g Express Edition in your start menu.
   2. Click Go To Database Home Page.
   3. Log in using the username hr and the password you selected for the hr account.
   4. You can now interface with the data graphically.

tutorial complete :D