Solved

upgrade database & owb from 10.2.0.2 to 10.2.0.4

Posted on 2008-10-15
5
2,885 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
  • 2
5 Comments
 
LVL 47

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 47

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
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…

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now