Infrastructure at your Service

Tag

Patching Archives - Blog dbi services

Jérôme Dubar

Patching or reimaging your ODA?

By | Database Administration & Monitoring, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction One of the key features of the ODA (Oracle Database Appliance) is the ability to patch the entire stack every three months, the goal being to keep all the components up-to-date. Most of the customers won’t patch so often, but one patch a year is quite a good average. But when comes the time for patching, comes the time for anxiety for the DBA. And it’s totally justified. Why ODA patching can eventually be…

Read More
Jérôme Dubar

Reimaging an old X3-2/X4-2 ODA

By | Database Administration & Monitoring, Oracle | One Comment

Introduction X3-2 and X4-2 ODAs are still very capable pieces of hardware in 2018. With 256GB of RAM and at least 16 cores per node, and with 18TB RAW disk capacity as a standard these appliances are far from obsolete even you probably don’t have any more support on the hardware from Oracle. If you own several ODAs of this kind, hardware support may not really be a problem. If something fails, you can use…

Read More
Stéphane Haby

SQL Server 2016: patching CU with R Services

By | Database Administration & Monitoring, Database management | No Comments

As a good DBA, I begin to be up to date with all Cumulative Update (CU) by my customers. It is the first time that I run an update for SQL Server 2016 with the CU 3. I download the CU on Microsoft website and I begin my patching campaign on all SQL server 2016 instances. The first one is quick & successful. The second one, with R Services, is a little bit different. After,…

Read More
Daniel Westermann

How to patch Postgres Plus Advanced Server in a Standby configuration

By | Database Administration & Monitoring | No Comments

In the last post we looked at how you can patch a Postgres Plus Advanced server. Wouldn’t it be nice, in a standby configuration, to patch the standby first without touching the master, then do a controlled switchover and finally patch the old master? In case this is a configuration with EDB Failover Manager the only downtime which would happen is the relocation of the VIP from one node to another (if you use a…

Read More
Daniel Westermann

How to patch Postgres Plus Advanced Server

By | Database Administration & Monitoring | 2 Comments

As with any other software there comes the time when you need to patch your Postgres Plus Advanced Server instances. Is that different from patching Community PostgreSQL? Yes and no 🙂 The difference is that you need a subscription to get access to the EDB Customer Portal for being able to download the patch. This is pretty much the same as with My Oracle Support where you need a customer support identifier mapped to your…

Read More
Stéphane Haby

SQL Server: Now Cumulative Updates (CU) need to be install!

By | Database Administration & Monitoring | No Comments

 Since this year, Microsoft recommends to install Cumulative Updates (CU) like Service Packs (SP) In the past, Microsoft always recommended to apply the Service Packs and security fixes for SQL Server. Cumulative Updates were applied only if you had a specific problem in order to resolve it. Now, we need to follow a new rule: “ Microsoft recommends ongoing, proactive installation of SQL Server CUs as they become available: SQL Server CUs are certified to…

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
Daniel Westermann

Patching PostgreSQL to a new minor release

By | Database Administration & Monitoring | 3 Comments

If you are used to patch Oracle databases you probably know how to use opatch to apply PSUs. How does PostgreSQL handle this? Do we need to patch the existing binaries to apply security fixes? The answer is: No. Lets say you want to patch PostgreSQL from version 9.4.1 to version 9.4.5. What do you need to do? For this little demo I’ll create a new database and a sample table in my 9.4.1 instance:…

Read More
Oracle Team

Oracle OPatch and “Archive not applied” error

By | Database management | One Comment

Recently, I have installed an Oracle 11.2.0.4 RDBMS on a server, and I wanted to install the latest Patch Set Update (PSU) 11.2.0.4.4 from October 2014. During the execution, I fell on the error “Archive not applied” and the job failed. This is how to quickly fix this issue. While installing the PSU 11.2.0.4.4 from October 2014 on my Oracle 11.2.0.4 database server, I experienced the following error: The following actions have failed: Archive not…

Read More
Pierre Sicot

Oracle OEM Cloud Control 12.1.0.4 – agent upgrade & patch

By | Database management | No Comments

The new Oracle OEM Cloud Control 12.1.0.4 release migration makes it necessary for the DBA to migrate the old agent version to 12.1.0.4. If your infrastructure has a huge number of agents and if you want to apply the agent patches to the upgraded agents, this might be a very time-consuming job. However, there is a way to realize the operation in just one shot. In my example, we have an agent in version 12.1.0.3:…

Read More