| 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
|
|
|
|
| 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: 8964
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 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
