?
Solved

upgrade database & owb from 10.2.0.2 to 10.2.0.4

Posted on 2008-10-15
5
Medium Priority
?
2,897 Views
Last Modified: 2012-05-05
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.
0
Comment
Question by:blazin_sun
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 48

Accepted Solution

by:
schwertner earned 2000 total points
ID: 22732038
To upgrade the Oracle Db to higher version see
the README.HTM file in your upgrade kit.

To upgrade OWB see instructions here:

http://download.oracle.com/docs/cd/B31080_01/doc/install.102/b28224/upgrade_03.htm
0
 

Author Comment

by:blazin_sun
ID: 22733426
I did read those documents, but its not clear on the owb upgrade perspective. Can you provide me with any sequence of steps and the order we need to do the upgrades for both the database and OWB with out invalidating the Java packages.

I tried the above doc and resulted with the java packages invalid.

Thanks
0
 
LVL 48

Expert Comment

by:schwertner
ID: 22738231
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.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question