Home » RDBMS Server » Server Administration » upgrade oracle 11.2.0.1 to 11.2.0.2 (oracle 11g, Linux)
upgrade oracle 11.2.0.1 to 11.2.0.2 [message #553232] Wed, 02 May 2012 10:56 Go to next message
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..



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 Go to previous messageGo to next message
BlackSwan
Messages: 26763
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
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 Go to previous message
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:
  


Current Time: Wed Apr 14 18:08:55 CDT 2021