Tag: upgrade

How to Fix the Status of the Oracle GI CRS After a Failed Upgrade

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular post from the past. Today’s post was originally published on April 29, 2019. Blogger’s Note: The information in this…

Read More >

Overcoming ORA-01722 Error While Doing an Upgrade With Different DST Versions

This will be a short entry, but hopefully, it will help if you face the error “ORA-01722: invalid number” while doing an upgrade. Today I was doing an Oracle RDBMS upgrade from 12.2 with DST 34, to 19.7 with DST…

Read More >

Postgres Security Patches Related to the Search Path

There were some security patches released this month for Postgres, to put further restrictions on pathways that malicious users could use to leverage the search_path to insert malicious code. What is the search path? What is search_path? Postgres has a…

Read More >

Upgrading a Large Cassandra Cluster with cstar

I recently did an upgrade of 200+ nodes of Cassandra across multiple environments sitting behind multiple applications using the cstar tool. We chose the cstar tool because, out of all automation options, it has topology awareness specifically to Cassandra. Here…

Read More >

Why you should not uninstall Database Vault from a CDB

Now that we are fully into database upgrades, here is an important item to be aware of: As you may know, the Database Vault (DV) option could be reported as not installed in source when converting non-CDB to PDB, and…

Read More >

Stop Migrating Databases to 12c!

If you are starting an upgrade plan, do it directly to Oracle Database 19c. Why? Well, let’s agree that 19c is “equivalent” to 12.2.0.3 on previous version models, and 18c would be 12.2.0.2, after the latest in the old format:…

Read More >

Oracle database upgrade on RDS AWS and SPM baselines

A couple of days ago I saw a question posted online asking about how AWS upgrades an RDS Oracle database and what happens with SPM baselines. To be more precise whether the existing Oracle SPM baselines would survive the upgrade…

Read More >

DataStax OpsCenter upgrade (4.1 to 5.1) for Cassandra – issue and resolution

Yabin Meng, Datastax Enterprise and Apache Cassandra Consultant at Pythian, discusses the DataStax OpsCenter upgrade (4.1 to 5.1) for Cassandra.

Read More >

The end of an era – preparing for a SQL Server 2005 upgrade

Extended support for SQL Server 2005 will come to an end April 2016. This webinar provides a live demo on how to plan and perform a SQL Server 2005 upgrade

Read More >

Oracle upgrade failures due to METHOD_OPT and XDBCONFIG

Background I recently experienced a problem when upgrading an old Oracle 10.2.0.4 database to 11.2.0.4 that had no matches in a My Oracle Support (MOS) or Google search. The problem presented itself initially when upgrading as the following error was…

Read More >