Oracle Database Discussions

Hi Experts,

I have been using Oracle 10.2.0.3 in windows 7 machine, which has three databases.

When I tried to upgrade it to 10.2.0.4, I got an error when installing the patch 10.2.0.4 stating

*"OUI-10091: There are no patches that need to be applied from the patchset Oracle Database 10g Release 2 Patch Set 3 10.2.0.4."*

I have searched forum and google for this error most of the solution says "it may be because of corrupted software" but actually it was working and I have used it previously.

Then I checked the following things in my database:

SQL> select banner from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

SQL> select comp_name,version,status from dba_registry;

COMP_NAME VERSION STATUS
------------------------------ ---------- ----------
Oracle Enterprise Manager 10.2.0.3.0 VALID
Spatial 10.2.0.3.0 VALID
Oracle interMedia 10.2.0.3.0 VALID
OLAP Catalog 10.2.0.3.0 VALID
Oracle XML Database 10.2.0.3.0 VALID
Oracle Text 10.2.0.3.0 VALID
Oracle Expression Filter 10.2.0.3.0 VALID
Oracle Rules Manager 10.2.0.3.0 VALID
Oracle Workspace Manager 10.2.0.1.0 VALID
Oracle Data Mining 10.2.0.3.0 VALID
Oracle Database Catalog Views 10.2.0.3.0 VALID
Oracle Database Packages and T 10.2.0.3.0 VALID
ypes
JServer JAVA Virtual Machine 10.2.0.3.0 VALID
Oracle XDK 10.2.0.3.0 VALID
Oracle Database Java Packages 10.2.0.3.0 VALID
OLAP Analytic Workspace 10.2.0.3.0 VALID
Oracle OLAP API 10.2.0.3.0 VALID


OPatch Version

C:\oracle\test\mine\10.2.0\db_1\OPatch>opatch lsinventory
Invoking OPatch 10.2.0.3.0

Oracle interim Patch Installer version 10.2.0.3.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..


Oracle Home : C:\oracle\test\mine\10.2.0\db_1
Central Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch version : 10.2.0.3.0
OUI version : 10.2.0.3.0
OUI location : C:\oracle\test\mine\10.2.0\db_1\oui
Log file location : C:\oracle\test\mine\10.2.0\db_1\cfgtoollogs\opatch\opatch201
+2-05-04_12-33-22PM.log+

Lsinventory Output file location : C:\oracle\test\mine\10.2.0\db_1\cfgtoollogs\o
patch\lsinv\lsinventory2012-05-04_12-33-22PM.txt

--------------------------------------------------------------------------------

Installed Top-level Products (2):

Oracle Database 10g 10.2.0.3.0
Oracle Database 10g Release 2 Patch Set 4 10.2.0.5.0
There are 2 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.

--------------------------------------------------------------------------------


OPatch succeeded.


Is the error because the OPatch show that I installed Patch Set 4 10.2.0.5.0, is this a problem?

Can anyone tell me, why am I getting this error?


Thanks,
NONUDAY