i want to uninstall SQL 2012 passive server from VCS cluster which is configured in HA
HI Team, In my environment i have SQL 2012 server in active and passive mode. This is configured in VCS cluster in HA. Last night I have some issue in Passive node now i want uninstall SQL 2012 server from passive node. Does anyone know what steps I need to take to Un-Install SQL Server 2012 from the passive node and then re-install with the right configurationSolved972Views0likes4CommentsAre we monitoring the right object?
Just some quick questions. We use Veritas Clustering for providing an HA solution for database servers. We have set up the vcs montoring to try to connect to the database every 3 minutes. After 4 attempts the VCS kills the primary pid and fails over to the other side. The box is self is fine, just vcs was unable to connect for whatever reason. The theory is that if the database is unresponsive for 12 minutes it must be in a hung state. Correctly or not, there are many reasons that a database might be unresponsive other than hung. My question is this, should we be checking the host (hardware) not the database for whether or not to fail over. What are other companies that use VCS for HA doing to ensure that failovers do not happen for unnecessary or unintend reasons? Is VCS intended for checking application availability? JimSolved1KViews0likes3Comments
Integrating SAP with VCS 6.2 (on Oracle Linux 6.5)
Hi, I was wondering if someone has some additional information regarding how to setup my cluster... I have both VCS (inclusing Storage Foundation) and Linux knowledge. I do however have no background in SAP. And as SAP is a very complex product, I can not see the forest because of the trees... Setup 2 node (active-passive) cluster of Oracle Linux 6.5 nodes. Veritas Storage Foundation HA (= VxVM + DMP + VCS). Oracle 11.2 as database. SAP ECC 6.0 Apart from the Installation & Configuration guide on the SAP NetWeaver Agent, I found little information about implementing SAP in VCS. Source: "Symantec™ High Availability Agent for SAP NetWeaver Installation and Configuration Guide for Linux 6.2". But unfortunately I can not find a howto, guide or whatever from Symantec, nor from the usual Google attempts. My customer is however also not very SAP knowledged. From what I understand it is a very basic SAP setup, if not the simplest. They are using SAP ECC6.0 and an Oracle 11.2 database. So I assume they are just having a Central Instance and the Database. After some Google resource, I found out that SAP ECC 6.0 is technically a SAP NetWeaver 7.0. On Symantec SORT, I found 3 versions of SAP NetWeaver. I downloaded the first one, as the descripton says: SAP NetWeaver SAP NetWeaver 7.1, 7.2, 7.3, 7.4 SAP NetWeaver 7.1, 7.3 Agent: SAPNW04 5.0.16.0 Application version(s): SAP R/3 4.6, R/3 Enterprise 4.7, NW04, NW04s, ERP/ECC 5.0/6.0, SCM/APO 4.1/5.0/5.1/7.0, SRM 4.0/5.0/7.0, CRM 4.0/5.0/7.0 Source: https://sort.symantec.com/agents/detail/1077 SAP ERP 2005 = SAP NetWeaver 2004s (BASIS 7.00) = ECC 6.0 Source: http://itknowledgeexchange.techtarget.com/itanswers/difference-bet-ecc-60-sap-r3-47/ Source: http://www.fasttrackph.com/sap-ecc-6-0/ Source : http://wulibi.blogspot.be/2010/03/what-is-sap-ecc-60-in-brief.html Currently I have this setup unfinshed: Installed & configured Storage Foundation HA on both nodes. Instaled the ACC Libraries on both nodes. see: https://sort.symantec.com/agents/detail/1183 Installed the SAP NetWeaver Agent on both nodes. see: https://sort.symantec.com/agents/detail/1077 Configured next to the CusterServiceGroup, 3 Service Groups: SG_sap the shared storage Resources: DiskGroup + Volumes + Mount. the SAPNW Agent Resource. SG_oracle the shared storage Resources: DiskGroup + Volumes + Mount the Oracle Agent Resurce. SG_nfs still empty. SAPNW Agent. SAP instance type The SAPNW Agent documentation states: The agent supports the following SAP instance types: Central Services Instance Application Server Instance Enqueue Replication Server Instance. Source: "Symantec™ High Availability Agent for SAP NetWeaver Installation and Configuration Guide for Linux 6.2" But I guess the SAP ECC 6.0 has them all in one central instance, right? So I only need one SAPNW Agent. How is the SAP installed: only ABAP only Java add-in (both ABAP and Java). Source: "Symantec™ High Availability Agent for SAP NetWeaver Installation and Configuration Guide for Linux 6.2" I have no idea. How can I find this out? InstName Attribute Another thing is the InstName Attribute. This also does not correspond with the information I have. My SAP intance is T30. So the syntax is correct more or less, but it isn't listed below. Which is important also to decide on the value for the ProcMon Attribute The SAPSID and InstName form a unique identifier that can identify the processes running for a particular instance. Some examples of SAP instances are given as follows: InstName = InstType DVEBMGS00 = SAP Application Server - ABAP (Primary) D01 SAP = Application Server - ABAP (Additional) ASCS02 = SAP Central Services - ABAP J03 = SAP Application Server - Java SCS04 = SAP Central Services - Java ERS05 = SAP Enqueue Replication Server SMDA97 = Solution Manager Diagnostics Agent Source: "Symantec™ High Availability Agent for SAP NetWeaver Installation and Configuration Guide for Linux 6.2" In the listing of the required attributes it is also stated. However, the default value is CENTRAL. I guess this is correct in my case? InstName Attribute: An identifier that classifies and describes the SAP server instance type. Valid values are: APPSERV: SAP Application Server ENQUEUE: SAP Central Services ENQREP: Enqueue Replication Server SMDAGENT: Solution Manager Diagnostics Agent SAPSTARTSRV: SAPSTARTSRV Process Note: The value of this attribute is not case-sensitive. Type and dimension: string-scalar Default: APPSERV Example: ENQUEUE EnqSrvResName Attribute A required attribute is the EnqSrvResName Attribute. The documentation says this should be the Resource Name for the SAP Central Instance. But I am assuming I only have a SAP Central Instance. So I guess I should use the name of my SAP Agent Resouce from my SAP Service Group? EnqSrvResName Attribute: The name of the VCS resource for SAP Central Services (A)SCS Instance. This attribute is used by Enqueue and Enqueue Replication Server. Using this attribute the Enqueue server queries the Enqueue Replication Server resource state while determining the fail over target and vice a versa. Type and dimension: string-scalar Default: No default value Example: SAP71-PI1SCS_sap Source: "Symantec™ High Availability Agent for SAP NetWeaver Installation and Configuration Guide for Linux 6.2" Is anyone able to help me out? Thanks in advance.Solved2.4KViews2likes9CommentsCFS Health Check ?
Hi All, We have recently built a 4-node Oracle single-instance CFS cluster, with more to on the way. The cluster will host many databases, and all nodes will be active. The databases will migrate from non-clustered to CFS clustered servers, and we are concerned about what effect CFS may have on performance. Concerns: - Suitability of our LLT links to handle intra-node communication generated by CFS ? - Location of CFS primary, for each filesytem, and how to determine if it is optimal ? - When multiple nodes write to the same filesystem simultaeously, would that be detrimental to performance ? - I am aware of GLM lock/release as one source of CFS intra-node traffic, but wondering if there are other significant sources, such as VxFS cache coherency ? - How to best monitor CFS overhead, intra-node traffic, and overall health ? Thank your for reading ! Ken W ---------------------Configuration--------------------- Red Hat RHEL 6.5 SFCFSHA 6.1.1 with P200 patch 2 x 1 Gbit ethernet as LLT links, on dedicated VLANs Oracle 11.2.0.3 and 12.1.0.2 Oracle code local to each node (outside of cluster control) Oracle data files on CFS filesystem dedicated to only datases running on that node. Oracle Redo on a single shared filesytem for all nodes. -------------------------------------------------------------Solved1.4KViews0likes3Comments
Need to Migrate Heartbeat Connections to Different Network Switch
Hi all, I'm in the midst of planning a heartbeat switch migration and will need to iron out a few kinks. My environment consists of multiple VCS cluster groups, running on Windows 2003/2008. Apparently one of the network switch connecting all the heartbeats in need of replacement(it is still online, it just needs to be replaced due to end of support). My headache is on how to perform the migration without interrupting the clustered applications. Each of the cluster nodes are running on 2-3HB adapters, so initially I thought that replacing them one-by-one will work flawlessly. But when I tested it on a test environment, apparently after I removed and reconnect a HB connection fromeach pair of nodes, the nodes' state still remain as "Jeopardy" even after reconnection of HB cables. Do you have any idea on what's the best method to migrate all HB connections to a different switch online? What I've did during testing : 1. Freeze all service groups 2. Unplug connections for HB1 for both NodeA and NodeB from oldSwitch and connect them to newSwitch. Both NodeA and NodeB turns to "Jeopardy" at this stage and didn't return to normal state even after reconnection to new switch. 3. I didn't proceed to perform the same on HB2 connections for both node due to my concern with that "Jeopardy" state, afraid that if I were to proceed, it will make two mini-clusters instead. 4. What I did to return both node from Jeopardy state is to run Cluster Configuration Wizard on NodeA and reconfigure LLT connection to reset communication between the HB adapters. Appreciate any advise. Thanks in advance.505Views0likes0CommentsUnable to bring the Service Group online.
Hi All, I tried to bring a SG online in a node but it's not comming online. Let me explaing the issue. We did reboot of a node aixprd001 and we found that /etc/filesystem is corrupted so the SG bosinit_SG is in partial state since lot of cluster FS in not mounted. Then we corrected the entry and done the manual mout of all the FS but the SG still show the status partial so we did the bellow command. hagrp -clear bosinit_SG -all Once done the SG is in online state. For safer side we tried to offline the SG and brought it up online again but the SG failed to come online, Bellow is the only error we able find the engine_A.log file. 2014/12/17 06:49:04 VCS NOTICE V-16-1-10166 Initiating manual online of group bosinit_SG on system aixprd001 2014/12/17 06:49:04 VCS NOTICE V-16-1-10233 Clearing Restart attribute for group bosinit_SG on all nodes Please help me by providing suggestion, I will provide the output of logs if needed. Thanks, RufusSolved2.1KViews0likes4CommentsSG is not switching to next node.
Hi All, I am new to VCS but good in HACMP. In our environment we are using VCS-6.0, I one server we found that the SG is not moving from one node to another node when we tried manual failover using the bellow command. hagrp -switch <SGnamg> -to <sysname> We able to see that the SG is offline in the currnent node but it's not coming online in the secondary node. There is no error locked in engine_A.log except the bellow entry cpus load more than 60% <Secondary node name> Can anyone help me to find the solution for this. I will provide the output of any commands if you need more info to help me out to get this trouble shooted :) Thanks,Solved1.8KViews1like8Comments
Need to Migrate Heartbeat Connections to Different Network Switch
Hi all, I'm in the midst of planning a heartbeat switch migration and will need to iron out a few kinks. My environment consists of multiple VCS cluster groups, running on Windows 2003/2008. Apparently one of the network switch connecting all the heartbeats in need of replacement(it is still online, it just needs to be replaced due to end of support). My headache is on how to perform the migration without interrupting the clustered applications. Each of the cluster nodes are running on 2-3HB adapters, so initially I thought that replacing them one-by-one will work flawlessly. But when I tested it on a test environment, apparently after I removed and reconnect a HB connection fromeach pair of nodes, the nodes' state still remain as "Jeopardy" even after reconnection of HB cables. Do you have any idea on what's the best method to migrate all HB connections to a different switch online? What I've did during testing : 1. Freeze all service groups 2. Unplug connections for HB1 for both NodeA and NodeB from oldSwitch and connect them to newSwitch. Both NodeA and NodeB turns to "Jeopardy" at this stage and didn't return to normal state even after reconnection to new switch. 3. I didn't proceed to perform the same on HB2 connections for both node due to my concern with that "Jeopardy" state, afraid that if I were to proceed, it will make two mini-clusters instead. 4. What I did to return both node from Jeopardy state is to run Cluster Configuration Wizard on NodeA and reconfigure LLT connection to reset communication between the HB adapters. Appreciate any advise. Thanks in advance.