Operating System resources that are necessary to support Oracle GoldenGate
Memory Requirements
The amount of memory that is required for Oracle GoldenGate depends on the amount of data being processed, the number of Oracle GoldenGate processes running, the amount of RAM available to Oracle GoldenGate.
Modern servers have sufficient RAM combined with sufficient swap space and memory management systems to run Oracle GoldenGate. However, increasing the amount of RAM available to Oracle GoldenGate may significantly improve its performance, as well as that of the system in general.
Disk Requirements
The disk space requirements for an Oracle GoldenGate installation vary based on your operating system and database. You should ensure that you have adequate disk space for the downloaded file, expanded files, and installed files, which can be up to 2GB. The minimum disk space required is 676 MB
Other Disk Space Considerations
Oracle GoldenGate trails can be created up to 2GB in size, with a default of 500MB. The space required depends upon the selected size of the trails, the amount of data being captured for replication, and how often consumed Trails are removed from disk. The recommended minimum disk allocated for Trails may be computed as:
((transaction log size * 0.33) * number of log switches per day) * number of days to retain trails
Based on this equation, if the transaction logs are 1GB in size and there is an average of 10 log switches per day, it means that Oracle GoldenGate will capture 3.3GB data per day. To be able to retain trails for 7 days, the minimum amount of disk space needed to hold the trails is 23GB.
Network
For optimal performance and reliability, especially in maintaining low latency on the target, use the fastest network possible and install redundancies at all points of failure.
Configure your firewalls to accept connections through the Oracle GoldenGate ports.
Operating System Privileges
To install on Windows, the person who installs Oracle GoldenGate must log in as an Administrator.
Before installing Oracle GoldenGate on a Windows system, install the Microsoft Visual C ++ 2013 Redistributable Package and the Microsoft Visual C++ 2017 Redistributable Package. These packages install runtime components of Visual C++ Libraries that are required for Oracle GoldenGate processes.
Download and install the x64 version of Visual C++ 2013 package from :
https://support.microsoft.com/en-us/help/4032938/update-for-visual-c-2013-redistributable-package
Download and install the x64 version of Visual C++ 2017 package from
https://support.microsoft.com/en-us/help/2977003/the-latest-supported-visual-c-downloads
Download the software
191004_fbo_ggs_Windows_x64_shiphome.zip
Create a directory
C:\windows\system32>mkdir D:\app\golden_gate
Cd C:\Program Files\7-Zip
C:\Program Files\7-Zip>7z x C:\SOFT\191004_fbo_ggs_Windows_x64_shiphome.zip -oC:\SOFT
7-Zip 19.00 (x64) : Copyright (c) 1999-2018 Igor Pavlov : 2019-02-21
Scanning the drive for archives:
1 file, 638431582 bytes (609 MiB)
Extracting archive: C:\SOFT\191004_fbo_ggs_Windows_x64_shiphome.zip
Path = C:\SOFT\191004_fbo_ggs_Windows_x64_shiphome.zip
Type = zip
Physical Size = 638431582
Everything is Ok
Folders: 175
Files: 386
Size: 754710358
Compressed: 638431582
Go to directory
C:\Program Files\7-Zip> cd c:\SOFT\fbo_ggs_Windows_x64_shiphome\Disk1
c:\SOFT\fbo_ggs_Windows_x64_shiphome\Disk1>dir
Volume in drive C is System
Volume Serial Number is AE4F-8587
Directory of c:\SOFT\fbo_ggs_Windows_x64_shiphome\Disk1
20-Oct-19 05:45 PM <DIR> .
20-Oct-19 05:45 PM <DIR> ..
20-Oct-19 05:45 PM <DIR> install
20-Oct-19 05:45 PM <DIR> response
30-Oct-13 08:22 PM 96,176 setup.exe
20-Oct-19 05:45 PM <DIR> stage
1 File(s) 96,176 bytes
5 Dir(s) 36,728,471,552 bytes free
c:\SOFT\fbo_ggs_Windows_x64_shiphome\Disk1>
Run setup.exe to install Golden Gate
c:\SOFT\fbo_ggs_Windows_x64_shiphome\Disk1>setup.exe
Starting Oracle Universal Installer...
Checking swap space: must be greater than 150 MB . Actual 10315 MB Passed
Checking monitor: must be configured to display at least 256 colors Higher than 256 . Actual 4294967296 Passed
Preparing to launch Oracle Universal Installer from C:\Users\nabjoshi\AppData\Local\Temp\OraInstall2022-01-01_09-25-52PM. Please wait ...
Install Manager as a Windows Service
By default, Manager is not installed as a service and can be run by a local or domain account. However, when run this way, Manager will stop when the user logs out. When you install Manager as a service, you can operate it independently of user connections, and you can configure it to start manually or at system startup.
GGSCI (NABJOSHI-7400) 2> EDIT PARAMS ./GLOBALS
GGSCI (NABJOSHI-7400) 3> view PARAMS ./GLOBALS
MGRSERVNAME OracleGGSMGR
GGSCI (NABJOSHI-7400) 3> view PARAMS ./GLOBALS
MGRSERVNAME OracleGGSMGR
D:\app\golden_gate>install ADDSERVICE
Service 'OracleGGSMGR' created.
Install program terminated normally.
Start the Windows services
D:\app\golden_gate>sc start OracleGGSMGR
SERVICE_NAME: OracleGGSMGR
TYPE : 10 WIN32_OWN_PROCESS
STATE : 2 START_PENDING
(NOT_STOPPABLE, NOT_PAUSABLE, IGNORES_SHUTDOWN)
WIN32_EXIT_CODE : 0 (0x0)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x1
WAIT_HINT : 0xea60
PID : 540
FLAGS :
D:\app\golden_gate>ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO
Windows x64 (optimized), Oracle 19c on Oct 19 2019 22:34:39
Operating system character set identified as windows-1252.
Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.
GGSCI (NABJOSHI-7400) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (NABJOSHI-7400) 2>
The below command can be used only for the manager process and globals file. It permits to see all details of a parameter file.
info param port
info param ALLOWOUTPUTDIR
Getparaminfo allows seeing all the parameters used by a process.
send mgr getparaminfo
send mgr getparaminfo port
No comments:
Post a Comment