How to install oracle 10g on Windows XP professional?

The following steps describes the installation of oracle 10g (10.1.0.2) on

the windows xp operating systems

Where to get oracle 10g for windows xp:

To get the free download copies go to the site http://www.oracle.com/technology/software/products/database . .

Register in the site and then look into Products under the category

of "Oracle10g   Database".

Specifications: 

A Pentium III or Pentium 4 based PC with at least 800 MHz processor, 256 MB

of ram (512 is such better) and at least 10 Gigabytes of free disk space.

If you only have 256 MB of RAM, make sure you have Windows manage at least

400 MB swap file (virtual memory). .

At least 6 GB of free disk space:

Space to download or copy source ZIP files:  1.5 GB

Space to unpack source ZIP files:            1.5 GB

Space to install Oracle10g Software:          2.0 GB

Space for Oracle data files (varies):        2.0 to 5.0 GB

 
 
Steps to installation:
 
1) Download the oracle 10g from oracle TechNet, then you need to unzip the files into a separate
directories and double click on the setup.exe program to get the installation process start. There you
can see a screen like welcome.

2) Click the next button to see the screen specify file locations.
In this screen, the Source and Destination locations must be selected.
The Source path should reflect either your CD-ROM or the directory in which you unzipped the source
files. Leave this as the default. In the example above, the source files were unzipped into
 c:DOCUME~1HARILOCALS~1 emp
ar$ex12.1593diskstageproduct.xml.
For the Destination, leave the Oracle Home named oraDb10g_home1 as the default. Choose a hard

disk drive that has at least 6 gigabytes of free space. In the example here, we are using the E: drive.

Leave the Oracleproduct.1.0db_1 path as it is (the default). If you must change this to a different

 drive, only change the drive letter and not the directories.

3) Click on the Next button to select installation type. This may take up to 2 minutes (depending on

 the speed of your machine). Once the product information has been read, the 4 "Available Products"

options are presented:

 After selecting the type, click on the next button to get the screen database configuration:

For this install, we chose the "General Purpose" Database option. Click on the Next button to continue.

4) The next step is to identify the database using the Global database name. Keep the default names for

GLOBAL and the SID Otherwise, use the following (make a note of these for later on): Global

Database Name is orcl, Oracle SID is orcl

5) Click on the Next button to continue to the "database file storage option" screen. In this step, you

need to select where the Oracle data files will be located. In large operations, we typically keep the data

 files on a separate disk (or disks), however, for this install, keep the default storage 

6) Click on the Next button to move to the "Summary" screen:

In this screen, the products and files that will be installed are summarized. Note that in this example,

 it will take 1.5 GB MB of disk space for the installation of the software. Additional space will be

 required for the default database.

If everything looks OK at this point,

7) Click on the Install button to begin the installation.

During the install, you will notice various Oracle products being copied over to the hard disk.

Once the installation is completed

8) The next step will be to configure the various additional services and the database.

The tools will be automatically starts and it is optional. It is recommended, although not required

9) Click on the next button .The Oracle Database Configuration Assistant will appear for some

time while the default database is created and opened.

Once the default database has been installed, there will be appear a screen like database configuration assistant

10) click on the Password Management button and change the default passwords for the SYS, SYSTEM, SCOTT

 and DBSNMP accounts .

11) Click the OK button to complete the installation. The end screen will be appears:

After completion of installation .reboot your computer.

To remove the oracle products:

1)  Go to start menu - > programs - > orcle-oradb10g_home5 - >oracle installation products - >

Click the universal installer, here again you see the welcome screen.

2)  Click the button installed product. to see the installed products.

3) Click the remove  button to  remove the oracle products

or you can remove directly on clicking deinstall product button in welcome page.

To test the installation:

Go to start menu - > programs - >oracle-oradb10g_home5 - >application development -> click on the sql plus

Once SQL Plus is running, you will be prompted for 3 things: Username, password and Host String.

Fill in the Username and password fields with the SYSTEM account and leave the Host String field blank.

Since we are connecting to a local Oracle database, no Host String is required. Click on the OK button as

shown below:

If the database is running and the username and password are typed correctly, SQL*Plus should log the

SYSTEM user in and present the SQL> prompt .