OraFAQ Forum: Server Administration » upgrade oracle 11.2.0.1 to 11.2.0.2

Home » RDBMS Server » Server Administration » upgrade oracle 11.2.0.1 to 11.2.0.2 (oracle 11g, Linux)

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

upgrade oracle 11.2.0.1 to 11.2.0.2 [message #553232]

Wed, 02 May 2012 10:56

dbarocks
Messages: 6
Registered: October 2011

Junior Member

Hi,

Need advice..

Currently, We are running oracle 11.2.0.1 on Linux server. There are 32 DB instances on this server. As per requirement, we need to install 11.2.0.2 DB on the same server. Is it advisable to have both 11.2.0.1 and 11.2.0.2 databases on the same server with different ORACLE_HOME. How about ORACLE_BASE?? OR, do we need to upgrade all the DB's from 11.2.0.1 to 11.2.0.2. During the upgrade process, if i need to take backup with exp/imp utility, what is the best way to take 32 DB's backups instead of taking each DB backup at a time??

Thanks in advance..

Report message to a moderator

Re: upgrade oracle 11.2.0.1 to 11.2.0.2 [message #553234 is a reply to message #553232]

Wed, 02 May 2012 11:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Currently, We are running oracle 11.2.0.1 on Linux server. There are 32 DB instances on this server.
32 is more than I have ever done.

>As per requirement, we need to install 11.2.0.2 DB on the same server.
please proceed to do so.

>Is it advisable to have both 11.2.0.1 and 11.2.0.2 databases on the same server with different ORACLE_HOME.
You have to do what you have to do.

>How about ORACLE_BASE??
I'd do a separate ORACLE_BASE.

>OR, do we need to upgrade all the DB's from 11.2.0.1 to 11.2.0.2. During the upgrade process,
>if i need to take backup with exp/imp utility,
most professional DBAs do not consider exp/imp to be a backup.

>what is the best way to take 32 DB's backups instead of taking each DB backup at a time??
do them in parallel & totally swamp the I/O subsystem

Report message to a moderator

Re: upgrade oracle 11.2.0.1 to 11.2.0.2 [message #553244 is a reply to message #553234]

Wed, 02 May 2012 12:36

dbarocks
Messages: 6
Registered: October 2011

Junior Member

Thanks BlackSwan for your kind reply..

[Updated on: Wed, 02 May 2012 12:37]

Report message to a moderator

Previous Topic:	information about maximum number of connection of a particular user
Next Topic:	how to get process information.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 02:27:58 CST 2024