OraFAQ Forum: Server Administration » How do you patch several databases in intermediate stages?

Home » RDBMS Server » Server Administration » How do you patch several databases in intermediate stages? (10.2.01, 10.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How do you patch several databases in intermediate stages? [message #386569]

Mon, 16 February 2009 02:46

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

Report message to a moderator

Re: How do you patch several databases in intermediate stages? [message #386617 is a reply to message #386569]

Mon, 16 February 2009 04:31

babuknb
Messages: 1736
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

Report message to a moderator

Re: How do you patch several databases in intermediate stages? [message #386661 is a reply to message #386569]

Mon, 16 February 2009 08:29

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: How do you patch several databases in intermediate stages? [message #386753 is a reply to message #386661]

Mon, 16 February 2009 23:07

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.

Report message to a moderator

Re: How do you patch several databases in intermediate stages? [message #386756 is a reply to message #386569]

Mon, 16 February 2009 23:18

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: How do you patch several databases in intermediate stages? [message #386938 is a reply to message #386756]

Tue, 17 February 2009 05:37

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.

Report message to a moderator

Previous Topic:	ASM configuration
Next Topic:	Table Space

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 24 06:05:53 CST 2025