Questions tagged [patching]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
38 views

Un-Install OS Patch (KBs) in Physical PRODUCTION Servers - Consequences [closed]

We have our PRODUCTION Database and Application Servers which are Physical Servers . Recently , the October month OS Patches (specific KBs) are little problematic and reported by Microsoft too that ...
2
votes
2answers
2k views

Error after applying SQL Server 2008 R2 Upgrade 10.50.6542 (Latest Build)

First the problem: Since I applied the latest patch to SQL Server 2008 R2 (released on March 3, 2016) that should have taken my server to build 10.50.6542 I can't connect anymore. This patch is to ...
2
votes
0answers
93 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 ...
3
votes
1answer
1k views

Uninstall SQL Patch with SkipRules

I've recently installed Cumulative Update 6 for SQL Server 2014 SP2. I installed it on the passive node of a 2 node cluster. To install the patches I paused the role in cluster manager and ran the ...
4
votes
2answers
3k views

Automate the patching of SQL Severs on Windows

We are getting approximately 50-100 lower environments SQL Servers newly build. We are assigned some basic task of SQL DBA which includes one as patching SQL Servers. How can this be achieved, ...
0
votes
1answer
225 views

Oracle CPU vulnerabilities and Database Proactive Bundle Patch

I've applied the latest Oracle 12c Database Proactive Bundle Patch (DBBP). My security team runs scans and April 2015 CPU (amongst other CPUs) continues to show up as vulnerabilities. I need to ...
0
votes
1answer
1k views

Datapatch -verbose fails with erros

After succsessfuly doing the opatch apply for Oracle Patch Apr 2017, datapatch Fails with the following error: D:\oracle\cfgtoollogs\sqlpatch\sqlpatch_4540_2017_07_07_22_18_44 MOS Note 1609718.1 D:\...
0
votes
1answer
7k views

Oracle 12c Opatch failed with error code 73

I don't find a solution for the following Opatch Error: D:\oracle\product\12.1.0\dbhome_1\cfgtoollogs\opatch\opatch2017-07-05_22-29-53PM_1.log 05.07.2017 22:29:53] OPatch invoked as follows: '...
0
votes
1answer
29 views

Will OS Patching affect the SQLLOG file Growth in SQL Server

Last Sunday we have the OS Patch for the month of June. Can someone help me understand if the monthly OS patching increases the SQLLOG file in SQL Server ? Is there any linkage between the OS Patch ...
5
votes
2answers
6k views

What is the different between GDR security update and CU security update

What is the different between GDR security update and CU security update? I am looking to understand difference between the below two updates. If I apply KB3194724, would it also include KB 3194721? ...
1
vote
2answers
427 views

CU Update to Sql Server 2014 hangs for 7 hours

How to improve time for patching installs? Applying patches on test Hyper-V VM's prior to production patching. It is a two node Always-On AG. From Detail.txt when I let it run: (01) 2017-04-26 15:...
1
vote
1answer
582 views

SQL Server 2008 Patch on Clustered Server

I am patching SQL server, going from SP1 to SP3, on a cluster while following Microsoft's instructions on how to do it. Every single place I read tells me to do the following: Pause the passive ...
0
votes
2answers
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 ...
1
vote
1answer
1k views

SQL Server Service Pack Questions

We are currently running our database server on SQL Server RTM; i.e. no service packs or cumulative updates have been installed. We need to install the latest Service Pack for SQL Server. I had the ...
1
vote
1answer
861 views

Remove a SQL Server Patch only visible in View Installed Update List

Kindly help me regarding our issue with a Clustered Environment's applied patch. The situation is: We removed a SQL Patch: GDR 6248 for SQL Server 2012 (KB3194721) (64 bit). When we successfully ...
1
vote
4answers
2k views

How often to update SQL Server? [duplicate]

I am a new DBA at a company that has never had a DBA before me. SQL Servers are never upgraded unless it is part of a Windows Update on the server. Service Packs (or CUs) are never installed. We have ...
2
votes
1answer
686 views

Installing service packs with SQL Server services stopped

I always installed Service Packs on the servers with running SQL Server Services. This time I am faced with the situation where I have to patch multi-instance SQL Server that has its services stopped ...
0
votes
1answer
2k 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 ...
7
votes
3answers
1k views

How far to go when Validating a SQL Service Pack install?

When applying a Service Pack to a production SQL server, I usually have a planned downtime window of around 30 minutes. Having been bitten before, and discovering that a required precondition like ...
1
vote
0answers
2k 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: -...
2
votes
1answer
752 views

SQL Server 2014 (12.0.4439.1) to SP2 (12.5000) service start failure

In what seems to be eerily familiar to the oh-so-famous SSISDB SP1 fiasco, I've hit a snag while upgrading our DEV server to SQL 2014 SP2. The base version was SP1+CU5 (12.0.4439.1). We have SSISDB ...
7
votes
1answer
4k views

What are the “GDR” vs “QFE” hotfixes for SQL Server 2008 R2 SP3?

I'd always assumed that higher patch numbers were necessarily later releases, but now I'm not so sure. Looking at the SQL Server Build List for SQL Server 2008 R2 SP3, there are two possible ways to ...
0
votes
1answer
630 views

SQL Server 2012 Patching Service Pack and CU Question

I am tasked with updating a SQL Server 2012 from a version(11.0.5623.0) before SP3 all the way to SP3 CU2. Can I install both patches without a reboot until afterwards? All the documents I have found ...
4
votes
3answers
3k views

patching SQL Server with Availability Group and Secondary Replica

Scenario: SQL Server 2014 CU6. 1 AG with 2 databases (compatibility level 100). Failover Cluster with 3 nodes on Windows Server 2012 R2. Primary Availability Replica on node 1 and node 2. Secondary ...
0
votes
0answers
421 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 ...
3
votes
1answer
414 views

Apply SQLServer Service Pack to a Single Node Cluster

I have to apply a SQL Server 2008 R2 Service Pack to a Single Node Cluster. The other node died and new hardware has been ordered. Is there anything weird to worry about? Normally we'd apply the ...
0
votes
1answer
103 views

Patching SQL Server 2012

If I apply Cumulative Update 3 in SQL Server 2012 SP1, do I still have to do Cumulative update 1 and 2 before I can apply CU 3? And also, how would you know what CU's or hot fixes that has already ...
0
votes
1answer
755 views

Pointing DB to new Oracle home in primary and standby oracle database

I needed to apply a security patch to production database. To minimize the outage time, I cloned the oracle home and applied the patch to this newly created oracle home. With production DB there is a ...
4
votes
2answers
1k views

Patching strategy when Windows and SQL Server patches not applied for over 3 years

The company I'm at hasn't patched their production servers for a while, neither SQL 2012 or Windows 2012. When I say "for a while" I mean, well, actually "never" - no patches or updates since the ...

1
2