Posts

How to Rename SQL Server Network Name (Virtual Server Name) in SQL Server 2019 Failover Cluster Instance (FCI).

Image
In SQL Server Failover Cluster Instance (FCI), the SQL Server Network Name (also called the Virtual Server Name) is what applications and users use to connect. Sometimes, we may need to rename to match new naming standards or after a migration. This blog explains the recommended way to rename the SQL Server Network Name in SQL Server 2019 FCI, along with key points to check after the change. Environment details: Component Name Version Purpose Node 1 sql01-chn.corp.local Windows Server 2019 First cluster server Node 2 sql02-chn.corp.local Windows Server 2019 Second cluster server Cluster Name WINSQLPRD01   Windows failover cluster name SQL Network Name Before: CHNSQLVS01-MIG After: CHNSQLVS01 SQL Server 2019 Name used by applications to connect ...
Post a Comment
Read more

OEM 13cR5 Host IP Change and Repository Database 19c Migration to Another Datacenter via Data Guard Failover

Image
This blog outlines the high-level steps taken to execute two major Oracle Enterprise Manager (OEM) infrastructure changes with minimal downtime to monitoring continuity. Change the IP address of the OEM 13cR5 host server. Migrate the OEM repository database (Oracle 19c) to secondary datacenter using Data Guard failover. Environment details: Component CMO (Current Mode of Operation) FMO (Future Mode of Operation / Post-Migration) OS Oracle Linux 8 (All Nodes) Oracle Linux 8 (All Nodes) OEM Installation Host/IP dbsrv09.localdomain / 192.168.56.110 dbsrv09.localdomain / 192.168.56.109 OEM Version 13c Release 5 (13.5.0.0.0) 13c Release 5 (13.5.0.0.0) Repository DB Node (Primary) dbsrv05.localdomain dbsrv06.localdomain (Post Data Guard Failover) Repository DB Node (Standby) dbsrv06.localdomain ...
Post a Comment
Read more