Golden Logres 1 2 2 Serial Port
2 Installing Oracle GoldenGateThis chapter includes the instructions for installing Oracle GoldenGate for the first time. Installing Oracle GoldenGate installs all of the components that are required to run and manage the processing (excluding any components required from other vendors, such as drivers or libraries) and it installs the Oracle GoldenGate utilities.These instructions are for installing Oracle GoldenGate for the first time. Additionally, they are for downloading the base release of a new version of Oracle GoldenGate.To download and install subsequent patches to the base release, go to the Patches and Updates tab of My Oracle Support at:To upgrade Oracle GoldenGate from one version to another, follow the upgrade instructions at:This chapter includes the following sections:. Note:If you are not already logged in, the Single Sign-on page appears.
2.2.1 Specifying Oracle Variables on UNIX and Linux SystemsIf there is one instance of Oracle Database on the system, set the ORACLEHOME and ORACLESID environment variables at the system level. If you cannot set them that way, use the following SETENV statements in the parameter file of every Extract and Replicat group that will be connecting to the instance. The SETENV parameters override the system settings and allow the Oracle GoldenGate process to set the variables at the session level when it connects to the database.SETENV (ORACLEHOME = 'path to Oracle home location')SETENV (ORACLESID = 'SID')If there are multiple Oracle instances on the system with Extract and Replicat processes connecting to them, you will need to use a SETENV statement in the parameter file of each process group. As input to the SETENV parameter, use the ORACLEHOME and ORACLESID environment variables to point Oracle GoldenGate to the correct Oracle instance. For example, the following shows parameter files for two Extract groups, each capturing from a different Oracle instance.Group 1:EXTRACT ora9aSETENV (ORACLEHOME = '/home/oracle/ora/product')SETENV (ORACLESID = 'oraa')USERIDALIAS tiger1RMTHOST sysbRMTTRAIL /home/ggs/dirdat/rtTABLE hr.emp;TABLE hr.salary;Group 2:EXTRACT orabSETENV (ORACLEHOME = '/home/oracle/ora/product')SETENV (ORACLESID = 'orab')USERIDALIAS tiger1RMTHOST sysbRMTTRAIL /home/ggs/dirdat/stTABLE fin.sales;TABLE fin.cust.
2.2.2 Specifying Oracle Variables on Windows SystemsIf there is one instance of Oracle on the system, the Registry settings for ORACLEHOME and ORACLESID should be sufficient for Oracle GoldenGate. 2.3 Setting Library Paths for Dynamic Builds on UNIXOracle GoldenGate uses shared libraries. When you install Oracle GoldenGate on a UNIX system, the following must be true before you run GGSCI or any other Oracle GoldenGate process.Make certain that the database libraries are added to the shared-library environment variables of the system.
This procedure is usually performed at database installation time. 2.4 Preparing to Install Oracle GoldenGate Within a ClusterThis topic covers the installation requirements that apply when Oracle GoldenGate will be installed in a cluster environment. Oracle GoldenGate can be used with any cluster-management solution that has the ability to automate failover. The Oracle Clusterware solution provides the advantage of being able to be used with or without an Oracle RAC database, which enables you to include any non-database servers that are running Oracle GoldenGate. 2.4.1 Supported Oracle Cluster StorageYou will need to install at least some Oracle GoldenGate objects on shared storage. Select cluster-aware shared storage that is independent of, but available to, all nodes of the cluster.
Golden Logres 1 2 2 Serial Port Number
You can use any of the following:.Oracle Cluster File System (OCFS). Instead of installing Oracle GoldenGate in a local directory, install it in a directory that is mounted to an OCFS volume. For configuration information, see the OCFS2 documentation at:.Oracle Automatic Storage Management System (AFS). If using classic capture, see setup requirements in.Oracle Database file system (DBFS). Do not install Oracle GoldenGate on DBFS, but you can store the subdirectories (that are created with CREATE SUBDIRS during installation) in a DBFS cluster that is only mounted to one server at a time. For requirements in high-availability, see.
2.4.2 Deciding Where to Install Oracle GoldenGate Binaries and Files in the ClusterThe best practice is to install Oracle GoldenGate entirely on shared storage. This allows you to start the Oracle GoldenGate processes from any of the nodes without having to make changes to the parameter files. If the active node fails, the processes can be started quickly on another node, using the processing checkpoints that are preserved in the installation directory.If you decide to install the Oracle GoldenGate binaries and files on each node, rather than on shared storage, the following must be true:.The Oracle GoldenGate installation must have the same location path on every node.At minimum, install the following directories on the shared storage to support Oracle GoldenGate recovery requirements. On UNIX or Linux, you can create symbolic links to them from the installation directory on each node.br.dirchk.dirdatThese directories are among those created when you issue CREATE SUBDIRS during installation.The parameter files in the dirprm directory, if not placed on the shared drive, must be identical on all nodes. To resolve environment settings that must be different from one node to the other, you can set environment settings so they are inherited from the local Manager process or reference a node-specific Oracle GoldenGate macro file. Because this scenario can be difficult to enforce, the inherent concerns can be avoided by storing the parameter files on the shared drive.See after you install Oracle GoldenGate.For more information about installing and using Oracle GoldenGate in a cluster, see.
2.5 Installing Oracle GoldenGateOracle GoldenGate for Oracle Database is installed from the Oracle Universal Installer (OUI). The OUI is a graphic installation program that prompts you for the input required to install the Oracle GoldenGate binaries and working files, and set the correct database environment in which Oracle GoldenGate will operate.You can use OUI on any of the Linux, UNIX, and Windows platforms that OUI supports and which Oracle GoldenGate supports.OUI is supported for Oracle versions 11g and later. An instance of Oracle GoldenGate can be installed for only one Oracle version in any given Oracle home.
You can install multiple instances of Oracle GoldenGate for the same or different database versions on the same host.The installer registers the Oracle GoldenGate home directory with the central inventory that is associated with the selected database. The inventory stores information about all Oracle software products installed on a host, provided the product was installed using OUI. 2.5.1 Performing an Interactive Installation with OUIThe interactive installation provides a graphical user interface that prompts for the required installation information.
These instructions apply to new installations as well as upgrades. However, to perform an upgrade to Oracle GoldenGate, follow the instructions in, which include a prompt to run OUI at the appropriate time.Expand the installation file.From the expanded directory, run the runInstaller program on UNIX or Linux, or run setup.exe on Windows.On the Select Installation Option page, select the Oracle GoldenGate version to install, and then click Next to continue.On the Specify Installation Details page, specify the following:.For Software Location, specify the Oracle GoldenGate installation directory. It can be a new or existing directory (for any Oracle GoldenGate version prior to 12.1.2.0.0) that is empty and has the amount of disk space shown on the screen or in the existing Oracle GoldenGate installation location (if you are upgrading an existing Oracle GoldenGate installation). The default location is under the installing user's home directory, but Oracle recommends changing it to a local directory that is not mounted and has no quotas. The specified directory cannot be a registered home in the Oracle central inventory. If installing in a cluster, install Oracle GoldenGate on shared storage that is accessible by all of the cluster nodes.
See for more information about installing Oracle GoldenGate in a cluster.(Optional) Select Start Manager to perform configuration functions, such as creating the Oracle GoldenGate subdirectories in the installation location, setting library paths, and starting Manager on the specified port number. To proceed, a database must exist on the system. When Start Manager is selected, the Database Location and Manager Port fields are displayed.For Database Location, the database version in the specified location must be Oracle Database 12c if you are installing Oracle GoldenGate for Oracle Database 12c or Oracle Database 11g if you are installing Oracle GoldenGate for Oracle Database11g. The database must have a registered home in the Oracle central inventory. The installer registers the Oracle GoldenGate home directory with the central inventory.For Manager Port, accept the default port number or enter a different unreserved, unrestricted port number for the Manager process to use for interprocess communication. The default port is the first available one starting with 7809.
If you are installing multiple instances of Oracle GoldenGate on the same system, each must use a different port number.Click Next to continue. If this is an upgrade to an existing Oracle GoldenGate installation, OUI prompts that the selected software location has files or directories. Click Yes.The Create Inventory page is displayed if this is the first Oracle product to be installed from OUI on a host that does not have a central inventory.For Inventory Directory, specify a directory for the central inventory. It can be a new directory or an existing directory that is empty and has the amount of disk space shown on the screen. The directory cannot be on a shared drive.Select an operating system group in which the members have write permission to the inventory directory.
This group is used to add inventory information to the Oracle GoldenGate subfolder.On the Summary page, confirm that there is enough space for the installation and that the installation selections are correct. Optionally, click Save Response File to save the installation information to a response file.
You can run the installer from the command line with this file as input to duplicate the results of a successful installation on other systems. You can edit this file or create a new one from a template. See.Click Install to begin the installation or Back to go back and change any input specifications.
When upgrading an existing Oracle GoldenGate installation, OUI notifies you that the software location has files or directories. Click Yes to continue. You are notified when the installation is finished.If you created a central inventory directory, you are prompted to run the INVENTORYLOCATION/orainstRoot.sh script.
This script must be executed as the root operating system user. This script establishes the inventory data and creates subdirectories for each installed Oracle product (in this case, Oracle GoldenGate). 2.5.2 Performing a Silent Installation with OUIThese instructions apply to new installations as well as upgrades. However, to perform an upgrade to Oracle GoldenGate, follow the instructions in, which include a prompt to run OUI at the appropriate time.You can perform a silent installation from the command console if the system has no X-Windows interface or to perform an automated installation. Silent installations can ensure that multiple users in your organization use the same installation options when they install your Oracle products.You perform a silent installation by running a response file.
You can create a response file by selecting the Save Response File option during an interactive OUI session or by editing a template, as shown in. To run a response file, issue the following command.-silent -nowait -responseFile pathtofileThe response files and the template are stored in the response sub-directory of the Oracle GoldenGate installation directory. The Oracle GoldenGate response file contains a standard set of Oracle configuration parameters in addition to parameters that are specific to Oracle GoldenGate. These parameters correspond to the fields in the interactive session.
Example 2-1 Oracle GoldenGate Response File Template###################################################################### Copyright(c) Oracle Corporation 2013. All rights reserved. #### #### Specify values for the variables listed below to customize #### your installation. #### #### Each variable is associated with a comment. The comment #### can help to populate the variables with the appropriate #### values. #### #### IMPORTANT NOTE: This file should be secured to have read #### permission only by the oracle user or an administrator who #### own this installation to protect any sensitive input values.
#### #######################################################################-# Do not change the following system generated value. Note:If you are upgrading an existing Oracle GoldenGate installation with the silent option, you might get the following warning:WARNING:OUI-10030:You have specified a non-empty directory to install this product. It is recommended to specify either an empty or a non-existent directory. You may, however, choose to ignore this message if the directory contains Operating System generated files or subdirectories like lost+found.Do you want to proceed with installation in this Oracle Home?Press ENTER to continue.
Golden Logres 1 2 2 Serial Portrait
2.6.1 General Requirements in a Cluster.Register the Oracle GoldenGate Manager process (and only Manager) as a cluster-managed resource as you would any other application. Manager must be the only Oracle GoldenGate process that the cluster-management software starts and stops, because it is the parent process that manages all other processes.If the cluster uses a virtual IP address (such as Oracle Clusterware), you may need to obtain an available fixed IP address for the Manager process. The VIP must be an available IP address on the public subnet and cannot be determined through DHCP. In the parameter files of the Extract data pumps, specify the VIP of the remote Manager as the input value of the RMTHOST parameter. Other Oracle GoldenGate products that access Manager also should use the VIP.Make certain that all nodes in the cluster have the same COMPATIBLE parameter setting.When you configure Manager, add the AUTOSTART and AUTORESTART parameters so that Manager starts the replication processes automatically. You can, when needed, control Extract, Replicat, and other Oracle GoldenGate processes from within the Oracle GoldenGate user interfaces.Mount the shared drive on one node only. This prevents processes from being started on another node.
Use the same mount point on all nodes.Configure Oracle GoldenGate as directed in this documentation.