Solved

upgrade database & owb from 10.2.0.2 to 10.2.0.4

Posted on 2008-10-15
5
2,895 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 500 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

696 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