Install Oracle10g on Windows XP and Create the Database&Install patch on it

Go to the link: http://www.oracle.com/technetwork/database/10201winsoft-095341.html
and choose the product.

Run Oracle Universal Installer.
Steps:
1. Advanced Installation->Next
2. Enterprise Edition(631MB)->Next
3. Name : Ora10g
Path :C:\oracle\product\10.2.0
->Next
*At this moment there might happen errors.If the error message is the following :'The install has detected that primary IP address of the system is DHCP-assigned....' This means that you have obtained an IP address automatically..you should change it manually.After solving this problem you should press retry button and continue the installation.
4.Install database Software only->Next->Install->Exit->Yes.
Oracle is installed.

Creating database...

Steps:
1.Start->All Programs->Oracle - Ora10g->Configuration and Migration Tools->Database Configuration Assistant.->Next
2.Create Database->Next
3.General Purpose->Next
4.Global Database Name:MFDB
SID :MFDB
->Next
5.->Next(Let's leave default settings)
6.Password :******
Confirm Password:******
->Next
7.File System->Next
8.Use Database File Locations from Template->Next
9.->Next
10.If you want HR,SCOTT schemas to be installed you should check "Sample Schemas"->Next
11.->Next
12.->Next
13.->Finish->OK
*At this moment there may happen an error,if the error message is the following:"..credential retrieval failed".In this case you should change sqlnet.ora file content from SQLNET.AUTHENTICATION_SERVICES= (NTS) to SQLNET.AUTHENTICATION_SERVICES= (NONE).
*NTS means that OS accounts can connect to oracle as sysdba without specifying password.
*NONE means that no one can connect to oracle without specifying password.

Because of tnsnames.ora and listener.ora files are not configured during this installation.They should be configured manually,more correctly,with the help of Net Configuration Assistant.
Steps:
1.Start->All Programs->Oracle - Ora10g->Configuration and Migration Tools->Net Configuration Assistant.
2.Listener configuration->Next
3.Add->Next
4.Listener name:LISTENER
->Next
5.->Next
6.->Next
7.->Next
8.->Finish

Now create tnsnames.ora file:
1.Start->All Programs->Oracle - Ora10g->Configuration and Migration Tools->Net Configuration Assistant.
2.Local NetService Name configuration->Next
3.Add->Next
4.Service Name:MFD
->Next
5.TCP->Next
6.Host name:your host name(computer name)->Next
7.->Next
8.Net Service Name:MFD
->Next
9.->Next->Next->Finish

Oracle is ready to be accessed. If you find it difficult to connect to oracle with system/pass as sysdba you should connect to oracle by sys/pass as sysdba and type the command: grant sysdba to system;

Upgrade Oracle from 10.2.0.1 To 10.2.0.4

I had my post about this,but found another more helpful and easy understandable one from Babu B 's blog .Here it is:


1. Patch Set Overview

Patch set release 10.2.0.4. Before installing this patch set you must be need 10.2.0.1 version.

2. Requirements

Oracle DB : Oracle 10.2.0.1 (later)
Operating System: Windows


3. Pre - Installation Tasks

1. Identify prior installation

Before installing this patch you must install oracle 10.2.0.1 (or later version)

2. Download Patch set

Download 6810189 patch set installation archive to a directory that is not the Oracle home directory or under the Oracle home directory.

3. Shutdown oracle database.

C:\>set oracle_sid= GOLDLINK

C:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Nov 13 10:49:26 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect sys@GOLDLINK as sysdba
Enter password:
Connected.

SQL> SHUTDOWN
Database closed.
Database dismounted.
ORACLE instance shut down.

4. Stop all services

C:\>set oracle_sid=GoldLink

C:\>net stop OracleDBConsoleGOLDLINK
The OracleDBConsoleGOLDLINK service is stopping................
The OracleDBConsoleGOLDLINK service was stopped successfully.


C:\>net stop OracleServiceGOLDLINK
The OracleServiceGOLDLINK service is stopping.
The OracleServiceGOLDLINK service was stopped successfully.


C:\>net stop OracleOraDB10g_Home1iSQL*Plus..
The OracleOraDb10g_home1iSQL*Plus service was stopped successfully.

C:\>net stop OracleOraDB10g_Home1TNSListener
The OracleOraDb10g_home1TNSListener service is stopping.
The OracleOraDb10g_home1TNSListener service was stopped successfully.

Note: while patch installation time If you face Distributed Transaction Coordinator still running. You should be stop this service

C:\>net stop msdtc
The Distributed Transaction Coordinator service is stopping.
The Distributed Transaction Coordinator service was stopped successfully.

4. Backup your database.

Oracle recommends that you create a backup of the Oracle 10g installation before you install the patch set.

5. Check Tablespace Sizes and Set Parameter Values

Review the following sections before upgrading a database.

8. Upgrade the Database

After you install the patch set, you must perform the following steps on every database associated with the upgraded Oracle home:

1. Start all services

2. Connect sys user

C:\> sqlplus /NOLOG

SQL> CONNECT SYS/SYS_password AS SYSDBA

3. Enter the following SQL*Plus commands:

SQL> STARTUP UPGRADE

SQL> SPOOL patch.log

SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\catupgrd.sql

SQL> SPOOL OFF

Review the patch.log file for errors and inspect the list of components that is displayed at the end of catupgrd.sql script.

This list provides the version and status of each SERVER component in the database.
If necessary, rerun the catupgrd.sql script after correcting any problems.

4. Restart the database:

SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP

5. Compile Invalid Objects

Run the utlrp.sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.
SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\utlrp.sql

SQL> select * from v$version;