GoldenGate 23ai - Silent Installation
GoldenGate 23ai installation can be done through a GUI and silent installation mode.
Please follow below steps to complete the silent installtion of GoldenGate 23ai.
Prerequisite
mkdir -p /u01/gghome
mkdir -p /u01/sm_home
mkdir -p /u01/dp_home
mkdir -p /u01/metrics
mkdir -p /u01/oraInventory
gghome - GoldenGate Binary home location
sm_home - Service Manager home location
dp_home - Deployment home location
metrics - BDB/LMDB metrics home location
3. GoldenGate MicroServices requires 5 free ports.
Example :16000-16004,
9100-9104
4. Install the required RPM's.
sudo dnf install -y oracle-database-preinstall-23ai
sudo yum install libnsl.x86_64
Step 1: Installing Oracle GoldenGate
######################################################################
## Copyright(c) Oracle Corporation 2016, 2024. 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 ##
## owns this installation to protect any sensitive input values. ##
## ##
###################################################################
#-------------------------------------------------------------------
# Do not change the following system generated value.
#-------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v23_1_0
###################################################################
## ##
## Oracle GoldenGate installation option and details ##
## ##
###################################################################
#---------------------------------------------------------------------
# Specify the installation option.
# Specify ORA23ai for installing Oracle GoldenGate for Oracle Database 23ai and lower supported versions
#---------------------------------------------------------------------
INSTALL_OPTION=ORA23ai
#---------------------------------------------------------------------
# Specify a location to install Oracle GoldenGate
#---------------------------------------------------------------------
SOFTWARE_LOCATION=/u01/gghome
###################################################################
## ##
## Specify details to Create inventory for Oracle installs ##
## Required only for the first Oracle product install on a system. ##
## ##
###################################################################
#----------------------------------------------------------------
# Specify the location which holds the install inventory files.
# This is an optional parameter if installing on
# Windows based Operating System.
#----------------------------------------------------------------
INVENTORY_LOCATION=/u01/oraInventory
#----------------------------------------------------------------
# Unix group to be set for the inventory directory.
# This parameter is not applicable if installing on
# Windows based Operating System.
#----------------------------------------------------------------
UNIX_GROUP_NAME=oinstall
b. Run the installer
cd <Software downloaded location>
./runInstaller -silent -nowait -responseFile <response-file-location>/oggcore.rsp
Step 2: Deployment creation using the Oracle GoldenGate Configuration Assistant (OGGCA) wizard-[SILENT].
a. create a response file with name oggca.rsp ans paste the below content.
领英推荐
ENV_TNS_ADMIN=<TNS_ADMIN_LOCATION>
HOST_SERVICEMANAGER=<hostname>
###################################################################
## Copyright(c) Oracle Corporation 2016, 2024. All rights reserved. ##
## ##
## Specify values for the variables listed below to customize your ##
## installation. ##
## ##
## Each variable is associated with a comment. The comments 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 owns this configuration to ##
## protect any sensitive input values. ##
## ##
###################################################################
#--------------------------------------------------------------------------
# Do not change the following system generated value.
#--------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_oggca_response_schema_v23_1_0
###################################################################
# #
# SECTION A - GENERAL #
# #
###################################################################
CONFIGURATION_OPTION=ADD
DEPLOYMENT_NAME=DEMO
ADMINISTRATOR_USER=oggadmin
ADMINISTRATOR_PASSWORD=oggadmin
DEPLOYMENT_ADMINISTRATOR_USER=oggadmin
DEPLOYMENT_ADMINISTRATOR_PASSWORD=oggadmin
###################################################################
# #
# SECTION C - SERVICE MANAGER #
# #
###################################################################
SERVICEMANAGER_DEPLOYMENT_HOME=/u01/sm_home
SERVICEMANAGER_ETC_HOME=
SERVICEMANAGER_CONF_HOME=
SERVICEMANAGER_SSL_HOME=
SERVICEMANAGER_VAR_HOME=
SERVICEMANAGER_DATA_HOME=
SERVICEMANAGER_ARCHIVE_HOME=
HOST_SERVICEMANAGER=<hostname>
PORT_SERVICEMANAGER=16000
SECURITY_ENABLED=false
STRONG_PWD_POLICY_ENABLED=false
CREATE_NEW_SERVICEMANAGER=true
REGISTER_SERVICEMANAGER_AS_A_SERVICE=true
INTEGRATE_SERVICEMANAGER_WITH_XAG=false
EXISTING_SERVICEMANAGER_IS_XAG_ENABLED=false
ENABLE_SERVICE_MANAGER_REMOTE_METRICS=false
SERVICE_MANAGER_REMOTE_METRICS_LISTENING_HOST=
SERVICE_MANAGER_REMOTE_METRICS_LISTENING_PORT=0
###################################################################
# #
# SECTION D - CONFIGURATION SERVICE #
# #
###################################################################
CONFIGURATION_SERVICE_ENABLED=true
CONFIGURATION_SERVICE_BACKEND_TYPE=FILESYSTEM
CONFIGURATION_SERVICE_BACKEND_CONNECTION_STRING=
CONFIGURATION_SERVICE_BACKEND_USERNAME=
CONFIGURATION_SERVICE_BACKEND_PASSWORD=
CONFIGURATION_SERVICE_BACKEND_TABLE_NAME=
###################################################################
# #
# SECTION E - SOFTWARE HOME #
# #
###################################################################
OGG_SOFTWARE_HOME=/u01/gghome
#################################################################### #
# SECTION F - DEPLOYMENT DIRECTORIES #
# #
###################################################################
OGG_DEPLOYMENT_HOME=/u01/dp_home
OGG_ETC_HOME=
OGG_CONF_HOME=
OGG_SSL_HOME=
OGG_VAR_HOME=
OGG_DATA_HOME=
OGG_ARCHIVE_HOME=
###################################################################
# #
# SECTION G - ENVIRONMENT VARIABLES #
# #
###################################################################
ENV_LD_LIBRARY_PATH=${OGG_HOME}/lib/instantclient:${OGG_HOME}/lib
ENV_TNS_ADMIN=<TNS_ADMIN_LOCATION>
ENV_STREAMS_POOL_SIZE=
ENV_USER_VARS=
###################################################################
# #
# SECTION H - SECURITY #
# This section is only needed if Security will be enabled #
# #
###################################################################
TLS_1_2_ENABLED=false
TLS_1_3_ENABLED=true
FIPS_ENABLED=false
SERVER_CERTIFICATE=
SERVER_CERTIFICATE_KEY_FILE=
SERVER_CA_CERTIFICATES_FILE=
CLIENT_CERTIFICATE=
CLIENT_CERTIFICATE_KEY_FILE=
CLIENT_CA_CERTIFICATES_FILE=
###################################################################
# #
# SECTION I - SERVICES #
# #
###################################################################
ADMINISTRATION_SERVER_ENABLED=true
PORT_ADMINSRVR=16001
DISTRIBUTION_SERVER_ENABLED=true
PORT_DISTSRVR=16002
NON_SECURE_DISTSRVR_CONNECTS_TO_SECURE_RCVRSRVR=false
RECEIVER_SERVER_ENABLED=true
PORT_RCVRSRVR=16003
METRICS_SERVER_ENABLED=true
METRICS_SERVER_IS_CRITICAL=false
PORT_PMSRVR=16004
PMSRVR_DATASTORE_TYPE=BDB
PMSRVR_DATASTORE_HOME=/u01/metrics
ENABLE_DEPLOYMENT_REMOTE_METRICS=false
DEPLOYMENT_REMOTE_METRICS_LISTENING_HOST=
DEPLOYMENT_REMOTE_METRICS_LISTENING_PORT=0
###################################################################
# #
# SECTION J - REPLICATION OPTIONS #
# #
###################################################################
OGG_SCHEMA=oggadmin
b. Run the configuration oggca.
cd /u01/gghome/bin
./oggca.sh -silent -nowait -responseFile <response-file-location>/oggca.rsp
c. Run the script to register the Service Manager as a system service/daemon.
To execute the configuration scripts:
1.Open a terminal window
2.Login as "root"
3.Run the script
/u01/sm_home/bin/registerServiceManager.sh
Instllation has been completed. Now we will switch to brower and login to Service Manager with simple web url https://hostname/ip:16000
2. GoldenGate 23ai home page.
Oracle DBA | OCP | Seasoned Oracle Database Consultant
8 个月Hello Madhu kumar S As per Step 2 , oggca.rsp , I am unable to find this existing file in my ORACLE GOLDENGATE HOME after installing Software. Could you please help me from which location, you have this file. My GG version : 23.4.1.24.05
Director of Product Management GoldenGate @ Oracle | Executive MBA | Mentor | Speaker | Data Integration, Security and Highly Available Applications Advocate
9 个月Excellent write-up, I had this on my list, and now I can refer to your post. Thanks, Madhu kumar S.