OraFAQ Forum: Server Administration » Oracle DB Upgrade Clarification

Home » RDBMS Server » Server Administration » Oracle DB Upgrade Clarification (Oracle 11.1.0.7 Enterprise Edition, AIX 6.1)

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

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

Report message to a moderator

Re: Oracle DB Upgrade Clarification [message #680269 is a reply to message #680253]

Fri, 01 May 2020 08:20

EdStevens
Messages: 1376
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.

Report message to a moderator

Re: Oracle DB Upgrade Clarification [message #680276 is a reply to message #680253]

Sat, 02 May 2020 04:50

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

Report message to a moderator

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.

Report message to a moderator

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: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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 16:55:28 CDT 2025