一、安装前工作: 1、根据官网建议修改游标数大到2000: SQL> show parameter cursor
NAME TYPE ------------------------------------ ---------------------- VALUE ------------------------------ cursor_bind_capture_destination string memory+disk cursor_sharing string EXACT cursor_space_for_time boolean FALSE open_cursors integer 300 session_cached_cursors integer
NAME TYPE ------------------------------------ ---------------------- VALUE ------------------------------ 50 SQL> alter system set open_cursors=2000;
System altered.
2、在oracle数据库中创建oggdirector的资料库用户及相应表空间
SQL> create tablespace ogg_director datafile '/oracle/oradata/orcl/ogg_director01.dbf' size 5g autoextend on next 128m;
Tablespace created.
SQL> create user diradmin identified by xxxx default tablespace ogg_director;
User created.
SQL> grant dba to diradmin;
Grant succeeded.
SQL> exit
3、安装weblogic,根据要求官网安装10.3至12.1.2版本,实际测试安装12.1.3版本就导致weblogic启动时提示用户密码认证失败无法启动。 本文档安装10.3.6版本为方便管理统一用oracle用户安装weblogic及ogg director [oracle@oggjk soft]$ xhost + access control disabled, clients can connect from any host [oracle@oggjk soft]$ java -jar wls1036_generic.jar Extracting 0%....................................................................................................100% 使用图形安装,不需要创建域。
4、ogg实例相应参数配置 连接12c的ogg时需要在mgr以及GLOBALS中配置相应参数。 To allow remote access of a Windows Manager from a Linux Oracle GoldenGate Director Server, you must add the following parameter to the OGG_HOME/GLOBALS parameter file: _DISABLEFIX21427144 Then add the following parameter in the OGG_HOME/dirprm/mgr.prm file to enable access:
ACCESSRULE, PROG *, IPADDR Target_IP_Address, PRI 1, ALLOW After the changes are configured, you must restart the Oracle GoldenGate Manager for these changes to take effect.
5、上传安装程序 gg-director-serversetup_unix_v12_1_2_0_2.zip gg-director-clientsetup_unix_v12_1_2_0_2.zip 解压并修改解压后的文件属主权限,并赋予+x执行权限给.sh文件
二、安装 1、安装director-server [oracle@oggjk soft]$ cd server/ [oracle@oggjk server]$ ls gg-director-serversetup_unix_v12_1_2_0_2.sh gg-director-serversetup_unix_v12_1_2_0_2.zip OGG_Director_12.1.2.0.2.pdf OGG_Director_Readme_12_1_2_0_2.txt [oracle@oggjk server]$ chmod +x gg-director-serversetup_unix_v12_1_2_0_2.sh [oracle@oggjk server]$ ./gg-director-serversetup_unix_v12_1_2_0_2.sh -c ----(-c)使用命令行方式安装,不加参数就是图形安装 Starting Installer ... This will install Oracle GoldenGate Director Server on your computer. OK [o, Enter], Cancel [c]
Choose Installation Location Where should Oracle GoldenGate Director Server be installed? [/home/oracle/GG_Directorgg-director] ---指定director安装目录, /ggdir The Directory: /ggdir already exists. Would you like to install to that directory anyway ? Yes [y, Enter], No [n]
Select your weblogic install location Weblogic Location: [/home/oracle] ---选择weblogic的home目录 /wls11g
Weblogic Version : 10.3.6.0
Weblogic Install Directory : /wls11g/wlserver_10.3
[Enter]
Choose HTTP Port HTTP Port [*****] [7001 ]
Select a Database ---选择数据库类型 SQL Server Database [1, Enter], MySql Enterprise Database [2], Oracle Database [3] 3 Database Driver Configuration Server Host Name: [localhost] ---必须指定ip地址或者域名 10.136.3.152 SID [1, Enter], Service Name [2] 2 [] orcl Database Port: [*****] [1521 ]
Database User User ID: [] diradmin ---指定director资料库的用户及密码,密码需要字母+数字 Password:
Pre-Installation Summary Please Review the Following Before Continuing: [Product Name:
Oracle GoldenGate Director Server
Install Folder:
/ggdir
Database:
Oracle Database
Available Disk Space:
15515009024 Bytes
Required Disk Space:
234275411 Bytes (Approx)
] ---回车确认 Progress Extracting files ...
.install4j/ .install4j/uninstall.png cds.jar createDomain.cmd createDomain.sh dbscripts.zip domain.jar gdsc-server.ear installDirSvc.cmd notices.txt run-cds-tool.bat run-cds-tool.sh scripts/ scripts/createDomain.cmd scripts/createDomain.sh scripts/installDirSvc.cmd scripts/run-cds-tool.bat scripts/run-cds-tool.sh scripts/uninstallDirSvc.cmd sqljdbc.jar template.jar uninstall uninstallDirSvc.cmd db/ db/Hypersonic/ db/My SQL/ db/Oracle/ db/SQL Server/ db/Hypersonic/create_indexes.sql db/Hypersonic/create_tables.sql db/Hypersonic/create_user.sql db/Hypersonic/drop_indexes.sql db/Hypersonic/drop_tables.sql db/Hypersonic/insert_data.sql db/Hypersonic/migrate-1.3.0.0.xml db/Hypersonic/migrate-1.4.0.0.xml db/My SQL/create_indexes.sql db/My SQL/create_tables.sql db/My SQL/create_user.sql db/My SQL/drop_indexes.sql db/My SQL/drop_tables.sql db/My SQL/insert_data.sql db/My SQL/migrate-1.3.0.0.xml db/My SQL/migrate-1.4.0.0.xml db/My SQL/migrate-11.1.1.0.xml db/My SQL/migrate-11.1.1.1.0.xml db/My SQL/migrate-11.1.1.1.1.xml db/My SQL/migrate-11.2.1.0.0.xml db/My SQL/migrate-12.1.2.0.0.xml db/My SQL/migrate-12.1.2.0.1.xml db/My SQL/migrate-12.1.2.0.2.xml db/My SQL/migrate-2.0.0.0.xml db/My SQL/migrate-2.0.0.1.xml db/My SQL/migrate-2.0.0.5.xml db/Oracle/create_indexes.sql db/Oracle/create_tables.sql db/Oracle/create_user.sql db/Oracle/drop_indexes.sql db/Oracle/drop_tables.sql db/Oracle/insert_data.sql db/Oracle/migrate-1.3.0.0.xml db/Oracle/migrate-1.4.0.0.xml db/Oracle/migrate-11.1.1.0.xml db/Oracle/migrate-11.1.1.1.0.xml db/Oracle/migrate-11.1.1.1.1.xml db/Oracle/migrate-11.2.1.0.0.xml db/Oracle/migrate-12.1.2.0.0.xml db/Oracle/migrate-12.1.2.0.1.xml db/Oracle/migrate-12.1.2.0.2.xml db/Oracle/migrate-2.0.0.0.xml db/Oracle/migrate-2.0.0.1.xml db/Oracle/migrate-2.0.0.5.xml db/SQL Server/create_indexes.sql db/SQL Server/create_tables.sql db/SQL Server/create_user.sql db/SQL Server/drop_indexes.sql db/SQL Server/drop_tables.sql db/SQL Server/insert_data.sql db/SQL Server/migrate-1.3.0.0.xml db/SQL Server/migrate-1.4.0.0.xml db/SQL Server/migrate-11.1.1.0.xml db/SQL Server/migrate-11.1.1.1.0.xml db/SQL Server/migrate-11.1.1.1.1.xml db/SQL Server/migrate-11.2.1.0.0.xml db/SQL Server/migrate-12.1.2.0.0.xml db/SQL Server/migrate-12.1.2.0.1.xml db/SQL Server/migrate-12.1.2.0.2.xml db/SQL Server/migrate-2.0.0.0.xml db/SQL Server/migrate-2.0.0.1.xml db/SQL Server/migrate-2.0.0.5.xml db/readme.txt META-INF/ META-INF/MANIFEST.MF Domain.class Setup has finished installing Oracle GoldenGate Director Server on your computer. Finishing installation ... --安装完成,若安装失败会回滚,失败原因可到安装目录中查看cds-tool-error.log、cds-tool.log获知原因。 [oracle@oggjk server]$ [oracle@oggjk server]$ cd /ggdir/ [oracle@oggjk ggdir]$ ls cds_current_db_config.xml cds-tool-error.log cds-tool.log domain domain-new.jar ggs.url installDirSvc.cmd notices.txt uninstall uninstallDirSvc.cmd
2、安装director-client [oracle@oggjk client]$ unzip gg-director-clientsetup_unix_v12_1_2_0_2.zip Archive: gg-director-clientsetup_unix_v12_1_2_0_2.zip inflating: gg-director-clientsetup_unix_v12_1_2_0_2.sh inflating: OGG_Director_12.1.2.0.2.pdf inflating: OGG_Director_Readme_12_1_2_0_2.txt [oracle@oggjk client]$ ls gg-director-clientsetup_unix_v12_1_2_0_2.sh gg-director-clientsetup_unix_v12_1_2_0_2.zip OGG_Director_12.1.2.0.2.pdf OGG_Director_Readme_12_1_2_0_2.txt [oracle@oggjk client]$ chmod +x gg-director-clientsetup_unix_v12_1_2_0_2.sh [oracle@oggjk client]$ ls -l total 187104 -rwxr-xr-x 1 oracle dba 95623548 Oct 11 2017 gg-director-clientsetup_unix_v12_1_2_0_2.sh -rw-r--r-- 1 oracle dba 95786996 Oct 8 16:45 gg-director-clientsetup_unix_v12_1_2_0_2.zip -rw-r--r-- 1 oracle dba 173260 Oct 19 2017 OGG_Director_12.1.2.0.2.pdf -rw-r--r-- 1 oracle dba 1292 Oct 19 2017 OGG_Director_Readme_12_1_2_0_2.txt [oracle@oggjk client]$ ./gg-director-clientsetup_unix_v12_1_2_0_2.sh -c Starting Installer ... Introduction Choose Install Folder Where should Oracle GoldenGate Director Client be installed? [/home/oracle/GoldenGateDirector] --指定director client安装目录 /ggdclient The directory:
/ggdclient
already exists. Would you like to install to that directory anyway? Yes [y, Enter], No [n] y Create symlinks? Yes [y, Enter], No [n] y Select the folder where you would like Oracle GoldenGate Director Client to create symlinks, then click Next. [/usr/local/bin]
Pre-Installation Summary [Product Name:
Oracle GoldenGate Director
Install Folder:
/ggdclient
]
Extracting files ...
.install4j/ .install4j/GDSC Admin Tool.png .install4j/GoldenGate-Director.png .install4j/uninstall.png GDSC Admin Tool GoldenGate-Director gdsc-client-unix.zip notices.txt uninstall META-INF/MANIFEST.MF bin/run-admin.sh bin/run-director.sh etc/client-properties.conf etc/gdsc-client-login.conf etc/gdsc-client.policy libs/PgsLookAndFeel.jar libs/activation.jar libs/commons-collections-2.1.1.jar libs/commons-lang-2.1.jar libs/gdsc-admin-help.jar libs/gdsc-client.jar libs/gdsc-help.jar libs/javachart.jar libs/jaxen-core.jar libs/jaxen-jdom.jar libs/jbcl.jar libs/jdom.jar libs/jh.jar libs/log4j-1.2.8.jar libs/mail.jar libs/saxpath.jar libs/velocity-1.4.jar libs/weblogic.jar libs/webserviceclient+ssl.jar libs/wlfullclient5.jar libs/wlthint3client.jar libs/xercesImpl.jar libs/xml-apis.jar Setup has finished installing Oracle GoldenGate Director Client on your computer. Finishing installation ... [oracle@oggjk client]$ cd /ggdclient/ [oracle@oggjk ggdclient]$ ls bin etc GDSC Admin Tool GoldenGate-Director libs META-INF notices.txt Oracle GDSC Admin Tool.desktop Oracle GoldenGate-Director.desktop uninstall [oracle@oggjk ggdclient]$ cd bin [oracle@oggjk bin]$ ls run-admin.sh run-director.sh run-admin.sh是图形化配置工具,可添加管理账号、ogg数据源等; run-director.sh是图形化配置工具,可通过图形管理配置ogg
3、启动director server [oracle@oggjk ggdir]$ cd /ggdir/domain [oracle@oggjk domain]$ ls autodeploy bin config fileRealm.properties gg_wl_director_log4j.log init-info lib log4j.properties security servers startWebLogic.sh [oracle@oggjk domain]$ nohup ./startWebLogic.sh &
访问地址:http://xx.xx.xx.xx:7001/acon 默认账号密码:admin/admin
4、启动director client工具 [oracle@oggjk /]$ cd /ggdclient/bin/ [oracle@oggjk bin]$ ls run-admin.sh run-director.sh [oracle@oggjk bin]$ ./run-admin.sh