I have a task to upgrade the oracle database from 10.2.0.2 to 10.2.0.4 on SunOS sparc 64bit.
Following are the components installed on to the database.
OWB Repository, JVM, XML DB, Workflow.
I need to upgrade the database and owb to 10.2.0.4.
Can you please provide me the steps to upgrade the database and owb from 10.2.0.2 to 10.2.0.4.
will the java classes get invalid after the upgrade? do i need to take any action for JVM and XML before or after the upgrade.
Following was the upgrade results from a testing envi where I have more focus on Java objects.
Oracle Database 10.2 Upgrade Status Utility 08-20-2008 15:54:23
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.4.0 00:13:33
JServer JAVA Virtual Machine LOADING 10.2.0.2.0 00:02:18
Oracle XDK VALID 10.2.0.4.0 00:00:00
Oracle Database Java Packages LOADING 10.2.0.2.0 00:00:00
Oracle XML Database VALID 10.2.0.4.0 00:02:34
Oracle Workspace Manager VALID 10.2.0.4.3 00:00:55
Oracle Data Mining VALID 10.2.0.4.0 00:00:26
OLAP Analytic Workspace VALID 10.2.0.4.0 00:00:18
OLAP Catalog VALID 10.2.0.4.0 00:00:58
Oracle OLAP API INVALID 10.2.0.4.0 00:00:29
Oracle Expression Filter INVALID 10.2.0.4.0 00:00:10
Total Upgrade Time: 00:21:46
Please let me know if you need any additional info.
Thanks for your support.