Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

upgrade database & owb from 10.2.0.2 to 10.2.0.4

Posted on 2008-10-15
5
Medium Priority
?
2,908 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
3 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
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.
Suggested Courses

580 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