Home » RDBMS Server » Performance Tuning » Question on 10.2.0.2 patch application on 10.2.0.1 database
Question on 10.2.0.2 patch application on 10.2.0.1 database [message #179114] Sun, 25 June 2006 15:58 Go to next message
rajd
Messages: 6
Registered: June 2006
Junior Member
Hi,

I have apply a 10.2.0.1 database on sun sparc 64-it server. I saw the latest 10.2.0.2 patch available on the metalink. So i downloaded the patch and applied to my 10.2.0.1 oracle software as well as on existing 10.2.0.1 instance according to the steps specified in the Readme file of the patch. My installation succeded without any error but when i query the dba_registry view, all the components are showing the version 10.2.0.2 correctly except Oracle Workspace Manager which is still showing a version of 10.2.0.1 as follows is this correct ? I am not aware of the of Oracle Workspace Manager, can anybody tell me why Oracle Workspace Manager is used ?
SQL> select comp_name , version from dba_registry;

COMP_NAME                           VERSION
----------------------------------- ----------
Oracle Expression Filter            10.2.0.2.0
Oracle Workspace Manager            10.2.0.1.0 <----------
Oracle Enterprise Manager           10.2.0.2.0
Oracle Database Catalog Views       10.2.0.2.0
Oracle Database Packages and Types  10.2.0.2.0
JServer JAVA Virtual Machine        10.2.0.2.0
Oracle XDK                          10.2.0.2.0
Oracle Database Java Packages       10.2.0.2.0

8 rows selected.


Also I noticed one more thing , when i use emctl command it shows version as 10.2.0.2 but when i use emca it is showing 10.2.0.1

oracle>emctl
Oracle Enterprise Manager 10g Database Control Release 10.2.0.2.0 <---- (correct version)
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Invalid arguments
.....

oracle>emca -version
EM Configuration Assistant, Version 10.2.0.1.0 Production <-----
Copyright (c) 2003, 2005, Oracle. All rights reserved.
oracle>

Anyone knows what could be the reason ?

Thanks,
Raj
Re: Question on 10.2.0.2 patch application on 10.2.0.1 database [message #179119 is a reply to message #179114] Sun, 25 June 2006 19:23 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>why Oracle Workspace Manager is used
http://www.oracle-base.com/articles/9i/WorkspaceManagement9i.php
I have'nt patched anything yet in 10g and have no first hand experience here. Usually the patches arrive as cumulative or specific patchets for a product/issue. Seems the patchset you applied to be a core database patchset.
Look into patchet README file or metalink. You will see which particular products/bugs are affected with this patchset.
Previous Topic: improve performance of query over dblink.
Next Topic: Configuration of PGA Aggregate Target
Goto Forum:
  


Current Time: Wed May 01 03:32:58 CDT 2024