1.docker安装oracle11g
docker pull registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g
docker run -d -p 1521:1521 --name oracle11g --privileged registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g
docker start oracle11g
docker exec -it oracle11g bash
2.上传ogg到oracle服务器，并配置swap
docker cp /oggtest/fbo_ggs_Linux_x64_shiphome/Disk1 oracle11g:/ogghome
docker exec -it oracle11g bash
[root@9f83a6076e06 ~]# dd if=/dev/zero of=/swapfile bs=1024 count=512k
524288+0 records in
524288+0 records out
536870912 bytes (537 MB) copied, 1.38129 s, 389 MB/s
[root@9f83a6076e06 ~]# mkswap /swapfile
mkswap: /swapfile: warning: don't erase bootbits sectors
on whole disk. Use -f to force.
Setting up swapspace version 1, size = 524284 KiB
no label, UUID=1b0bd019-90f1-49fb-935b-6a6c6015a0c9
[root@9f83a6076e06 ~]# swapon /swapfile
[root@9f83a6076e06 ~]# chown -R oracle:oinstall /ogghome/
3.静默安装ogg
编辑响应文件
[oracle@c075234ac240 ogghome]$ cat response/oggcore.rsp
####################################################################
## Copyright(c) Oracle Corporation 2019. 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.
#-------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v19_1_0
################################################################################
## ##
## Oracle GoldenGate installation option and details ##
## ##
################################################################################
#-------------------------------------------------------------------------------
# Specify the installation option.
# Specify ORA19c for installing Oracle GoldenGate for Oracle Database 19c or
# ORA18c for installing Oracle GoldenGate for Oracle Database 18c or
# ORA12c for installing Oracle GoldenGate for Oracle Database 12c or
# ORA11g for installing Oracle GoldenGate for Oracle Database 11g
#-------------------------------------------------------------------------------
INSTALL_OPTION=ORA11g
#-------------------------------------------------------------------------------
# Specify a location to install Oracle GoldenGate
#-------------------------------------------------------------------------------
SOFTWARE_LOCATION=/ogghome/ogghome
#-------------------------------------------------------------------------------
# Specify true to start the manager after installation.
#-------------------------------------------------------------------------------
START_MANAGER=false
#-------------------------------------------------------------------------------
# Specify a free port within the valid range for the manager process.
# Required only if START_MANAGER is true.
#-------------------------------------------------------------------------------
MANAGER_PORT=
#-------------------------------------------------------------------------------
# Specify the location of the Oracle Database.
# Required only if START_MANAGER is true.
#-------------------------------------------------------------------------------
DATABASE_LOCATION=
################################################################################
## ##
## 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=
#-------------------------------------------------------------------------------
# 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
主要是：SOFTWARE_LOCATION=/ogghome/ogghome
START_MANAGER=false
UNIX_GROUP_NAME=oinstall
安装
[oracle@c075234ac240 ogghome]$ ./runInstaller -silent -responseFile /ogghome/response/oggcore.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 21477 MB Passed
Checking swap space: must be greater than 150 MB. Actual 511 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2021-03-11_11-53-17AM. Please wait ...[oracle@c075234ac240 ogghome]
$ You can find the log of this install session at: /ogghome/oraInventory/logs/installActions2021-03-11_11-53-17AM.log
The installation of Oracle GoldenGate Core was successful.
Please check '/ogghome/oraInventory/logs/silentInstall2021-03-11_11-53-17AM.log' for more details.
As a root user, execute the following script(s):
1. /ogghome/oraInventory/orainstRoot.sh
Successfully Setup Software.
中间的问题记录：
1.安装目录必须是空文件夹
2.响应文件要用绝对地址
3.使用--privileged选项运行容器，才有权限建立swap
失败，因为ogghome路径下有文件
Checking Temp space: must be greater than 120 MB. Actual 23398 MB Passed
Checking swap space: must be greater than 150 MB. Actual 511 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2021-03-11_10-54-34AM. Please wait ...[oracle@9f83a6076e06 Disk1]$
[WARNING] [INS-75003] The specified directory /ogghome is not empty. CAUSE: The directory specified /ogghome contains files.
ACTION: Clean up the specified directory or enter a new directory location.
[FATAL] [INS-32035] The location (/home/oracle/app/oraInventory) specified for the central inventory is not empty.
CAUSE: The specified central inventory location is either locked by different install session, or the location specified does not h
ave write permissions for the logs. ACTION: Specify an empty location for the inventory.
[FATAL] [INS-32037] The operating system group specified for central inventory (oraInventory) ownership is invalid.
CAUSE: No value specified for central inventory (oraInventory) ownership group.
ACTION: Specify an operating system group whose members should have write permission to the central inventory directory (oraInvento
ry).A log of this session is currently saved as: /tmp/OraInstall2021-03-11_10-54-34AM/installActions2021-03-11_10-54-34AM.log. Oracle reco
mmends that if you want to keep this log, you should move it from the temporary location.
失败，因为响应文件使用了相对路径
[oracle@9f83a6076e06 Disk1]$ ./runInstaller -silent -responseFile response/oggcore.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 23398 MB Passed
Checking swap space: must be greater than 150 MB. Actual 511 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2021-03-11_10-53-06AM. Please wait ...[oracle@9f83a6076e06 Disk1]$
[FATAL] [INS-10101] The given response file response/oggcore.rsp is not found. CAUSE: The given response file is either not accessible or do not exists.
ACTION: Give a correct response file location. (Note: relative path is not supported)
A log of this session is currently saved as: /tmp/OraInstall2021-03-11_10-53-06AM/installActions2021-03-11_10-53-06AM.log. Oracle reco
mmends that if you want to keep this log, you should move it from the temporary location.
失败，因为没有使用--privileged
[oracle@c0996a2a0138 Disk1]$ ./runInstaller -silent -responseFile response/oggcore.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 25498 MB Passed
Checking swap space: 0 MB available, 150 MB required. Failed <<<<
Some requirement checks failed. You must fulfill these requirements before
continuing with the installation,
Exiting Oracle Universal Installer, log for this session can be found at /tmp/OraInstall2021-03-11_10-22-12AM/installActions2021-03-11
_10-22-12AM.log
问题：swap空间没有
https://blog.youkuaiyun.com/qq_35893120/article/details/80655645
[oracle@c0996a2a0138 ogghome]$ su - root
Password:
[root@c0996a2a0138 ~]# dd if=/dev/zero of=/swapfile bs=1024 count=512k
524288+0 records in
524288+0 records out
536870912 bytes (537 MB) copied, 1.73282 s, 310 MB/s
[root@c0996a2a0138 ~]# mkswap /swapfile
mkswap: /swapfile: warning: don't erase bootbits sectors
on whole disk. Use -f to force.
Setting up swapspace version 1, size = 524284 KiB
no label, UUID=bd389b64-a142-4583-9e27-da465ddc197c
[root@c0996a2a0138 ~]# swapon /swapfile
swapon: /swapfile: swapon failed: Operation not permitted
又有问题：
使用–privileged选项运行容器
4.源端Oracle配置
--创建独立的表空间
create tablespace ATMV datafile '/home/oracle/app/oracle/oradata/helowin/ATMV.dbf' size 100m autoextend on next 50m maxsize unlimited;
--创建ogg_test用户，密码也为ogg_test
create user ogg_test identified by ogg_test default tablespace ATMV;
--给ogg_test赋予充分的权限
grant connect,resource,dba to ogg_test;
--检查附加日志情况
Select SUPPLEMENTAL_LOG_DATA_MIN, SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI, SUPPLEMENTAL_LOG_DATA_FK, SUPPLEMENTAL_LOG_DATA_ALL from v$database;
--增加数据库附加日志
alter database add supplemental log data;
alter database add supplemental log data (primary key, unique,foreign key) columns;
--rollback
alter database drop supplemental log data (primary key, unique,foreign key) columns;
alter database drop supplemental log data;
--全字段模式，注意：在该模式下的delete操作也只有主键值，如果需要其他值，须在source端extract配置NOCOMPRESSDELETES
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
--开启数据库强制日志模式
alter database force logging;
--安装sequence support
--@sequence.sql 这一步失败了，不用管
[oracle@c075234ac240 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Mar 11 13:16:25 2021
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @sequence.sql
SP2-0310: unable to open file "sequence.sql"
SQL> alter table sys.seq$ add supplemental log data (primary key) columns;
Table altered.
SQL>
5.源端Ogg mgr进程配置
Version 11.2.1.0.3版本的OGG需要执行这些内容
GGSCI (c075234ac240) 2> edit params mgr
PORT 7839
DYNAMICPORTLIST 7840-7849
USERID ogg_test, PASSWORD ogg_test
PURGEOLDEXTRACTS ./dirdat/*, USECHECKPOINTS, MINKEEPDAYS 7
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45
PURGEDDLHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 7
PURGEMARKERHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 7
GGSCI (c075234ac240) 3> start mgr
Manager started.
GGSCI (c075234ac240) 4> info mgr
Manager is running (IP port TCP:c075234ac240.7839, Process ID 1207).
扫一扫
1051
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
