Home » RDBMS Server » Server Administration » Oracle DB Upgrade Clarification (Oracle 11.1.0.7 Enterprise Edition, AIX 6.1)
Oracle DB Upgrade Clarification [message #680253] Fri, 01 May 2020 01:34 Go to next message
jesuisantony
Messages: 158
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 #680269 is a reply to message #680253] Fri, 01 May 2020 08:20 Go to previous messageGo to next message
EdStevens
Messages: 1228
Registered: September 2013
Senior Member
What are you quoting from?
What is it that you don't understand?
What is your alternative to an 'in place' upgrade?
I don't even know what a 'parallel" upgrade is .... never heard of it.
Re: Oracle DB Upgrade Clarification [message #680276 is a reply to message #680253] Sat, 02 May 2020 04:50 Go to previous messageGo to next message
John Watson
Messages: 8309
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 Go to previous messageGo to next message
jesuisantony
Messages: 158
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 Go to previous message
jesuisantony
Messages: 158
Registered: July 2006
Location: Chennai
Senior Member
John Watson wrote on Sat, 02 May 2020 04:50
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.
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.

Previous Topic: open cursor parameter exceeds but no alarm have been raised
Next Topic: how to verify gather schema statistics
Goto Forum:
  


Current Time: Tue Aug 04 00:40:47 CDT 2020