Oracle GoldenGate Veridata 23c静默安装（一）

在之前我们已经分享过如何安装Veridata 23c，但是是基于图形化界面的，有些客户可能有所限制，不能其图形化界面，那我们就需要用静默安装的方式来执行，下面具体讲下Veridata 23c静默安装的操作。

https://download.oracle.com/java/17/archive/jdk-17.0.12_linux-x64_bin.tar.gz

1.2 Veridata 23c

https://www.oracle.com/middleware/technologies/goldengate-downloads.html#

1.3 MySQL 8.0

https://downloads.mysql.com/archives/community/

1.3 关闭防火墙

# systemctl stop firewalld

# systemctl disable firewalld

# systemctl status firewalld

1.4 关闭 NetworkManager

# systemctl stop NetworkManager.service

# systemctl disable NetworkManager.service

# systemctl status NetworkManager.service

1.5 关闭 SELINUX

# sed -i "s/SELINUX=.*/SELINUX=disabled/g" /etc/selinux/config

# setenforce 0

1.6 安装 RPM 包

# mount  /dev/cdrom  /mnt

配置操作系统 YUM 源

# vi /etc/yum.repos.d/dvd.repo

[dvd]

name=dvd

baseurl=file:///mnt

gpgcheck=0

安装所需依赖包

# yum -y install gcc* gcc-c++ ncurses* ncurses-devel* cmake* make* perl* bison* libaio-devel* libgcrypt

安装常用故障与性能诊断工具等

# yum install -y unzip man screen tigervnc-server iotop dstat openssl make sysstat vsftpd ftp

一、  安装 JDK

2.1 创建安装用户

# useradd veridata23

2.2 上传安装包

# mkdir -p /tmp/veridata23_medias

上传 jdk-17.0.12_linux-x64_bin.tar.gz 、 Oracle GoldenGate Veridata 23.1.0.0.0 for (Linux x86-64).zip 以及 mysql-8.0.39-linux-glibc2.17-x86_64.tar.xz

# chown -R veridata23:veridata23 /tmp/veridata23_medias

# chmod -R 777 /tmp/veridata23_medias

2.3 解压 JDK

# mkdir -p /usr/java

# tar -xzvf jdk-17.0.12_linux-x64_bin.tar.gz -C /usr/java

2.4 配置环境变量

# su - veridata23

$ vi ~/.bash_profile

export JAVA_HOME=/usr/java/jdk-17.0.12

export PATH=$JAVA_HOME/bin:$PATH

2.5 确认 JDK 信息

$ which java

/usr/java/jdk-17.0.12/bin/java

$ java -version

java version "17.0.12" 2024-07-16 LTS

Java(TM) SE Runtime Environment (build 17.0.12+8-LTS-286)

Java HotSpot(TM) 64-Bit Server VM (build 17.0.12+8-LTS-286, mixed mode, sharing)

二、  安装 MySQL

3.1 创建安装目录

# mkdir -p /mysql/app

# mkdir -p /mysql/product/data

# chown -R veridata23:veridata23 /mysql

# chmod -R 755 /mysql

3.2 解压 MySQL8.0

# su - veridata23

$ cd /tmp/veridata23_medias

$ tar -xvf mysql-8.0.39-linux-glibc2.17-x86_64.tar.xz -C /mysql/app --strip-components=1

3.3 创建配置文件

# vi /etc/my.cnf

[mysqld]

user=veridata23

port=3306

basedir=/mysql/app

datadir=/mysql/product/data

log_error=/mysql/product/data/myerror.log

# 会话参数

max_connections=4532

max_user_connections=4000

max_connect_errors=50000

wait_timeout=7200

interactive_timeout=7200

thread_cache_size=256

#binlog 日志参数

log-bin=mysql-bin

binlog_cache_size=131072

binlog_error_action=ABORT_SERVER

server_id=1

gtid_mode=on

enforce_gtid_consistency=on

binlog_expire_logs_seconds=2592000

sync_binlog=1

# 慢日志参数

slow_query_log=0

long_query_time=1

log_output=FILE

#Redo 日志参数

innodb_log_file_size=1048576000

innodb_log_files_in_group=3

# 缓存参数

sort_buffer_size=720896

read_buffer_size=720896

read_rnd_buffer_size=360448

join_buffer_size=360448

max_allowed_packet=1073741824

max_heap_table_size=16777216

tmp_table_size=2097152

#innodb 参数

innodb_buffer_pool_size=4194304

innodb_data_file_path=ibdata1:200M:autoextend

innodb_file_per_table=ON

innodb_log_buffer_size=16777216

innodb_flush_method=O_DIRECT

# 事务隔离级别

transaction-isolation=READ-COMMITTED

# 字符集

character_set_server=utf8mb4

# 设置时区

default_time_zone='+8:00'

log_timestamps=SYSTEM

# 大小写不敏感

lower_case_table_names=1

3.4 初始化 MySQL

# cd /mysql/app

# ./bin/mysqld --defaults-file=/etc/my.cnf --initialize

# grep 'temporary password' /mysql/product/data/myerror.log

2025-01-09T20:20:22.152366-05:00 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: pWtO-u<tG8<s

3.5 配置环境变量

# vi /root/.bash_profile

PATH=/mysql/app/bin:$PATH

# source /root/.bash_profile

3.6 配置数据库服务

# cp /mysql/app/support-files/mysql.server /etc/init.d/mysqld

# vi /etc/init.d/mysqld

basedir=/mysql/app

datadir=/mysql/product/data

3.7 启停 MySQL

# service mysqld start     // 启动 mysql

# service mysqld status    // 查看启动状态

# service mysqld stop      // 停止 mysql

3.8 修改 root 密码

# mysqladmin -uroot -p password "Test321#"

Enter password:pWtO-u<tG8<s

# mysql -uroot -pTest321#

3.9 设置远程登录

mysql> create user root@'%' identified by 'Test321#';

mysql> grant all privileges on *.* to root@'%';

3.10 创建 veridata 用户

mysql> CREATE USER 'vdt23'@'%' IDENTIFIED BY 'Test321#';

mysql> GRANT ALL PRIVILEGES ON *.* TO 'vdt23'@'%' WITH GRANT OPTION;

mysql> FLUSH PRIVILEGES;

mysql> SHOW GRANTS FOR 'vdt23'@'%'; 至此前面的准备工作基本做完，由于篇幅较长，后半部分的server以及agent安装请看下边文章。