Home » RDBMS Server » Server Administration » upgrade multiple databases of same oracle home from 11.2.0.1 to 11.2.0.3 (11g, 11.2.0.1, window7)
upgrade multiple databases of same oracle home from 11.2.0.1 to 11.2.0.3 [message #637041] Fri, 08 May 2015 03:58 Go to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear All,

Recently, same oracle home has multiple databases of version 11.2.0.1. We need to upgrade all the databases to 11.2.0.3 version.
Manually, we can upgrade database one by one. Is there any way to upgrade all the database in a single go?

Is there any way or has to do one by one? If you has any link then please share.

Regards,
Ashish Kumar Mahanta
Re: upgrade multiple databases of same oracle home from 11.2.0.1 to 11.2.0.3 [message #637042 is a reply to message #637041] Fri, 08 May 2015 04:46 Go to previous messageGo to next message
John Watson
Messages: 7618
Registered: January 2010
Location: Global Village
Senior Member
Think about the process you have to follow: install the new binaries to upgrade the instance, then run scripts against the data dictionary to upgrade the database. There is only one set of binaries (the Oracle Home) but each datbase has its oewn data dictionary. No way around it.

Incidentally, why 11.2.0.3? That drops out of premier support in a couple of months.
Re: upgrade multiple databases of same oracle home from 11.2.0.1 to 11.2.0.3 [message #637043 is a reply to message #637042] Fri, 08 May 2015 04:59 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear John,

Our production database is of version 11.2.0.3. To import stats in local databases which are of version 11.2.0.1, need to upgrade to 11.2.0.3.
We had done for single database of specific Oracle_home. Now, we had multiple databases of single oracle_home.

As you said - That drops out of premier support in a couple of months.


Do support to the version 11.2.0.3 is withdrawn? Still, we don't get any confirmation from oracle about it.

Regards,
Ashish Kumar Mahanta
Re: upgrade multiple databases of same oracle home from 11.2.0.1 to 11.2.0.3 [message #637044 is a reply to message #637043] Fri, 08 May 2015 05:08 Go to previous message
John Watson
Messages: 7618
Registered: January 2010
Location: Global Village
Senior Member
Just look at the relevant docs, starting with http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf that will show you that 11.2.x is ALREADY out of premier support and Doc ID 1942215.1 will tell you that the last patch for 11.2.0.3 will be July 2015.

So you are in a worse situation than I said. Better do something about it, hadn't you?
Previous Topic: Database upgradation
Next Topic: Wait Class - DB CPU
Goto Forum:
  


Current Time: Thu Oct 18 18:00:23 CDT 2018