Configuring Clusterware for GoldenGate in Software Develop 3 of 9 barcode in Software Configuring Clusterware for GoldenGate

How to generate, print barcode using .NET, Java sdk library control with example project source code free download:
6. using barcode encoder for software control to generate, create code39 image in software applications. Scan GS1 BarCodes Configuring Clusterware for GoldenGate Oracle Clusterware will ensu re that GoldenGate can tolerate server failures by moving processing to another available server in the cluster. It can support the management of a third party application in a clustered environment. This capability will be used to register and relocate the GoldenGate Manager process.

Once the GoldenGate software has been installed across the cluster and a script to start, check, and stop GoldenGate has been written and placed on the shared storage (so it is accessible to all nodes), the GoldenGate Manager process can be registered in the cluster. Clusterware commands can then be used to create, register and set privileges on the virtual IP address (VIP) and the GoldenGate application using standard Oracle Clusterware commands..

The Virtual IP The VIP is a key component o f Oracle Clusterware that can dynamically relocate the IP address to another server in the cluster, allowing connections to failover to a surviving node. The VIP provides faster failovers compared to the TCP/IP timeout based failovers on a server"s actual IP address. On Linux this can take up to 30 minutes using the default kernel settings! The prerequisites are as follows: 1.

The VIP must be a fixed IP address on the public subnet. 2. The interconnect must use a private non-routable IP address, ideally over Gigabit Ethernet.

Use a VIP to access the GoldenGate Manager process to isolate access to the Manager process from the physical server. Remote data pump processes must also be configured to use the VIP to contact the GoldenGate Manager..

[ 129 ]. Configuring GoldenGate for HA The following diagram illust Code39 for None rates the RAC architecture for 2 nodes (rac1 and rac2) supporting 2 Oracle instances (oltp1 and oltp2). The VIPs are 11.12.

1.6 and 11.12.

1.8 respectively, in this example:. The user community or applic ation servers connect to either instance via the VIP and a load balancing database service, that has been configured on the database and in the client"s SQL*Net tnsnames.ora file or JDBC connect string. The following example shows a typical tnsnames entry for a load balancing service.

Load balancing is the default and does not need to be explicitly configured. Hostnames can replace the IP addresses in the tnsnames.ora file as long as they are mapped to the relevant VIP in the client"s system hosts file.

. OLTP = (DESCRIPTION = (ADDRE Code 39 for None SS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 11.12.1.

6)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 11.12.1.

8)(PORT = 1521)) ) (CONNECT_DATA =. [ 130 ]. 6 (SERVICE_NAME = oltp) ) ). This is the recommended appr oach for scalability and performance and is known as active-active. Another HA solution is the active-passive configuration, where users connect to one instance only leaving the passive instance available for node failover..

The term active-active or ac barcode 3 of 9 for None tive-passive in this context relates to 2-node RAC environments and is not to be confused with the GoldenGate topology of the same name.. On Linux systems, the databa se server hostname will typically have the following format in the /etc/hosts file. For Public VIP: <hostname>-vip For Private Interconnect: <hostname>-pri The following is an example hosts file for a RAC node:. ::1 localhost.localdomain localhost localhost6.localdomain6 localhost6 #Virtual IP Public Address 1 1.12.1.

6 rac1-vip 11.12.1.

8 rac2-vip #Private Address 192.168.1.

33 rac1-pri 192.168.1.

34 rac2-pri. rac1-vip rac2-vip rac1-pri rac2-pri Creating a GoldenGate application The following steps guide yo u through the process of configuring GoldenGate on RAC. This example is for an Oracle 11g Release 1 RAC environment: 1. Install GoldenGate as the Oracle user on each node in the cluster or on a shared mount point that is visible from all nodes.

If installing the GoldenGate home on each node, ensure the checkpoint and trails files are on the shared filesystem. 2. Ensure the GoldenGate Manager process is configured to use the AUTOSTART and AUTORESTART parameters, allowing GoldenGate to start the Extract and Replicat processes as soon as the Manager starts.

. [ 131 ].
Copyright © . All rights reserved.