| Oracle DB Upgrade Clarification [message #680253] |
Fri, 01 May 2020 01:34  |
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
|
Senior Member |
|
|
Our current JDE supporting DB runs on 11.1.0.7. There is a plan to upgrade to 12c.
Quote:
Phase 1: Upgrade from 11.1.0.7 to 11.2.0.4 (In-Place upgrade with an existing OS AIX 6.1)
Phase 2: Upgrade from 11.2.0.4 to 12c (In-Place upgrade after OS upgrade to AIX 7.1)
We would like to understand the recommendations on the upgrade activity. As well, the Pros and Cons of doing an In-place upgrade and the parallel upgrade on new server with AIX 7.1
|
|
|
|
|
|
| Re: Oracle DB Upgrade Clarification [message #680276 is a reply to message #680253] |
Sat, 02 May 2020 04:50  |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
I would not do it the way you are suggesting. My approach would be
1. Install and patch a 12.1.0.2 home
2. Upgrade the 11.1.0.7 DB to 12.1.0.2
3. Install and patch a 19c home
4. Create a CDB
5. Plug in the 12.1.0.2 DB
6. Upgrade the PDB to 19c
All done in-place, perhaps half a day of downtime for steps 2, 5, and 6. You have to convert to multitenant some time, you will never have a better opportunity.
|
|
|
|
| Re: Oracle DB Upgrade Clarification [message #680341 is a reply to message #680269] |
Fri, 08 May 2020 03:06 |
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
|
Senior Member |
|
|
Phase 1: Upgrade from 11.1.0.7 to 11.2.0.4 (In-Place upgrade with an existing OS AIX 6.1)
Phase 2: Upgrade from 11.2.0.4 to 12c (In-Place upgrade after OS upgrade to AIX 7.1)
Parallel Upgrade:
=================
When I said Parallel upgrade, I was trying to mention that, a new server with the higher OS version will be built, fresh installation of Oracle 11.2.0.4 will be done on the new server. And DB be will be restored to the new server.
In-Place Upgrade:
=================
On the existing server, the OS will be upgraded. The Oracle 11.2.0.4 will be installed on that. The existing DB will be upgraded using the upgrade scripts.
We are going in 2-phases because there is an application dependency and upgrade as well. And that is our requirement.
Parallel Upgrade brings the pain of additional hardware or resourcing procurement leading to additional cost. But with the in-place upgrade, we will just overwrite the DB with upgrade scripts. And rollback could be a challenge in case of an unexpected issue in the upgrade.
Trying to understand the good practice, the pros and cons of the 2 methods.
|
|
|
|
| Re: Oracle DB Upgrade Clarification [message #680342 is a reply to message #680276] |
Fri, 08 May 2020 03:10 |
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
|
Senior Member |
|
|
John Watson wrote on Sat, 02 May 2020 04:50I would not do it the way you are suggesting. My approach would be
1. Install and patch a 12.1.0.2 home
2. Upgrade the 11.1.0.7 DB to 12.1.0.2
3. Install and patch a 19c home
4. Create a CDB
5. Plug in the 12.1.0.2 DB
6. Upgrade the PDB to 19c
All done in-place, perhaps half a day of downtime for steps 2, 5, and 6. You have to convert to multitenant some time, you will never have a better opportunity.
Thanks for the input. We are in a situation and the application requirement to go with 11.2.0.4 requirement as part of phase 1 and then to 12c as part of phase 2. And the current DB size is 7TB.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
