Infrastructure at your Service

Tag

Upgrade Archives - Page 3 of 4 - Blog dbi services

Oracle Team

12cR2: Upgrade by remote clone – workaround ORA-17630 in DBaaS

By | Database Administration & Monitoring | 2 Comments

By Franck Pachot . Easier than unplug/plug, you can move pluggable databases with remote cloning. It’s the same idea but you don’t have to manage the files yourself: the are shipped through database link. However, this uses the ‘remote file protocol’ and it fails with version mismatch: ORA-17628: Oracle error 17630 returned by remote Oracle server ORA-17630: Mismatch in the remote file protocol version client server

Read More
Oracle Team

12cR2: How long to upgrade a PDB?

By | Database Administration & Monitoring | No Comments

By Franck Pachot . In the previous post I described how simple it is to unplug a PDB and plug it into a newer version CDB. One goal of dictionary separation in the multitenant architecture is to keep system objects on CDB$ROOT only. Knowing that an upgrade does not touch the application metadata and data, does this make PDB upgrade fast as a simple refresh of metadata links?

Read More
Middleware Team

Upgrading to 7.2 created a new ACS. How to remove it and test it?

By | Application integration & Middleware | One Comment

I had this strange behavior that once upgraded from 6.7 to 7.2 a new ACS was created. I think it’s because the current ACS name didn’t fit the new ACS name pattern. Well it’s not a big issue to have 2 ACS configured. But in my case they pointed both to the same port and servlet so… I had to remove one. Hence, how can we know which one is used? That’s easy, just find…

Read More
Oracle Team

Question is: upgrade now to 12.1.0.2 or wait for 12.2 ?

By | Database Administration & Monitoring | 8 Comments

By Franck Pachot . Let’s look at Release Schedule of Current Database Releases (Doc ID 742060.1) 12.2.0.1 is planned for 2HCY2016 on platforms Linux x86-64, Oracle Solaris SPARC (64-bit), Oracle Solaris x86-64 (64-bit). 2HCY2016 starts next week but we can imagine that it will not be released immediately and anyway we will have to wait a few months to download the on-premise(s) version. Add another couple of months to get at least one Proactive Bundle…

Read More
Daniel Westermann

A near zero downtime, near zero impact major release upgrade using Oracle GoldenGate

By | Database Administration & Monitoring | No Comments

In this post I’d like to share what we did for a customer who had the following requirements: Use Oracle GoldenGate Upgrade an Oracle 10.2.0.4 database running on Solaris 10 SPARC to Oracle 12.1.0.2 running on Exadata Keep the downtime as small as possible Minimize the impact on the production database as much as possible I will not describe why GoldenGate was the product of choice nor will I describe how we verified that Golgengate…

Read More
Morgan Patou

Alfresco: upgrade your version of Apache Tomcat

By | Application integration & Middleware | No Comments

Different versions of Alfresco can be installed with different versions of Tomcat. Alfresco provide a default version with its installer but when installing Alfresco manually, an administrator can choose to install Alfresco using a different version of Apache Tomcat. Usually, each version of Alfresco is officially supported for only one specific version of Apache Tomcat and that’s fine for some use cases but I think that most Alfresco administrators will not follow this specific recommendation,…

Read More
Daniel Westermann

Upgrading PostgreSQL to a new major release

By | Database Administration & Monitoring | No Comments

The last post looked into how to upgrade PostgreSQL to a new minor version. In this post I’ll look into how to upgrade PostgreSQL to a new major version. This is not as simple as just installing the binaries and start the instance from there. For major upgrades there are two possibilities: dump the old version and restore into the new version by using pg_dump and pg_restore use pg_upgrade I’ll only look into pg_upgrade for…

Read More
Oracle Team

Oracle Cloud Control 12c: removing an agent is much easier in OEM 12.1.0.4

By | Database management | 18 Comments

To remove an agent in the previous Oracle OEM Cloud Control 12c versions, you first had to delete its targets, stop the agent, and remove the host target. Only then were you able to remove the agent. In version 12.1.0.4, the decommission agent feature has been greatly improved. From the agent menu, you select the new feature Agent Decommission: The agent must be in stopped status to be decommissioned: It shows the targets which will…

Read More