asked on

upgrade a database from 10.2.0.3 to 10.2.0.5

we have 2 databases in a single oracle home. These databases are in 10.2.0.3
I would like to upgrade one database to 10.2.0.5.
Can anybody thow me a light on how to acheive this?

johnsone

If you only want to upgrade one database, you would create a new Oracle home. Put 10.2.0.3 in the new home. Move the database to be upgraded to the new home and run the upgrade.

ramavenkatesa

ASKER

can you please give me the summary of that procedure how to do that?

ASKER CERTIFIED SOLUTION

johnsone

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ramavenkatesa

ASKER

In one of the steps, u mentioned install oracle with same options.
can i use this procedure?

We will tar the oracle_home and put in one location say /tmp

untar into NEW directory -- infact new oracle home

we will run Command: $ORACLE_HOME/oui/bin/runInstaller -silent -clone ORACLE_HOME="NEW directory" ORACLE_HOME_NAME="home1"

We need to run the post root*.sh scripts after install

johnsone

Personally, I haven't done it that way. It may work. A fresh install is always best. The reason that I say that is there are known issues with relinking if you tar and untar the ORACLE_HOME directory. The clone that you are running may fix that.

ramavenkatesa

ASKER

i can get oracle software for 10.2.0.1 from oracle website
Then, i need to upgrade oracle binaries from 10.2.0.1 to 10.2.0.3 software. Am I right?

johnsone

Yes. That would involve running the patch from 10.2.0.1 to 10.2.0.3. It will be upgrading software only, no databases, so it is pretty quick.

ramavenkatesa

ASKER

implemented.

ramavenkatesa

ASKER

one question, u mentioned oraenv
is it essential to run oraenv OR i can simply use .profile??

johnsone

It is not required to use oraenv. If you use the .profile, make sure that you update it with the new paths.