Infrastructure at your Service

Upgrade Archives - Blog dbi services

Mouhamadou Diaw

Upgrade to Oracle 12.2 with dbupgrade utility

By | Database Administration & Monitoring | No Comments

Oracle 12.2 is released and we will have to upgrade. And in this blog we are going to talk about upgrading to oracle 12.2 using the dbupgrade utility. Of course the dbua tool is still available and can be also used. Oracle Database 12.1 introduced the Parallel Upgrade Utility, catctl.pl. This utility reduces the total amount of time it takes to perform an upgrade by loading the database dictionary in parallel, and by using multiple…

 
Read More
Franck Pachot

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

By | Database Administration & Monitoring | No Comments

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
Stephane Biehler

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
Franck Pachot

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

By | Database Administration & Monitoring | 8 Comments

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 Patch to stabilize that…

 
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