Home » RDBMS Server » Server Administration » Database Upgrade - Minimum Disruption (Oracle Database 11.2.0.3 Windows 2008)
Database Upgrade - Minimum Disruption [message #683104] Thu, 03 December 2020 02:59 Go to next message
PebbleRock27
Messages: 2
Registered: October 2020
Junior Member
Hi all
We have a server with several Oracle databases and one listener. We need to upgrade just one of these databases with the minimum amount of downtime for the other databases. The database is current on 11.2.0.3 and will go to 11.2.0.4, two other databases are on this version.
What is the best approach here? We cannot change the application config so it will still need to remain on its current listener.
My background is MS SQL server and fell into accidental Oracle DBA area

thanks in advance Pebble

[Updated on: Thu, 03 December 2020 03:04]

Report message to a moderator

Re: Database Upgrade - Minimum Disruption [message #683120 is a reply to message #683104] Thu, 03 December 2020 16:04 Go to previous messageGo to next message
John Watson
Messages: 8576
Registered: January 2010
Location: Global Village
Senior Member
There is no reason why upgrading one database should have any effect on any other. One listener can enable connections to databases of both versions.
What you you are trying to do is not particularly difficult, just follow the documented upgrade procedure. And ask if something does not make sense to you.
Re: Database Upgrade - Minimum Disruption [message #683124 is a reply to message #683120] Fri, 04 December 2020 06:38 Go to previous message
gazzag
Messages: 1097
Registered: November 2010
Location: Bedwas, UK
Senior Member
How many Oracle homes do you have on this server? Does the same home service all four databases? What version are they all running?

HTH
-g
Previous Topic: ORA-24079:names with AQ$_ prefix are not valid for QUEUE_TABLE
Next Topic: DB Time spent nowhere in AWR
Goto Forum:
  


Current Time: Fri Jul 23 11:28:10 CDT 2021