Home » RDBMS Server » Server Administration » How do you patch several databases in intermediate stages? (10.2.01, 10.2.0.4)
How do you patch several databases in intermediate stages? [message #386569] Mon, 16 February 2009 02:46 Go to next message
ten.1010
Messages: 2
Registered: February 2009
Junior Member
Hi,

I'm about to do an upgrade/patch of several databases. I'd like to migrate them one at a time from 10.2.0.1 to 10.2.0.4. However the notes indicate that you must apply the patch to an existing directory. Is there any way of copying the existing directory to another one and apply the patch to that new directory. Thanks in advance.

Beetle. Confused
Re: How do you patch several databases in intermediate stages? [message #386617 is a reply to message #386569] Mon, 16 February 2009 04:31 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


No;

While Doing patch installaion; Oracle Home should be same NOT Different.

http://babudba.blogspot.com/2008/09/upgrade-oracle-from-10201-to-10204.html

Babu
Re: How do you patch several databases in intermediate stages? [message #386661 is a reply to message #386569] Mon, 16 February 2009 08:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> I'd like to migrate them one at a time from 10.2.0.1 to 10.2.0.4
Not sure what you mean here.

You will be first patching the Oracle Home and do something to
the database (run catupgrd.sql)
If there are multiple ORACLE_HOME, patch do it multiple times.
If there are multiple databases in the same ORACLE_HOME,
first patch, and run catupgrd.sql on each database.

Take a backup of ORACLE_HOME and database before doing anything.
Re: How do you patch several databases in intermediate stages? [message #386753 is a reply to message #386661] Mon, 16 February 2009 23:07 Go to previous messageGo to next message
ten.1010
Messages: 2
Registered: February 2009
Junior Member
Hi,

It's the latter. That is, I have multiple databases in the same ORACLE_HOME. I want to keep one database at the initial patch level but I want to take another database to the next patch level. Only when I am ok with the one at the latest patch level will I then do the other one. Is there any way of putting the database being patched into it's own ORACLE_HOME?

Beetle.
Re: How do you patch several databases in intermediate stages? [message #386756 is a reply to message #386569] Mon, 16 February 2009 23:18 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Is there any way of putting the database being patched into it's own ORACLE_HOME?
Yes, just create a new directory tree.
Re: How do you patch several databases in intermediate stages? [message #386938 is a reply to message #386756] Tue, 17 February 2009 05:37 Go to previous message
ahudspith
Messages: 26
Registered: January 2009
Location: Avoiding the tax man.
Junior Member
Yes - as already stated.

If your current Oracle_Home is /oracle/oracle10201 (for example)

Create a new directory/mount point ... /oracle/oracle10204 ... install Oracle there and patch it up to the correct level.

Then just restart the databases under the new Oracle_Home as you are ready for them (move s/pfile to the new location - set the environment to start it up - change oratab).

Then start the database and run the upgrade scripts (such as catupgrd.sq).

Simple and easy.
Previous Topic: ASM configuration
Next Topic: Table Space
Goto Forum:
  


Current Time: Thu Dec 08 00:27:34 CST 2016

Total time taken to generate the page: 0.06334 seconds