No question at this time
DBA Top 10
1 M. Cadot 10800
2 A. Kavsek 10100
3 B. Vroman 4800
4 P. Wisse 4200
5 J. Schnackenberg 2900
6 J. Péran 2000
7 . Lauri 1000
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
9 T. Boles 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48518
Total active users1427
Act. users last 24h3
Act. users last hour0
Registered user hits last week177
Registered user hits last month765
Go up

Multiple Oracle versions in the same Windows Cluster
Next thread: syntax hint
Prev thread: AWR report information

Message Score Author Date
Hi everyone, I am currently working on a mig...... Joël Péran Jun 25, 2020, 15:00
Hi Joel, Yes, you can have multiple Oracle vers...... Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts Philip Wisse Jun 25, 2020, 16:10
Thanks Philip for your quick reply. But you have n...... Joël Péran Jun 26, 2020, 10:16

Follow up by mail Click here


Subject: Multiple Oracle versions in the same Windows Cluster
Author: Joël Péran, France
Date: Jun 25, 2020, 15:00, 14 days ago
Os info: Windows Server 2K16
Oracle info: 12.1.0.2 and 19c
Message: Hi everyone,

I am currently working on a migration project. We want to migrate our 12.1.0.2 databases (non CDB) to non CDB 19c.
When we had money, we could use new servers with a cluster architecture during the 12c migration project. We had 11g Oracle Windows Cluster servers and we were simply copying the database files to new disks, on the new architecture with the 12c oracle engine, and then just migrate the database. And in case something was wrong, we just had to shutdown the 12c non functional database and start the old 11g database, and the production applications were working.
Now, we don't have enough money to have spare servers/clusters ... So my question is : can we have multiple oracle versions on the same cluster and then be allowed to migrate 12c database to 19c. We have approximatively 6 or more databases on each nodes, and we can't migrate all the database at the same time (though that the new migration tool from Oracle, autoupgrade, is allowing us to migrate multiple databases at once).
Btw, I have attended some virtual classrooms sessions with Mike Dietrich from Oracle, and it's very, very very interesting :)

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

Subject: Re: Multiple Oracle versions in the same Windows Cluster
Author: Philip Wisse, Netherlands
Date: Jun 25, 2020, 16:10, 14 days ago
Score:   Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts
Message: Hi Joel,

Yes, you can have multiple Oracle versions on the same server.

Just remember a database is connected to an oracle_home with:
password file
init.ora file / spfile
listener
oradim service
You can move these connections one by one to the new oracle_home and subsequently start the upgrade process.

Before anything take a cold backup, just to play it safe.

Advice is to reduce the size of SYSAUX first.

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

Subject: Re: Multiple Oracle versions in the same Windows Cluster
Author: Joël Péran, France
Date: Jun 26, 2020, 10:16, 13 days ago
Message: Thanks Philip for your quick reply. But you have noticed that I was talking about a windows cluster so the mechanism of the cluster can deal with different versions of Oracle at the same time ? (I guess yes, because you are right, all you need to have is a password file, an init.ora (mandatory regarding a windows cluster), a listener and a oradim service dealing with the right ORACLE_HOME¨). That should do the trick :) I will tell you about the results when I'm ready to test it.
Regards,
Joel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here