OraFAQ Forum: Server Administration » upgrade multiple databases of same oracle home from 11.2.0.1 to 11.2.0.3

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)

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

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

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

Report message to a moderator

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

John Watson
Messages: 8974
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.

Report message to a moderator

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

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.

Code: [Select all] [Show/ hide]

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

Report message to a moderator

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

John Watson
Messages: 8974
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?

Report message to a moderator

Previous Topic:	Database upgradation
Next Topic:	Wait Class - DB CPU

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 06:01:17 CDT 2025