Oracle Goldengate Monitor12c安装配置指南12.1.3

Oracle12c安装和配置1.1配置内核参数添加如下行：fs.file-max = 6815744kernel.sem = 250 32000 100 128kernel.shmmni = 4096kernel.shmall = 1073741824kernel.shmmax = 4398046511104kernel.panic_on_oops = 1net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576net.ipv4.conf.all.rp_filter = 2net.ipv4.conf.default.rp_filter = 2fs.aio-max-nr = 1048576net.ipv4.ip_local_port_range = 9000 65500 运行sysctl -p命令更改当前内核参数1.2限制oracle用户资源使用vi /etc/security/limits.conf添加如下行：oracle soft nofile 1024oracle hard nofile 65536 oracle soft nproc 16384 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768 oracle hard memlock 134217728 oracle soft memlock 1342177281.3安装依赖软件包yum install binutils -yyum install compat-libcap1 -yyum install compat-libstdc++-33 -yyum install compat-libstdc++-33.i686 -y yum install glibc -yyum install glibc.i686 -yyum install glibc-devel -yyum install glibc-devel.i686 -yyum install ksh -yyum install libaio -yyum install libaio.i686 -yyum install libaio-devel -yyum install libaio-devel.i686 -yyum install libX11 -yyum install libX11.i686 -yyum install libXau -yyum install libXau.i686 -yyum install libXi -yyum install libXi.i686 -yyum install libXtst -yyum install libXtst.i686 -yyum install libgcc -yyum install libgcc.i686 -yyum install libstdc++ -yyum install libstdc++.i686 -yyum install libstdc++-devel -yyum install libstdc++-devel.i686 -y yum install libxcb -yyum install libxcb.i686 -yyum install make -yyum install nfs-utils -yyum install net-tools -yyum install smartmontools -yyum install sysstat -yyum install unixODBC -yyum install unixODBC-devel -y1.4创建新组和新用户groupadd -g 54321 oinstallgroupadd -g 54322 dbagroupadd -g 54323 operuseradd -u 54321 -g oinstall -G dba,oper oracle2附加设置2.1为oracle用户设置密码2.2修改设置SELINUXvi /etc/selinux/config## 将`SELINUX`修改为permissiveSELINUX=permissivesetenforce Permissive2.3确保禁用防火墙systemctl stop firewalldsystemctl disable firewalld2.4创建Oracle安装目录mkdir -p /usr/local/products/oracle12cchown -R oracle:oinstall /usr/localchmod -R 775 /usr/local/2.5配置Oracle环境变量并验证切换到新添加的oracle用户名下，在oracle用户下配置环境变量su oraclevi .bash_profileexport TMP=/tmpexport TMPDIR=$TMPexport ORACLE_HOSTNAME=DEV-ORACLE-12C-164export ORACLE_UNQNAME=orclexport ORACLE_BASE=/usr/local/productsexport ORACLE_HOME=$ORACLE_BASE/oracle12cexport ORACLE_SID=orclexport PATH=/usr/sbin:/usr/local/bin:$PATHexport PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib使配置立即生效source .bash_profileecho $ORACLE_HOME/usr/local/products/oracle12c3 Oracle安装3.1上传解压将下载的linuxx64_12201_database.zip上传到Linux系统/home/oracle目录下解压unzip linuxx64_12201_database.zip如果没有unzip要先安装yum install zip unzip3.2修改响应文件压缩包解压完成后得到名为database的文件夹，其中包含安装文件。

goldengate如何安装和配置要安装goldengate，第一步当然要先下载软件，您可以到/网站上下载相关软件，注意goldengate是在oracle fusion middleware大类下面，它和操作系统版本，数据库版本都有关系，下载时注意别下错版本。

对于源端数据库，要做以下准备，这里以oracle为例，其它数据库请查找相关手册：a.在源端操作系统上，创建GoldenGate系统用户，设置该用户环境变量（如果是oracle数据库的话，ORACLE_SID,ORACLE_HOME等等），也可以采用oracle 安装用户运行GoldenGate。

建议采用oracle的安装用户安装运行GoldenGate，无需建立新用户，否则还得给新用户授一堆权限，具体请参考安装手册。

b.在数据库中创建GoldenGate数据库用户，名称无所谓，这里以goldengate 为例，用户至少应该有connect,resource,select any dictionary,select any table的权限，当然如果能给dba，一切就都覆盖了：CREATE USER goldengate IDENTIFIED BY goldengate;GRANT dba TO goldengate;c.检查源端数据库是否为归档模式，若为非归档模式，建议将其改为归档模式，其实在非归档模式下也能运行，但以防万一，还是配置归档保险：SQL> alter database archivelog;(需要在数据库mount状态下执行)；SQL>archive log list;d.检查源端数据库附加日志是否打开SQL>select supplemental_log_data_min from v$database;将数据库附加日志打开SQL>alter database add supplemental log data;切换日志以使附加日志生效：SQL〉ALTER SYSTEM ARCHIVE LOG CURRENT;在目标数据库上，也需要建立一个goldengate用户，或者利用现有用户也行，该用户应该至少有connect,resource,select any table,select any dictionary以及对应同步表的insert/update/delete权限。

Centos7Oracle12C超详细安装[1] 先决环境Install Desktop Environment, refer to here.[2] Install required packages.[root@dlp ~]# yum -y install binutils compat-libcap1 gcc gcc-c++ glibc glibc.i686 glibc-devel glibc.i686 ksh libaio libaio.i686 libaio-devel libaio-devel.i686 libgcc libgcc.i686 libstdc++ libstdc++l7.i686 libstdc++-devel libstdc++-devel.i686 compat-libstdc++-33 compat-libstdc++-33.i686 libXi libXi.i686 libXtst libXtst.i686 make sysstat[3] Edit Kernel parameters.[root@dlp ~]# MEMTOTAL=$(free -b | sed -n '2p' | awk '{print $2}')[root@dlp ~]# SHMMAX=$(expr $MEMTOTAL / 2)[root@dlp ~]# SHMMNI=4096[root@dlp ~]# PAGESIZE=$(getconf PAGE_SIZE) [root@dlp ~]# cat >> /etc/sysctl.conf << EOFfs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmmax = $SHMMAXkernel.shmall = `expr \( $SHMMAX / $PAGESIZE \) \* \( $SHMMNI / 16 \)`kernel.shmmni = $SHMMNIkernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576EOF [root@dlp ~]# sysctl -pfs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmmax = 6274715648 kernel.shmall = 392169728 kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576[4] Create user and groups for Oracle Database service.[root@dlp ~]# i=54321; for group in oinstall dba backupdba oper dgdba kmdba; dogroupadd -g $i $group; i=`expr $i + 1` done [root@dlp~]#useradd-u1200-goinstall-Gdba,oper,backupdba,dgdba,kmdba -d /home/oracle oracle[root@dlp ~]# passwd oracle Changing password for user oracle. New password: Retype new password:passwd: all authentication tokens updated successfully. [root@dlp ~]# mkdir -p /u01/app/oracle [root@dlp ~]# chown -R oracle:oinstall /u01/app [root@dlp ~]# chmod -R 775 /u01[root@dlp ~]# vi /etc/pam.d/login # near line 14: add1 2 session required pam_selinux.so open session required pam_namespace.so1 s ession required pam_limits.so1 2 3 session optional pam_keyinit.so force revoke session include system-auth -session optional pam_ck_connector.so[root@dlp ~]# vi /etc/security/limits.conf # add to the end1 2 3 4 5 6 oracle softnproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 oracle soft stack 10240 oraclehardstack 32768[5]图形化安装Oracle 12C Login with the user "oracle" and set environment variables.dlp login: oracle Password:[oracle@dlp ~]$ vi ~/.bash_profile # add to the end umask 022export ORACLE_BASE=/u01/app/oracle # create a temporary directory for installation[oracle@dlp ~]$ mkdir tmp[1]Login and work with oracle admin user which you create in pre-requirements settings.[2] Download Oracle Databse 12c for Linux and upload on your server. ?/technology/software/products/database/index.html [3] After uploading Oracle files, move to a tmp directory and run an Installer like follows.[oracle@dlp ~]$ cd tmp [oracle@dlp tmp]$ unzip linuxamd64_12102_database_1of2.zip [oracle@dlptmp]$unziplinuxamd64_12102_database_2of2.zip[oracle@dlp tmp]$ ./database/runInstaller[4] Oracle Installer starts like follows. First, Set your email address and password for receiving some infomation from Oracle likesecurity issues and so on.[5] On this example, Select "Install database software only".[6] On this example, Select "Single Instance Database ***".[7] Select your language.[8] Select which edition you install.[9]Specify the base directory and files for Oracle. On this example, keep default and proceed to next.[10]Specify the installed directory. On this example, keep default and proceed to next.[11]Specify the priviledged group. On this example, keep default and proceed to next.[12] Pre-requirements are checked. If some settings are not configuredfor recomendations, notification is displayed likefollows.Confirm them again.[13]The summary is shown for configuration. Click "Install" if it's OK all.[14] Installation starts.[15]Following screen is shown, then open a terminal and execute follwong commands with the root user.[root@dlp ~]# /u01/app/oraInventory/orainstRoot.sh1 2 Changing permissions of /u01/app/oraInventory. Adding read,write permissions for group.3 4 5 6 7Removing read,write,execute permissions for world. Changing groupname of /u01/app/oraInventory to oinstall. The execution of the script is complete. [root@dlp ~]# [root@dlp~]#/u01/app/oracle/product/12.1.0/dbhome_1/root.sh12345Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/12.1.0/dbhome_1 Enter the full pathname of the local bin directory: [/usr/local/bin]: # Enter12 3 4 5 6 7 8 9 10Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... Creating /etc/oratab file...Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script.Now product-specific root actions will be performed.[16] Installation completed. Click "Close" button.[17] Set Environment variables for Oracle user.[oracle@dlp ~]$ vi ~/.bash_profile # add to the end exportORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1exportPATH=$PATH:$ORACLE_HOME/bin[oracle@dlp~]$ source ~/.bash_profile[oracle@dlp ~]$ rm -rf tmp创建监听Create Oracle Net Listener that is the network service onOracle.[1]Login with the oracle admin user and input a command "netca" like follows.[oracle@dlp ~]$ netca[2] Check a box "Listener Configuration" and go next.[3] Go next.[4] Set Listner's name. Input any one you like.[5] This example goes next with keeping default "TCP".[6] Set a port. This example goes next with keeping default.[7]If you'd like to create more Listeners, Answer "Yes". This example selects "No".[8] Configuration completed.[9]After creating Listener, tnslsnr listens on the port you configured like follows.[oracle@dlp ~]$ ss -napt123456789StateRecv-QSend-QLocalAddress:Port Peer Address:Port LISTEN 0 128 *:22 *:* LISTEN 0 128 127.0.0.1:631 *:* LISTEN 0 100 127.0.0.1:25 *:* ESTAB 0 52 10.0.0.30:22 10.0.0.5:50113 LISTEN 0 128 :::1521 :::* users:(("tnslsnr",3988,9)) LISTEN 0 128 :::22 :::* LISTEN 0 128 ::1:631 :::*LISTEN 0 100 ::1:25 :::* [oracle@dlp ~]$ tnsping localhost 12TNS Ping Utility for Linux: Version 12.1.0.2.0 - Productionon 04-JUL-2015 01:03:0734567891 0 Copyright (c) 1997, 2014, Oracle. All rights reserved. Used parameter files:Used HOSTNAME adapter to resolve the alias Attempting to contact(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADD RESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))OK (0 msec)创建数据库 Create a Database.[1] Login with the oracle admin user and input acommand "dbca" like follows.[oracle@dlp ~]$ dbc[2] Select "Create Database" and go next.[3] On this example, select "Advanced Mode" and go next.[4] This example selects "General Purpose ***" and go next.[5]Set Grobal Database name and SID like follows. Input any one you like.[6] This example goes next with keeping default.[7] Set passwords. Please set a password for a user for security.[8] Configure Listener. On this example, keep default and go next.[9]Configure Storage settings. On this example, keep default and go next.[10]Configure sample schema and scripts. If you'd like to add them, Set them.[11] Configure memory settings. After setting, go to next tab.[12] Specify max processes.[13] Set Character setting.[14] Select a connection mode. If your server does not have many clients, Select Dedicated server mode. If your server has manyclients, Select Shared server mode.[15] Go next.[16] Configuration completed. Click "Finish" button to finish.[17] Database creation starts.[18] After completing to create a database, Click "Close" to finish.[19] Add Database SID to the environment variables.[oracle@dlp ~]$ vi /etc/oratab # change like followsdlp:/u01/app/oracle/product/12.1.0/dbhome_1: Y [oracle@dlp ~]$ vi ~/.bash_profile # add to the endexport ORACLE_SID=dlpTo access to the Enterprise Manager, it's possible to manage Database on Web GUI.[1] After creating database, database service is running and it'spossible to access to Enterprise Manager, too. Access to the URL which was displayed when database creation finished, then Login form is shown and it's possible to login with a database user.[2] Just logined. It's possible to manage Database on here.Create Systemd file for Oracle Database services.[1] Login as root user and create Systemd files.[root@dlp ~]# vi /etc/sysconfig/dlp.oracledb # create new : define environment variablesORACLE_BASE=/u01/app/oracleORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1ORACLE_SID=dlp # configure listener service[root@dlp~]#vi/usr/lib/systemd/system/*******************#thisis an example, modify for free12 3 4 5 6 7 8 9 10 11 12 13[Unit]Description=oracle net listener After=network.target [Service] Type=forkingEnvironmentFile=/etc/sysconfig/dlp.oracledbExecStart=/u01/app/oracle/product/12.1.0/dbhome_1/bin/lsnrctl start ExecStop=/u01/app/oracle/product/12.1.0/dbhome_1/bin/lsnrctl stop User=oracle [Install] WantedBy=multi-user.target # configure database service[root@dlp~]#vi/usr/lib/systemd/system/********************#this is an example, modify for free1 2 3 4 5 6 7 8 9 10 11 12 13 [Unit]Description=oracle net listenerAfter=network.target lsnrctl.service [Service] Type=forkingEnvironmentFile=/etc/sysconfig/dlp.oracledbExecStart=/u01/app/oracle/product/12.1.0/dbhome_1/bin/dbstart /u01/app/oracle/product/12.1.0/dbhome_1ExecStop=/u01/app/oracle/product/12.1.0/dbhome_1/bin/dbshut /u01/app/oracle/product/12.1.0/dbhome_1 User=oracle [Install] WantedBy=multi-user.target[root@dlp ~]# systemctl daemon-reload[root@dlp ~]# systemctl enable dlp@lsnrctl dlp@oracledb。

Oracle12c在Win10上的安装配置实践1、环境操作系统：Win10专业版（64位）数据库：Oracle 12c Release 2（Version 12.2.0.1.0，64位）2、下载Oracle12c3、安装3.1、右键以管理员⾝份运⾏setup.exe3.2、配置安全更新在安装界⾯⾥，取消勾选“我希望通过My Oracle Support接收安全更新”，点击下⼀步。

提⽰出现尚未提供电⼦邮件地址，选择是。

3.3、安装选项选择“创建和配置数据库”（默认），点击下⼀步。

3.4、系统类选择“桌⾯类”（默认），如果是安装到服务器上，请选择“服务器类”，点击下⼀步。

3.5、Oracle主⽬录⽤户使⽤虚拟账户：⽤于 Oracle 数据库单实例安装的 Oracle 主⽬录⽤户。

使⽤现有windows⽤户：如果选择该项，则需要指定没有管理权限的⽤户。

创建新Windows⽤户：创建⼀个新⽤户，输⼊⽤户名和密码，这个新建的⽤户没有Windows登录权限。

使⽤Windows内置账户：微软在开Windows时预先为⽤户设置的能够登录系统的账户。

此处本⼈选择虚拟账户，也是oracle的官⽅建议之⼀。

注意：如果选择第⼆项，创建的⽤户名和已有的不能发⽣冲突，否则后⾯的安装会报错！3.6、典型安装设置oracle安装位置，字符集选择AL32UTF8或者ZHS16GBK，设置密码，如果密码过于简单会报警告，忽略即可，点击下⼀步。

注意：字符集AL32UTF8，sqlplus会存在乱码问题，需要配置TNS环境变量。

本⽂后⾯有字符集如何更改相关内容。

图省事的话建议此处选择ZHS16GBK字符集。

3.7、先决条件检查3.8、概要3.93.104、测试Oracle是否安装成功两种⽅式4.1、SQL Plus4.2、em5、相关问题5.1、PLSQL Developer⽆法连接64位Oracle数据库5.1.1、PLSQL数据库选项为空如图所⽰：原因在于：PLSQL不可以直接连接64位Oracle数据库，只能连接32位的。

1.安装goldengate monitor java -jar fmw_12.2.1.0.0_ogg.jar2.配置数据库cd /ggmonitor/Oracle/Middleware/Oracle_Home/oracle_common/bin ./rcu在数据库创建用户为上一步创建的用户设置密码a123456为新用户创建表空间3.配置域cd /ggmonitor/Oracle/Middleware/Oracle_Home/oracle_common/common/bin ./config.sh配置weblogic密码weblogic123使用第2步配置的用户名DEV3_STB密码a123456输入用户名和密码均为zxWEB.JMX.PASSWORD jmxuser oracleMONITOR.KEYSTORE.PASSWORD keystoreuser oracle MONITOR.TRUSTSTORE.PASSWORD truststoreuser oracle WEB.SMTP.EMAIL.PASSWORD emailuser oracleMONITORSERVER_server1(第5步要用)/ggmonitor/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domainhttp://192.168.56.2:7001/console4.配置monitor servercd /ggmonitor/Oracle/Middleware/Oracle_Home/oggmon/monitor_server/bin./updateOGGMonitorConfig.sh[oracle@rhel6 bin]$ ./updateOGGMonitorConfig.shThis script utility is used to update configuration information for monitor server. All feilds are mandatory. Press Ctrl+C to exit.Enter absolute path for oggmon domain:/ggmonitor/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domainYou have entered the domain path as : /ggmonitor/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domainEnter JMX HOST NAME/IP:192.168.56.2Enter JMX Server Port:6502Enter JMX Server Username:jmxuserEnter the database type for Monitor Installation.For Oracle Database, Press 1. For SQL Server, Press 2:1Jul 08, 2016 3:57:13 PM oracle.security.jps.JpsStartup startINFO: Jps initializing.log4j:WARN No appenders could be found for logger (org.jboss.logging).log4j:WARN Please initialize the log4j system properly.Jul 08, 2016 3:57:27 PM oracle.security.jps.JpsStartup startINFO: Jps started.Jul 08, 2016 3:57:29 PM oracle.security.audit.Auditor initWARNING: IAU:IAU-6012: Unable to determine the audit log directory. No log directory specified. Jul 08, 2016 3:57:29 PM oracle.security.jps.util.JpsUtil disableAuditINFO: JpsUtil: isAuditDisabled set to trueJul 08, 2016 3:57:29 PM oracle.security.jps.internal.audit.AuditServiceImpl validateLogPossible WARNING: No audit log directory is set. Cannot perform audit operations for component JPS.Created Secure Key properties file.Added Secure Key into Monitor Server Oracle Wallet.5.启动monitor server5.1启动weblogic administrator servercd /ggmonitor/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain./startWebLogic.sh输入第3步设置的weblogic/weblogic123用户名和密码ie打开http://192.168.56.2:7001:/console5.2启动WebLogic Managed Servercd /ggmonitor/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/bin./startManagedWebLogic.sh MONITORSERVER_server1 http://192.168.56.2:7001输入第3步设置的weblogic/weblogic123用户名和密码ie打开http://192.168.56.2:7003/monitor/faces/loginPage.jspx6.配置monitor server用户登录weblogic 管理界面新建ggmon 密码ggmon123配置所属组登录monitor serverhttp://192.168.56.2:7003/monitor/faces/loginPage.jspx ggmon/ggmon1237.安装配置monitor agent7.1安装monitor agent 已在第1步中安装/ggmonitor/Oracle/Middleware/Oracle_Home/oggmon/ogg_agent7.2配置cd /ggmonitor/Oracle/Middleware/Oracle_Home/oggmon/ogg_agent./createMonitorAgentInstance.sh[oracle@rhel6 ogg_agent]$ ./createMonitorAgentInstance.shPlease enter absolute path of Oracle GoldenGate home directory : /goldengatePlease enter absolute path of OGG Agent instance : /goldengate/ggmon/gg_agentPlease enter unique name to replace timestamp in startMonitorAgent script (startMonitorAgentInstance_20160708115016.sh) : 回车Sucessfully created OGG Agent instance.7.2.1把oggmon.properties复制到agent端cp/ggmonitor/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/config/mo nitorserver/cfg/oggmon.properties /goldengate/ggmon/gg_agent/cfg/7.2.2编辑Config.propertiescd /goldengate/ggmon/gg_agent/cfg/vi Config.propertiesjagent.host=192.168.56.2jagent.jmx.port=5555interval.regular=60interval.quick=30monitor.host=192.168.56.2monitor.jmx.port=6502ername=jmxuserername=rootreg.retry.interval=10instance.query.initial.interval=5incremental.registration.quiet.interval=5maximum.message.retrieval=500jagent.rmi.port=5559agent.type.enabled=OGGMONstatus.polling.interval=5message.polling.interval=5reg.retry.times=-1patibility=falsejagent.ssl=falsejagent.keystore.file=jagentKeyStorejagent.truststore.file=jagentKeyStorejagent.restful.ws.timeout=15000jagent.ggsci.timeout=307.2.3 Create Wallet Credentials[oracle@rhel6 bin]$ ./pw_agent_util.sh -createPlease create a password for Java Agent: oraclePlease confirm password for Java Agent: oraclePlease enter Monitor Server JMX password: oraclePlease confirm Monitor Server JMX password: oracleJul 08, 2016 12:09:07 PM oracle.security.jps.JpsStartup startINFO: Jps initializing.Jul 08, 2016 12:09:08 PM oracle.security.jps.JpsStartup startINFO: Jps started.Wallet is created successfully.7.2.3 Prepare the Oracle GoldenGate Monitor Agent Instance for Monitoring1. Create a file named GLOBALS in the OGG_HOME directory, if this file does not exist.2. Edit the GLOBALS file.3. Add ENABLEMONITORING on a new line.4. Close and save the file.5. Create the datastore using the CREATE DATASTORE command:GGSCI> CREATE DATASTOREGGSCI (rhel6) 2> CREATE DATASTORE2016-07-08 12:17:47 INFO OGG-06489 Datastore created.7.2.4 Start the Oracle GoldenGate Monitor AgentGo to the Oracle GoldenGate Core GGSCI console and start Oracle GoldenGateMonitor Agent by executing the start jagent command:GGSCI>start jagent7.2.5 Check Oracle GoldenGate Monitor Agent Instance Log FilesOnce you have completed the preceding steps and Oracle GoldenGate Monitor Agentis running, the Oracle GoldenGate Monitor Agent log details will be written to ogg_agent.log, which is in OGG_AGENT_INST_HOME/logs.8.查看监控页面。

Oracle GoldenGate主要由如下一些组件组成● Extract● Data pump● Replicat● Trails or extract files● Checkpoints● Manager● Collector1、Data Pump是一个次级的Extract Group,如果你的GG环境中不使用Data Pump的话，那么Primary Extract Group必须直接将trail通过网络写到Target系统上.参见后面的示例6:配置Data Pump实现一对多拓扑方案.2、默认情况下,Replicat是实时复制的,如果因为某种需要需要延迟复制的话,那么可以通过Replicat Group的如下DEFERAPPLYINTERVAL参数来控制，该参数允许delay的最大时间是7天。

按照Oracle GoldenGate的工作原理和体系结构,在每个复制数据源和目标端都需要安装一套GoldenGate软件,同时需要分别启动一个 GoldenGate实例,一个GoldenGate实例就是一个管理进程(Manager process),这个管理进程也是整个GoldenGate实例运行时最主要的控制进程。

GoldenGate操作系统内存的使用是通过操作系统来控制的,而不是通过GoldenGate程序控制的,GoldenGate进程会根据需要从OS 那里分配相应的virtual memory.●GoldenGate GGSCI命令接口工具对于每个GoldenGate实例可以支持并发300个Extract和Replicat进程。

●每个Extract和Replicat进程需要大约25-55 MB内存,这主要取决于transaction的大小和并发的transaction数量。

所以,根据上面2个条件,GoldenGate对操作系统内存的需求主要取决于Extract和Replicat进程数。

工作目录每个GoldenGate实例的工作目录(working directories and binaries),大约需要40M的空间,如果你要同一台Server安装多个GoldenGate实例到不同的目录/文件系统下话,那么就需要多倍的空间分配,在考虑空间分配的时候,也需要考虑这个因数。

ORACLE GoldenGate搭建实验实验环境说明：操作系统版本：Red hat Enterprise 6.5（Linux系统）Windows Server 2012R2（Windows系统）数据库ORACLE版本：11.2.0.4Goldengate版本：12.1.2.1.0一、GoldenGate搭建前的准备工作1.1Goldengate软件下载建议去ORACLE官网下载，根据需要下载不同版本的GoldenGate软件，本次试验下载的GoldenGate软件版本是12.1.2.1.01.2数据库配置1.2.1创建ORACLE GoldenGate的管理用户--创建管理用户所对应的表空间SQL>create tablespace oggtb datafile '/oradata/ogg01.dbf' size 1000M autoextend on next 5M maxsize unlimited;--创建管理用户ogg,源端用户ogg1，目标端用户ogg2SQL>create user ogg identified by oggtest default tablespace oggtb;SQL>create user ogg1 identified by ogg1 default tablespace oggtb;SQL>create user ogg2 identified by ogg2 default tablespace oggtb;--给用户授权SQL>grant connect,resource,dba to ogg;SQL>grant connect,resource,dba to ogg1;SQL>grant connect,resource,dba to ogg2;1.2.2开启数据库归档--查看当前数据库是否开启归档。

Oracle GoldenGate 12c for Oracle Database 12cJagdev DhillonVice PresidentNick WagnerProduct ManagerSafe Harbor StatementThe following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.Program Agenda1 2 3 4 Oracle GoldenGate 12.1.2 Review Oracle GoldenGate 12.1.2.1 New Features Streams to GoldenGate ConversionsQ&AOracle GoldenGate 12c Generic Enhancements•DDL Trigger is no longer needed–Works with Oracle 11.2.0.4 and up and requires Integrated Extract–Works with Oracle Standard Edition as well as Enterprise Edition•DISCARDFILE now has defaults, and no longer needs to be specified for each Replicat •Improved Schema Wildcard resolution within the parameter files–Only captures first TABLE parameter for SCOTT.EMP DMLTABLE SCOTT.EMP, COLMAP(…);TABLE *.EMP;•Oracle 12c Expanded Data Type Support–Support for VARCHAR2 / NVARCHAR2 / RAW MAX options (32k length)Integrated Replicat•Integrated Replicat for Oracle target databases only–11.2.0.4 and 12c (12.1.+)•Leverages database parallel apply servers for automatic dependency aware parallel apply•Minimal changes to replicat configuration–Single replicat parameter file for all tables–No split transaction semanticsIntegrated ReplicatInbound Server (Database Apply Process) Delivery Lightweight Streaming API Receiver Preparer Coordinator Inbound Server Applier NApplier 2 Applier 1 Oracle DatabaseDelivery Delivery Delivery Delivery Customer defined splitSQL SQLSQL SQLTargetOracle and Non-Oracle DatabasesMAP sales.acct1, TARGET sales.acct1; MAP sales.acct2, TARGET sales.acct2; MAP sales.acct3, TARGET sales.acct3;Trail Files Thread Customer defined split SQL SQLSQLSQL Single replicationprocess forcustomerGoldenGatecoordinatesthread for barrieroperations TargetOracle and Non-Oracle DatabasesMAP sales.acct1, TARGET sales.acct1, THREAD (2); MAP sales.acct2, TARGET sales.acct2, THREAD (3); MAP sales.acct,3 TARGET sales.acct3, THREADANGE (4-9);Credential Store/Oracle Wallet•Oracle Wallet and Credential Store functionality now built into the Oracle GoldenGate Installation•Credential Store for storing usernames and passwords•Once a credential has been added to the wallet–Remove USERID, MININGDBUSERID, etc–Replace with USERIDALIAS, MININGDBUSERIDALIAS, etcHA Features for GoldenGate in 12.1.2•Oracle Active Data Guard and Oracle GoldenGate High-Availability Best Practices [CON7715]–Tuesday, Sep 30, 10:45 AM - 11:30 AM- Moscone South – 308•Full Integration with ASYNC FSFO–GoldenGate can now safely follow bounded data-loss failovers–Support enabled in Integrated Extract with the addition of the following parameter:TRANLOGOPTIONS HANDLEDLFAILOVER•Works for Oracle DB 11g and 12c•Full integration with Oracle’s XAG–XAG allows you to register a GoldenGate instance to improve HA–XAG provides increased availability in the face a loss of an instance or Primary databaseProgram Agenda1 2 3 4 Oracle GoldenGate 12.1.2 Review Oracle GoldenGate 12.1.2.1 New Features Streams to GoldenGate ConversionsQ&A12.1.2.1 Major Enhancements•Capture Enhancements–Integrated Extract Enhancements–Certification for Oracle 12.1.0.2 and In-Memory Database (IMDB) –Support for Capturing from ADG Standby database •Integrated Delivery Enhancements–Dependency Aware Batching–DDL and DML Handlers–Error Queue Support•Support for multiple Editions (Edition Based Redefinition) •Column Level Character Set Support•SOCKS 5 SupportIntegrated Extract Specific Enhancements•Continues to support Oracle SE and EE databases•Improved Startup Performance and Scalability (shared mining dictionary) •Tagged transaction can be excluded for Active-Active replication–EXCLUDETAG•Create Table As Select… can be applied as DDL + DML rather than DDL –TRANLOGOPTIONS GETCTASDML•Added redo log capture for ANYDATA and UDTs–TRANLOGOPTIONS USENATIVEOBJSUPPORT•Support for Edition Based Redefinition and multiple editionsClassic Extract can now capture from an ADG Standby database •Extract can be configured to run on the Standby Database•Configuration on the Primary database–Setup DDL capture (optional)–Configure Supplemental log data•Configuration on the Standby database–USERID Parameter points to the Primary database (USERID username@primary ) –Set TRANLOGOPTIONS MINEFROMACTIVEDGShared Logminer Dictionary•REGISTER EXTRACT ecap DATABASE•REGISTER EXTRACT ename DATABASE SHARE ecap–Ename is created as a “clone” of ecap–2nd extract (ename) uses same internal dictionary as ecap•Fast start of 2nd extract (no dictionary processing required)•Single extract does dictionary maintenance•REGISTER EXTRACT eother DATABASE SCN startatscn SHARE ecap –SCN parameter meaning is different when combined with SHAREEXCLUDETAG Functionality•TRANLOGOPTIONS EXCLUDETAG takes a single string value, but allows multiple lines to specify multiple tags•Extend EXCLUDETAG to exclude any tagged operation–EXCLUDETAG +–Similar to Streams is_null_tag setting.•Filtering of tagged transactions can be done in the Extract pump and REPLICAT12.1.2.1 Integrated Delivery Enhancements Dependency-Aware Batching for Integrated Replicat•Through the use of INTEGRATEDPARAMS BATCHSQL_MODE–Controls the ordering of transactions in BATCHSQL mode–Options:•SEQUENTIAL – transaction batched in sequential order•DEPENDENT – Dependency grouping, schedule when no active dependencies•DEPENDENT_EAGER – dependency grouping but allow scheduling when there are active dependencies–Default is DEPENDENT for Oracle 12.1.0.2–Requires new OGG/RDBMS bundled patch (bp2) but not available for 11.2.0.4.•Without patch, default is SEQUENTIAL•COMMIT_SERIALIZATION=FULL sets BATCHSQL_MODE=SEQUENTIALIntegrated Replicat Apply Handler Configuration•Uses the same package calls to set up as Streams does–DBMS_APPLY_ADM package•DML: Set_dml_handler or Add_stmt_handler•DDL: Alter_apply–The scope of handler is dependent on the configuration•Per Table , Per Operation (Ins/Upd/Del)•It is associated with the Inbound Server (Integrated Replicat process inside thedatabase)•Operations processed by the DML/DDL handler will not be applied by the Replicat •Integrated Replicat needs to be stopped and restarted when adding or removing handlers.PL/SQL Update Handler on DEMO.ORDERS table BEGINDBMS_APPLY_ADM.SET_DML_HANDLER(object_name => '"DEMO"."ORDERS"',object_type => 'TABLE',operation_name => 'UPDATE',error_handler => FALSE, ## if FALSE, then the handler replaces normal apply processing, ## if TRUE, then the handler is only executed on error.user_procedure => 'DEMO.ORDERS_DML_HANDLER',apply_database_link => NULL,apply_name => NULL); ## If NULL, then handler is used for ALL apply & inbound servers END;/12.1.2.1 Integrated Delivery Enhancements Statement DML Handlers•Statement DML handlers are up to 4x faster than procedural DML handlers –Statement DML handlers should be used to replace SQLEXEC in the Replicat when possible •Easy to Use–SQL statements, rather than PL/SQL procedures–DBMS_APPLY_ADM.ADD_STMT_HANDLER•Creates handler with SQL statement AND•Registers to Apply process–DBMS_STREAMS_HANDLER_ADM package procedures•Create or Drop handler•Add or Remove statements to/from handler•Register with apply12.1.2.1 Integrated Delivery EnhancementsEnable Error Queue Handling•In older versions of OGG, if an error occurs it falls back and lets the Replicat retry the operation. If the OGG retry fails it abends•Allow DBMS_Apply_Adm.Execute_Error capability for Integrated Replicat to retry operations in the error queue. Handles whether is message is added to the error queue.–DBOPTIONS _NO_DISABLE_ON_RETRY_ERROR•Allow OGG to retry, but if OGG fails, continue processing. If OGG successfully applies transaction, OGG deletes error from queue. Default behavior.–DBOPTIONS _NO_DISABLE_OR_RETRY_ERROR•Disable OGG retry and continue processing, recommended with COMMIT_SERIALIZATION=FULLManaging Apply Errors12.1.2.1 Integrated Delivery EnhancementsEdition Based Redefinition•DDL Replication now supports CREATE/DROP EDITION–Replicat will grant the user permission to use if it exists on target•Extract will capture the EDITION NAME owner•Replicat will switch session to the EDITION owner before applying DDL •DDL operations on editions can be filtered as well–DDL INCLUDE ALL, EXCLUDE OBJTYPE EDITION•Support for Column Level Character Sets–For cases where a table has column(s) with a character set that is different from the database character set.–Use SOURCECHARSET to enable this functionality•In MAP / TABLE statements use CHARSET to use your own settings•In DEFGEN use COLCHARSET to use your own settings•Enhanced Cloud support–SOCKS v5 Support•SOCKet Secure is a protocol that supports routing between client and server •Allows authentication•SOCKS can encrypt all traffic between client and server•Alternative to VPN for cloud to on-premise or vice-versa–New parameter SOCKSPROXY•SOCKSPROXY host:port, [PROXYCSALIAS <alias> [, PROXYCSDOMAIN domain]]•Enhanced Cloud support–Example for sending trail data from on-premise to cloud.•GoldenGate installed on with manager port 9000•Firewall only allows incoming connections on SSH port.–Use SSH as SOCKS proxy server on-premise•ssh –i ssh-key –N –f –D 1080 ******************************.com•Port 1080 is the client port that will route to an OGG installation on –Extract Parameter file:•RMTHOST , MGRPORT 9000, SOCKSPROXY localhost:1080Program Agenda1 2 3 4 Oracle GoldenGate 12.1.2 Review Oracle GoldenGate 12.1.2.1 New Features Streams to GoldenGate ConversionsQ&AMOS 1912338.1 Oracle Streams to Oracle GoldenGate Conversion •Streams is now deprecated (as of Oracle 12c)•Designed to help existing Streams users convert their replication into Oracle GoldenGate replication.–The streams2ogg tool will generate the appropriate GoldenGate 12c configuration files allowing for an easier way to migrate the Streams implementation into a GoldenGate implementation.•This tool will help–Eliminate manual conversion errors–Minimize the GoldenGate learning curve for Streams customers–Implement GoldenGate best practicesMOS 1912338.1 Oracle Streams to Oracle GoldenGate Conversion•The streams2ogg migration tool is run at the database level–connecting to the Streams Administrator schema–Load and execute the streams2ogg package–Oracle GoldenGate Parameter files are produced•OGG configuration files can be generated to run on a different database or machine to allowing for testing and platform migrations.NOTE:This tool does not provide the environment or process for switching from Streams over to your GoldenGate implementation. And does not support complete conversion of the CDC (Change Data Capture) feature of Oracle DB. Ideally suited for environments where the source and target object structure is the same.Streams2oggMOS 1912338.1 Oracle Streams to Oracle GoldenGate Conversion •Database package streams2ogg–Download from MOS Doc ID 1912338.1•Load package as Streams Administrator and answer 2 questions –@streams2ogg–Name of Oracle GoldenGate administrator schema–Name of staging directory for storing the generated files•Run procedure from Streams Administrator schema using either: –exec streams2ogg.main–exec streams2ogg.customize (if performing customizations)•All generated files will be in the staging directory.Streams2ogg Files GeneratedFile Name Descriptione capname.prm Extract file name based on capture namep capname.prm Pump file name based on capture name/propagation namer appname.prm Replicat file name based on apply namemgr.prm Manager file name - contains PORT number,other OGG mgr Best Practiceparameters (These are not based on Streams configuration) handlers.sql Sql script to configure Streams handlers after replicat process isregistered (does not include handler code)streams2ogg.trc Debug/Trace file – always generatedstreams2ogg.rpt Report file – always generatedFile Name Descriptionggconfig.oby GGSCI obey file to create extract, pump, replicat processes ggconfig2.oby GGSCI obey file to create additional extract processes based on firstextract SCNggconfig_trandata.oby GGSCI obey file to configure database supplemental logging create_subdirectories.sh Shell script to generate directory structure under the trail file storagedirectoryreg_extract.sh Helper shell script for ggconfig2.oby OGG 12.1.2.0 Register extract….SCN optionwatch.sh, watch.sql watch_status.sql Helper shell and sql script for ggconfig2.oby for OGG 12.1.2.1 Register extract….SHARE optionwatch_status.sql can be used to get status of capture initializationogg_name_map.csv Comma-separated name/value pairs for customizing streams2ogg filegenerationStreams2ogg Files Generated (continued)Streams2ogg Post Execution StepsMOS 1912338.1 Oracle Streams to Oracle GoldenGate Conversion •Parameter files and obey files need to be edited–Choose method to login: dblogin or dbloginalias–For dblogin, set password•Pump parameter file also needs to identify the host name for the RMTHOST command–If PORT number is changed in mgr.port, modify port number in pump file, too. •wait.sh script needs sqlplus login passwordProgram Agenda1 2 3 4 Oracle GoldenGate 12.1.2 Review Oracle GoldenGate 12.1.2.1 New Features Streams to GoldenGate ConversionsQ&A。

Linux下安装Oracle12C详解Linux下安装Oracle12C详解本例操作系统版本：CentOS 7.8、数据库版本：Oracle 12c（12.201）安装步骤如下分解：主机信息hostname: ol7-122.localdomainhosts: 10.0.0.10 ol7-122.localdomain ol7-1221.关闭防⽕墙，禁⽌防⽕墙开机⾃启# 关闭防⽕墙systemctl stop firewalld.service# 禁⽌防⽕墙开机启动systemctl disable firewalld.service# 查看防⽕墙状态systemctl status firewalld.service2.关闭selinux# 编辑⽂件vi /etc/selinux/config# 修改内容SELINUX=disabled3.yum安装必要安装包使⽤ yum 批量安装依赖包，若执⾏⼀遍失败则继续执⾏第⼆遍（多次执⾏不会出现其他问题）yum install binutils -yyum install compat-libcap1 -yyum install compat-libstdc++-33 -yyum install compat-libstdc++-33.i686 -yyum install glibc -yyum install glibc.i686 -yyum install glibc-devel -yyum install glibc-devel.i686 -yyum install ksh -yyum install libaio -yyum install libaio.i686 -yyum install libaio-devel -yyum install libaio-devel.i686 -yyum install libX11 -yyum install libX11.i686 -yyum install libXau -yyum install libXau.i686 -yyum install libXi -yyum install libXi.i686 -yyum install libXtst -yyum install libXtst.i686 -yyum install libgcc -yyum install libgcc.i686 -yyum install libstdc++ -yyum install libstdc++.i686 -yyum install libstdc++-devel -yyum install libstdc++-devel.i686 -yyum install libxcb -yyum install libxcb.i686 -yyum install make -yyum install nfs-utils -yyum install net-tools -yyum install smartmontools -yyum install sysstat -yyum install unixODBC -yyum install unixODBC-devel -y检查是否安装成功（31个安装包）rpm -q binutils compat-libcap1 compat-libstdc++-33gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat unixODBC unixODBC-devel4.创建 swap详见⽂章：5.创建 oracle 分区（可选）如果你操作系统原有分区都合适，这步可以忽略# 查看硬盘及分区信息（启动Disk开头的就是硬盘，Device开头的就是分区）fdisk -l# 创建分区（/dev/sdb 是硬盘，是你需要创建分区的硬盘，创建分区后会⽣成 /dev/sdb1，如果本来有sdb1，则会出现sdb2）fdisk /dev/sdb# 格式化新创建的分区mkfs.xfs /dev/sdb1# 将分区添加到 /etc/fstab ⽂件中，使之开机⾃动挂载（编辑保存 fstab ⽂件后不会⽴即⽣效）vim /etc/fstab/dev/sdb1 /u01 xfs defaults 006.创建 oracle data ⽬录（同第5步可选）# 创建⽬录mkdir /u01# 重新加载⽂件 /etc/fstab 所有内容。

Oracle 12C 安装实例■ 陕西 王金国 解宝琦本实例所在的系统环境为：操作系统：CentOS7.5；数据库版本：12.1.0.2.0；主机名：Oracle 12C ；ORACLE_SID ：Oracle12c ；容器数据库：Oracle12cp db操作系统环境准备及数据库安装要点因为操作系统安装相关文章已经非常多了。

笔者认为安装Oracle 数据库的重点和难点在于操作系统环境准备部分以及补丁安装部分，因此将略过操作系统安装和数据库安装过程，重点详细描述以上环境准备和补丁安装内容。

1.安装centos7.5，安装过程中需要选择gnome 图形桌面，并配置磁盘为LVM 管编者按：Oracle 作为企业级数据库产品。

目前依然是各大中型企业数据库管理软件的翘楚。

本文以生产环境为应用场景。

详细阐述了CentOS7.5系统下Oracle 12C 数据库的安装及补丁升级涉及的重点过程，包含了完整的数据库日志模式启用及全库备份需要进行的配置，很好的满足了生产环境对Oracle 稳定性和日常备份的要求。

理模式。

便于未来数据增长后进行磁盘的动态扩展和管理。

2.操作系统参数配置及优化，使用vi/etc/sysctl.conf 命令编辑/etc/sysctl.conf 文件，并在文件末尾增加如图1所示。

fs.aio-max-nr 参数Oracle 默认设置为 1M 即 1048576,一般不用更改，其他参数具体详解可以参考Oracle 官方文档。

3.对Oracle 用户设置限制,提高软件运行性能，图1 具体命令通过命令vi etc/security/limits.conf 编辑该文件，并加入如下内容：oracle soft nofile 1024oracle hard nofile 65536o r a c l e s o f t n p r o c 2047o r a c l e h a r d n p r o c 16384o r a c l e s o f t s t a c k 10240o r a c l e h a r d s t a c k 327684.关联设置，通过命令vi /etc/pam.d/login，添加如下内容：s e s s i o n r e q u i r e d /l i b 64/s e c u r i t y /p a m _limits.sosession required pam_limits.so5.设置环境变量，通过命令vi etc/profile 添加如图2所示。