Solved

upgrade database & owb from 10.2.0.2 to 10.2.0.4

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

Independent Software Vendors: 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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
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.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

733 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