Questions tagged [patching]
The patching tag has no usage guidance.
20
questions with no upvoted or accepted answers
4
votes
1
answer
7k
views
Oracle Database Server TNS Listener Remote Registration Vulnerability (CVE-2012-1675)
Some of our Internal DBs Oracle installed in Linux and Windows servers have been highlighted with the issue Oracle TNS Listener Remote Poisoning (CVE-2012-1675).
This security alert addresses the ...
- 41
2
votes
0
answers
22
views
What is the approach to handle failover and compatibility issues when patching FCI nodes?
I have FCI with 2 nodes.
Following is steps to patch the nodes:
Remove node from Possible owners
Patch the inactive node
Add the node to the Possible owners
Failover to inactive node
Leave it running ...
- 1
2
votes
1
answer
3k
views
How am I supposed to update PostgreSQL on Windows, once installed, without manually installing new installers?
I have PostgreSQL 11.5 installed on Windows 10. It was installed with the EnterpriseDB installer, which is the only one which exists these days.
If I go to https://www.postgresql.org/download/windows/...
- 37
2
votes
0
answers
206
views
Cannot apply patches to SQL Server 2016
I have a SQL Server 2016 instance version is SP1-GDR - 13.0.4202.2. I want to apply the Cumulative Update packages but they will not install. When you step through them, you cannot select any options ...
- 51
1
vote
0
answers
194
views
Has my repair fixed incomplete patching?
I am patching a SQL2008R2 Express Edition instance. On the first failed attempt, all seemed to be fine - SQL loaded, dbs online, @@VERSION returned the expected results, but errors were found during ...
- 369
1
vote
1
answer
3k
views
SQL Server updates missing from WSUS
I don't use WSUS for SQL Server patching because we have so many different compatibility issues, requirements and downtime OLA's that it makes it impossible to deploy anything in this way - not sure ...
- 1,774
1
vote
0
answers
3k
views
ORA-20013: DBMS_QOPATCH ran mostly in non install area
I have problems with patching p23054246_121020_Linux-x86-64 on an oracle database 12.1.0.2.0 on a Red Hat Enterprise 7.2. The patch installation seems to work but when I do the datapatch it fails:
-...
- 998
0
votes
0
answers
77
views
SSIS Database Always on AG and Patching
I am after clarification, when we patch a SQL Server Always on AG environment that has the SSIS database in the AG we remove the SSIS database, patch failover, patch and add the SSIS DB back into the ...
- 427
0
votes
0
answers
59
views
Cent OS update to postgresql13-contrib-13.9 causes error postgres_fdw.so undefined symbol: get_rel_all_updated_cols
I am running CentOS 7.9 and the latest OS updates caused and issue when updating the library postgresql13-contrib-13.9-1.
After that update when attempting to create postgres_fdw or use an existing ...
0
votes
1
answer
645
views
Oracle Patch 19.17 fails with: patch 34086870: Archive::Zip->writeToFileNamed returned 4
The current oracle patch 19.17 and OJVM was applied with opatch apply successfully with no errors.
Patch 34468114: WINDOWS DATABASE BUNDLE PATCH 19.17.0.0.221018
Patch 34411846: OJVM RELEASE UPDATE ...
- 998
0
votes
0
answers
107
views
Process for upgrading MySQL Master-Slave to a new release series version
I have several MySQL servers that I want to upgrade from 5.7.31 to the most recent release series (5.7.36 I believe), but in one test I found that replication on one server set failed, and it required ...
- 37
0
votes
0
answers
264
views
MariaDB upgrade fails on replication slaves
I am having problems when a MariaDB replication slave wants to upgrade its tables after a server was patched. This happens consistently with any sort of OS patching.
The system has several slave ...
- 101
0
votes
0
answers
97
views
What is the intended method for automatically/streamlinedly updating minor/patch PostgreSQL versions on Windows?
I currently run PostgreSQL 12.4 on Windows 10. Since the "BigSQL" distribution is no longer around, the only choice is to use the EnterpriseDB installer for the initial installation: https://...
- 287
0
votes
2
answers
6k
views
SQL Server Setup failure - Cached MSI files are missing
Trying to apply SQL Server 2008 SP4 to an old instance I now have to look after, but the installer is failing with
TITLE: SQL Server Setup failure.
SQL Server Setup has encountered the following error:...
0
votes
0
answers
206
views
Oracle 12cR2 - Upgrade Catalog Command Taking Too Much Time
I patched my database (Windows database bundle patch 12.2.0.1.201020 (31654782)).
There are 6 instances on the server. After the patch, the UPGRADE CATALOG command I ran on RMAN for the first 5 ...
- 29
0
votes
0
answers
36
views
Cumulative Update 3 & 4 Caused Synchronous Commit Failures in Availability Groups
So this week I was patching our SQL Servers that host our availability groups. Never had an issue with them in the past, fairly standard process. I have two servers (call them SQL1 and SQL2) in the ...
0
votes
0
answers
611
views
Should I install all cumulative updates/service packs when doing a clean install of SQL Server 2016? 2019?
Going to set up a new database instance from scratch. Debating between SQL Server 2016 and 2019.
I've never installed a service pack or cumulative update on previous instances, mostly because ...
- 123
0
votes
1
answer
97
views
Do we need to shutdown DB/Stop DB service before Windows server patching
Before patching Windows server, do we need to shut down any DB or stop DB service.
If we need to shutdown a MongoDB on a node(Windows server) which is part of a replica set, what we need to before ...
- 11
0
votes
2
answers
35
views
SQL 2008 Version Number Question
When I run the SQL Server 2008 Setup Discovery Report, all of the components (Database Engine Services, Management Tools - Complete, etc) show as version 10.3.5852.0.
However, I cannot find any ...
- 73
0
votes
0
answers
446
views
How do I create a oracle database patch list overview?
I need to create an list for Oracle database patch versions for a recurring audit on patch states. It will check whether the current patch state of Oracle database meets the required patch state of a ...
- 998