blazin_sun
asked on
upgrade database & owb from 10.2.0.2 to 10.2.0.4
Hi Experts,
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.
Please suggest.
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.
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.
Please suggest.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It is relatively easy to upgrade the DB.
For OWB the above is the only appropriate documentation.
If you run into errors search in Internet and i am sure you will find the cause.
For OWB the above is the only appropriate documentation.
If you run into errors search in Internet and i am sure you will find the cause.
ASKER
I tried the above doc and resulted with the java packages invalid.
Thanks