| 10.2.0.5 - upgrading only 1 database [message #494677] |
Wed, 16 February 2011 09:25  |
firefly
Messages: 53
Registered: March 2009
Location: Europe
|
Member |
|
|
Hi,
If have several databases running on a 10.2.0.4 Oracle Home. I want to upgrade one of them to 10.2.0.5. My thinking is that I install 10.2 to another location e.g. /u01/app/oracle/product/10.2.0.5 and patch this OH to 10.2.0.5. Regarding the steps to upgrade a particular database can anyone detail the steps or preferably point me to Oracle documentation as I'm unable to locate?
Many thanks!
|
|
|
|
| Re: 10.2.0.5 - upgrading only 1 database [message #494678 is a reply to message #494677] |
Wed, 16 February 2011 09:30  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Install 10.2.0.4 in a separate new ORACLE_HOME
Copy/Migrate the database you want to be upgraded to new ORACLE_HOME
Upgrade/Patch new ORACLE_HOME to 10.2.0.5
Upgrade the database in 10.2.0.5.
What is size of database/number of schemas?
If small,
Just install 10.2.0.5 in new home.
Create empty database.
Export and import.
[Updated on: Wed, 16 February 2011 09:32] Report message to a moderator |
|
|
|
| Re: 10.2.0.5 - upgrading only 1 database [message #494679 is a reply to message #494678] |
Wed, 16 February 2011 09:32 |
firefly
Messages: 53
Registered: March 2009
Location: Europe
|
Member |
|
|
Mahesh Rajendran wrote on Wed, 16 February 2011 15:30Install 10.2.0.4 in a separate new ORACLE_HOME
Copy/Migrate the database you want to be upgraded to new ORACLE_HOME
Upgrade/Patch new ORACLE_HOME to 10.2.0.5
Upgrade the database in 10.2.0.5.
That looks goo thanks. Do you have the steps / Oracle docs for
"Copy/Migrate the database you want to be upgraded to new ORACLE_HOME" as this is what I'm really after?
Thanks,
|
|
|
|
|
|
|
|
|
|
| Re: 10.2.0.5 - upgrading only 1 database [message #494687 is a reply to message #494682] |
Wed, 16 February 2011 10:26 |
firefly
Messages: 53
Registered: March 2009
Location: Europe
|
Member |
|
|
In the link it mentions
"You may or may not have to change the listener.ora file." We don't use a listener.ora file, does this mean that I need to make changes to the listener some other way, or should stop & start pick up the new Oracle Home?
Also,
"- Set the environment variable to point to the new home.
You may also have to change your .profile or .bash_profile files to reflect this change."
We use a .profile file alright, but where are is environment variable?
Thanks!
|
|
|
|
|
|
|
|
| Re: 10.2.0.5 - upgrading only 1 database [message #494697 is a reply to message #494690] |
Wed, 16 February 2011 11:41 |
firefly
Messages: 53
Registered: March 2009
Location: Europe
|
Member |
|
|
|
Say I successfully upgrade the database in question and then I want to upgrade a second database. If I move the next database to the new (10.2.0.5) Oracle Home..what do I need to do then...will it just start ok or do I need to re-run the patch against this second database? Thanks,F
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
