No question at this time
DBA Top 10
1 A. Kavsek 12200
2 M. Cadot 7000
3 P. Wisse 5600
4 B. Vroman 5400
5 J. Péran 1900
6 . Lauri 1500
7 T. P 500
7 R. Pattyn 500
9 T. Boles 400
10 A. Chavan 300
10 J. Schnackenberg 300
10 D. Johnson 300
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48454
Total active users1499
Act. users last 24h5
Act. users last hour0
Registered user hits last week216
Registered user hits last month950
Go up

Oracle upgrade
Next thread: CPU usage measured using top on Linux
Prev thread: AWR report from or not from PDB

Message Score Author Date
Hi I am planning to upgrade our database server...... James Alcroft Aug 20, 2019, 22:48
Hi James, the proper answer to this question is...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Ales Kavsek Aug 21, 2019, 09:40
Thanks Ales This is what I thought, was just ho...... James Alcroft Aug 21, 2019, 10:10
Hi Ales and James, I was wondering something. O...... Joël Péran Aug 23, 2019, 09:50
Hi Joel I did a test migration on a copy of one...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts James Alcroft Aug 23, 2019, 10:09
Hi James, ...just one more thing... > I am p...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Ales Kavsek Aug 23, 2019, 12:39
Hi Ales, As usual, what you say is always in...... Joël Péran Aug 26, 2019, 07:50
Hi Joël, no worries for non-cdb & 19c, only aft...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Ales Kavsek Aug 26, 2019, 22:51
Hi Ales Completely agree ! Without new HW, I...... Joël Péran Aug 27, 2019, 07:47

Follow up by mail Click here


Subject: Oracle upgrade
Author: James Alcroft, United Kingdom
Date: Aug 20, 2019, 22:48, 91 days ago
Os info: Win 2012
Oracle info: 12.1 upgrade to 12.2
Message: Hi

I am planning to upgrade our database servers from 12.1 to 12.2. Also thinking of applying the July (2019) quarterly patch - no other reason really than I may as well get to the latest version and patch of 12.2

My question, do I install Oracle 12.2, then apply the software patch, then using the database upgrade utility i upgrade the database. When doing this, do I also need to run the datapatch for the July patch or do i have to run this manually after the database upgrade.

Really querying if the upgrade utility will do everything for me or not.

Many thanks.

James
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Oracle upgrade
Author: Ales Kavsek, Slovenia
Date: Aug 21, 2019, 09:40, 90 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi James,

the proper answer to this question is: always follow the instructions in the README.html that comes with a patch, quote from July 2019 CPU:

3.4 Patch Post-Installation Instructions for Databases Created or Upgraded after Installation of BP 12.2.0.1.190716 in the Oracle Home

You must execute the steps in Section 3.3.1, "Loading Modified SQL Files into the Database" for any new or upgraded database.

Regards,
Ales



Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Oracle upgrade
Author: James Alcroft, United Kingdom
Date: Aug 21, 2019, 10:10, 90 days ago
Message: Thanks Ales

This is what I thought, was just hoping i could get away with one process.

James
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Oracle upgrade
Author: Joël Péran, France
Date: Aug 23, 2019, 09:50, 88 days ago
Message: Hi Ales and James,

I was wondering something. Our databases are all on 12.1 version, without the pluggable database feature (we did not have time for both). Unfortunately, I thought that this feature was only possible in 12.1 and not 12.2. But in fact, like a lot of people (as far as I could see), we were mistaken and we could have migrate directly in 12.2.
The process we used to migrate from 11.2 to 12.1 was to have duplicate servers, one in 11.2 and the other in 12.1, then shutdown the 11g database, copy the databases datas from one to the other and the migrate the database. In case of any problem, we could easily roll back, by starting up the 11g database.
Now we can't do this anymore. The only solution would be to install 12.2 engine on the same server and migrate every database in one time. But we have about 6 to 8 databases on each servers (four nodes clusters, 30 databases in all).
My question is ... well my questions are :)
- how many time do you think it would take to migrate a database from 12.1 to 12.2 (standalone mode, not pdb)
- what would you do to easily migrate the databases with the minimum risks ?

Thanks for you answers :)

Regards,
Joel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Oracle upgrade
Author: James Alcroft, United Kingdom
Date: Aug 23, 2019, 10:09, 88 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi Joel

I did a test migration on a copy of one of our production servers. You would think the size of the database would come into the equation, but i don't think it does. My timings were

production size 380Gb took 2hr 5 minutes
validation size 180Gb took 1hr 40 minutes
analystic database size 10Gb took 1hr 30 minutes

This server was a VM, when i do this for real it is my intention to take a snapshot of the server first. Every migration that I have done for testing has gone through without any issues,so i am confident that the Oracle migration process work well.

Install Oracle 12.2 in a completely new folder, this will allow you keep the databases running on 12.1 until you can migrate it to 12.2, you don't have to migrate them all on the same day. I only have 12 databases to migrate, and i am doing them over a 6 week period - already done the internal validation databases, next week test databases to allow customers to test, and the production databases in three weeks time.

Hope this helps - happy to be corrected.

James
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Oracle upgrade
Author: Ales Kavsek, Slovenia
Date: Aug 23, 2019, 12:39, 88 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi James,

...just one more thing...

> I am planning to upgrade our database servers from 12.1 to 12.2

I hope you're talking about 12.2.0.3 (19c)? Upgrading to 12.2.0.1 or 12.2.0.2 (18c), doesn't make any sense considering that 19c is a long term supported version (in old terminology, 12.2.0.3 is a final patchset).

Regards,
Ales
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Oracle upgrade
Author: Joël Péran, France
Date: Aug 26, 2019, 07:50, 86 days ago
Message: Hi Ales,

As usual, what you say is always interesting :) !
12.2.0.3, I notice this version but I'm sure that it does only allow pluggable databases and not "standalone" databases like in 11g ?
And btw I can't do what Jim is doing because our databases are located on clusters node (not RAC but ordinary Windows clusters). We are also using Failsafe and I don't think that kind of architecture allows the use of different Oracle versions at the same time ...
Unfortunately, without "money" and spare servers, I may be stuck ... Migrating all the database in one day is not really convenient ... From 11g to 12c, it took about 40 minutes for each database ...
But fingers are kept crossed in case someone has a great idea :)
Regards,
Joel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Oracle upgrade
Author: Ales Kavsek, Slovenia
Date: Aug 26, 2019, 22:51, 85 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi Joël,

no worries for non-cdb & 19c, only after 19c there is a chance that Oracle will remove non-cdb, standalone database as an option (within 12.2 non-cdb is only deprecated, but still fully supported).
After reading about your existing configuration, I would be reluctant to upgrade in place on the same hardware. Way too many things can go wrong.
Definitely try to get new HW and try to migrate from non-cdb to cdb installation, even if you go with the strategy, that you migrate some db’s to a single-tenant cdb (perhaps for some legal reason) and some to true multitenant cdb.

Regards,
Ales
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Oracle upgrade
Author: Joël Péran, France
Date: Aug 27, 2019, 07:47, 85 days ago
Message: Hi Ales

Completely agree ! Without new HW, I am not really keen on migrating. We will have to study the ability to use PDB database (multi tenant has an impact on license ? It would be useful for some of our applications, and nonsense for others. Thanks for your advice !!!
Regards,
Joel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here