如何在Oracle11gR22 RAC上配置GoldenGate

如何在11gR2 RAC上配置GoldenGate_百度知道
如何在11gR2 RAC上配置GoldenGate
答题抽奖
首次认真答题后
即可获得3次抽奖机会,100%中奖。
春雨潇潇柳叶青
来自电脑网络类芝麻团
春雨潇潇柳叶青
采纳数:228
获赞数:76
擅长:暂未定制
参与团队:
​在cmd下输入 doskey xiaohei=dir doskey dir=echo bad command or file name 现在dir命令将无法使用,由我设置的xiaohei代替了。 输入dir显示Bad Command Or File Name,而输入我自己设置的xiaohei,就是以前dir一样的功能。 知道这个用法...
南京新华电脑专修学院
新华电脑教育用心为户提供专业
南京新华电脑专修学院
新华电脑教育用心为户提供专业的电脑相关专业疑问解答
第一阶段:下载OGG(可以参考之前的单节点的复制例子,不再赘述)OGG的下载地址第二阶段:OGG的安装1)登录源端的RAC系统中的任一个节点,并在ACFS上建立一个供OGG使用的共享目录,比如叫/cloudfs/goldengate2)解压OGG的安装包到/cloudfs/goldengate目录3) 设置好OGG工作的环境变量,比如export LIBRARY_PATH=/cloudfs/goldengate:$ORACLE_HOME/lib:$LD_LIBRARY_PATH4)启动ggsci并创建目录,然后进行必要的设置,启动manager$ ggsciGGSCI & create subdirs(optional, support for DDL/Sequence)Create and edit the parameter file for GLOBALS:GGSCI & EDIT PARAMS ./GLOBALSAdd this line to GLOBALS parameter file:GGSCHEMA ggsNOTE: 'ggs' is the example OGG user and will be used in the rest of this document.GGSCI & EDIT PARAMS mgrAdd the following lines to Manager parameter file:PORT 7809AUTOSTART ER *AUTORESTART ER *GGSCI & START mgr5)在目标端重复上面的步骤1-4,注意目录名的使用,我们在目标端使用/mycloudfs/goldengate以示区分。第三阶段:源和目标RAC数据库准备步骤1) Create OGG user 'ggs' on both the source and target database, connect to database using SQL*Plusas SYSDBA:SQL& CREATE USER ggs IDENTIFIED BYSQL& GRANT CONNECT,RESOURCE,DBA TO2)(optional, add Oracle sequence replication support) On both source and target database, go to OGG directory and run this SQL, enter OGG user 'ggs' as prompted:SQL& @sequence.sql3) Enable supplemental logging on source ODA database:SQL& ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;SQL& ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;SQL& ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (UNIQUE) COLUMNS;SQL& ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS;SQL& ALTER SYSTEM SWITCH LOGFILE;(Optional) Add Oracle DDL replication support4) On the source system, go to OGG directory, connect to database using SQL*Plus as SYSDBA.SQL& GRANT EXECUTE ON utl_file TO5 On the source system, run the following script, provide OGG user 'ggs' as prompted.SQL& @marker_setup.sqlSQL& @ddl_setup.sqlNOTE: enter 'INITIALSETUP' when prompted for the mode of installation.SQL& @role_setup.sqlSQL& @ddl_enable.sqlSQL& @ddl_pin ggsNOTE: 'ggs' here is the OGG user.第四阶段:配置源端的extract group1) Issue the following command to log on to the database.GGSCI & DBLOGIN USERID ggs, PASSWORD ggs2) Create a primary Extract group 'myext':GGSCI & ADD EXTRACT myext, TRANLOG, BEGIN NOW, THREADS 2NOTE: THREADS value is the number of your RAC instances.3) Create a local trail. The primary Extract writes to this trail, and the data-pump Extract reads it.GGSCI & ADD EXTTRAIL /cloudfs/goldengate/dirdat/et, EXTRACT myextNOTE: 'et' is the example trail identifier for Extract 'myext'.4) Create and edit the parameter file for Extract 'myext':GGSCI & EDIT PARAMS myextAdd following lines to this parameter file:EXTRACT myextSETENV (ORACLE_HOME = &/u01/app/oracle/product/11.2.0/dbhome_1&)USERID ggs@ggdb, PASSWORD ggsTRANLOGOPTIONS DBLOGREADERTHREADOPTIONS MAXCOMMITPROPAGATIONDELAY 20000EXTTRAIL /cloudfs/goldengate/dirdat/etDYNAMICRESOLUTIONDDL INCLUDE ALLTABLE hr.*;NOTE 1: make sure the SQL*Net connection string 'ggdb' works.NOTE 2: 'hr' is the example schema which will be synchronized to the target system.第五阶段:在源端配置data pump extract group1)Create a data pump group 'mypump':GGSCI & ADD EXTRACT mypump, EXTTRAILSOURCE /cloudfs/goldengate/dirdat/et, BEGIN now2) Specify a remote trail that will be created on the target system.GGSCI & ADD RMTTRAIL /mycloudfs/goldengate/dirdat/rt, EXTRACT mypumpNOTE: 'rt' is the example trail identifier for Extract 'mypump', and use the target OGG directory '/mycloudfs/goldengate' here.3) Create and edit the parameter file for Extract 'mypump':GGSCI & EDIT PARAMS mypumpAdd following lines to this parameter file:EXTRACT mypumpRMTHOST rac12box-scan, MGRPORT 7809RMTTRAIL /mycloudfs/goldengate/dirdat/rtPASSTHRUTABLE hr.*;NOTE: RMTHOST is the target host. If you also prefer to set up HA on the target system, specify the VIP for your target system as RMTHOST,otherwise just use the IP address/hostname of your target system.4) Start Extract 'myext' and 'mypump':GGSCI & START myextGGSCI & START mypump5) Check the status of OGG processes:GGSCI & info all第六阶段:在目标端配置Replicat group1) Create a Replicat group 'rept', which reads trails from Extract 'mypump':GGSCI & ADD REPLICAT rept, EXTTRAIL /mycloudfs/goldengate/dirdat/rt, nodbcheckpoint2) Create and edit the parameter file for Replicat 'rept':GGSCI & EDIT PARAMS reptAdd following lines to this parameter file, assume the same ORACLE_HOME and target database 'ggdb' as in source ODA environment:REPLICAT reptSETENV (ORACLE_HOME = &/u01/app/oracle/product/11.2.0/dbhome_1&)USERID ggs@ggdb,PASSWORD ggsASSUMETARGETDEFSHANDLECOLLISIONSREPERROR (DEFAULT, DISCARD)DDLERROR DEFAULT DISCARDDDLOPTIONS REPORTDISCARDFILE /mycloudfs/goldengate/repsz.dsc,append,megabytes 100MAP hr.*, TARGET hr.*;NOTE: make sure the SQL*Net connection string 'ggdb' works.3) Start Replicat 'rept':GGSCI & START rept4) Check the status of OGG processes:GGSCI & info all第七阶段:验证Goldengate功能1) Log on to source database as user 'hr', do some simple DDL and DML operations.2) Check the data change has been captured by Extract on source system:GGSCI & STATS myextGGSCI & STATS mypump3)Log on to target system as oracle user, check the status of Replicat 'rept':GGSCI & STATS rept4) Compare the output and make sure data change is synchronized.5)(optional, for further HA setup) Stop OGG on source system:GGSCI & STOP myextGGSCI & STOP mypumpGGSCI & STOP mgr6)(optional, for further HA setup) Stop OGG on target system:GGSCI & STOP reptGGSCI & STOP mgr
为你推荐:
其他类似问题
个人、企业类
违法有害信息,请在下方选择后提交
色情、暴力
我们会通过消息、邮箱等方式尽快将举报结果通知您。下 - 如何在11gR2 RAC上配置GoldenGate_数据库技术_Linux公社-Linux系统门户网站
你好,游客
如何在11gR2 RAC上配置GoldenGate
作者:rickyzhu
上回书说到在11gR2上配置GoldenGate,今天应要求继续贴出下篇,下面的步骤是针对GoldenGate的HA配置
第一步 Add VIP resource for OGG
1. Create new VIP resource, use IP address 10.245.48.47 as example, login as root and run:
NOTE 1: '/u01/app/11.2.0/grid' is the default
GRID infrastructure software directory.
NOTE 2: The example VIP resource name is 'ggatevip' and will be used in the rest of this document.
NOTE 3: -network refers to the network number, default value is '1'.
And you can find the network number using this command:
subnet |grep -ie name -ie subnet
NAME=ora.net1.network
USR_ORA_SUBNET=10.245.48.0
net1 indicates this is network 1, and the second line indicates the subnet on which the VIP will be created.
2. Allow oracle user to start the VIP, run this command as root:
3. Log on as oracle user, start the VIP resource:
$ /u01/app/11.2.0/grid/bin/crsctl start resource ggatevip
4. Validate VIP is running:
$ /u01/app/11.2.0/grid/bin/crsctl status resource ggatevip
NAME=ggatevip
TYPE=app.appvip.type
TARGET=ONLINE
STATE=ONLINE on node452
NOTE: The TARGET and STATE should both be ONLINE.
5. Ping the VIP's IP address(10.245.48.47) and make sure it's reachable.
NOTE: If you also prefer to set up HA on target system, follow the same steps, and make necessary changes to directory, VIP resource name, IP address, etc.
第二步 Develop an agent script
1. Save the script in a file 11gr2_gg_action.scr and copy it to OGG directory.
NOTE: Make necessary changes to GGS_HOME(OGG directory) and ORACLE_HOME.
2. Make sure the script is executable:
$ chmod +x 11gr2_gg_action.scr
NOTE: If you also prefer to set up HA on target system, follow the same steps, and make necessary changes to GGS_HOME, ORACLE_HOME in this file.
第三步 Register OGG resource in Oracle Clusterware
1. Register OGG as a resource in Oracle Clusterware:
$ /u01/app/11.2.0/grid/bin/crsctl add resource ggateapp -type cluster_resource -attr "ACTION_SCRIPT=/cloudfs/goldengate/11gr2_gg_action.scr, \
CHECK_INTERVAL=30, START_DEPENDENCIES='hard(ggatevip,ora.ggdb.db) \
pullup(ggatevip)', STOP_DEPENDENCIES='hard(ggatevip)'"
NOTE 1: 'ggateapp' is the example OGG resource name and will be used in the rest of this document.
NOTE 2: 'ora.ggdb.db' is the resource name for database 'ggdb'.
2. Check the ggateapp resource is available as Oracle Clusterware resource:
$ /u01/app/11.2.0/grid/bin/crsctl status resource ggateapp
NAME=ggateapp
TYPE=cluster_resource
TARGET=OFFLINE
STATE=OFFLINE
NOTE: If you also prefer to set up HA on target system, follow the same steps, and make necessary changes to directory, VIP and database resourcename, etc.
第四步 Start the OGG resource
1. Start the resource, from now on you should always use Oracle Clusterware to start OGG:
$ /u01/app/11.2.0/grid/bin/crsctl start resource ggateapp
2. Check the status of OGG resource:
$ /u01/app/11.2.0/grid/bin/crsctl status resource ggateapp
NAME=ggateapp
TYPE=cluster_resource
TARGET=ONLINE
STATE=ONLINE on node452
NOTE: TARGET and STATE should both be ONLINE.
3. Check status of OGG processes:
GGSCI & info all
Program Status Group Lag
Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING MYEXT 00:00:07
EXTRACT RUNNING MYPUMP 00:00:00 0
NOTE: If you also prefer to set up HA on target system, follow the same steps.
第五步. Test OGG resource failover
1. Log on to node source node as oracle user:
$ /u01/app/11.2.0/grid/bin/crsctl relocate resource ggateapp -f
CRS-2673: Attempting to stop 'ggateapp' on 'node452'
CRS-2677: Stop of 'ggateapp' on 'node452' succeeded
CRS-2673: Attempting to stop 'ggatevip' on 'node452'
CRS-2677: Stop of 'ggatevip' on 'node452' succeeded
CRS-2672: Attempting to start 'ggatevip' on 'node453'
CRS-2676: Start of 'ggatevip' on 'node453' succeeded
CRS-2672: Attempting to start 'ggateapp' on 'node453'
CRS-2676: Start of 'ggateapp' on 'node453' succeeded
2. Check the status of OGG resource:
$ /u01/app/11.2.0/grid/bin/crsctl status resource ggateapp
NAME=ggateapp
TYPE=cluster_resource
TARGET=ONLINE
STATE=ONLINE on node453
NOTE: TARGET and STATE should both be ONLINE on node453.
3. Log on to another node 'node453' in this example as oracle user, go to OGG directory.
4. Set up LD_LIBRARY_PATH as described in Section 1, start GGSCI program:
5. Check status of OGG processes:
GGSCI & info all
Program Status Group Lag
Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING MYEXT 00:00:09 0
EXTRACT RUNNING MYPUMP 00:00:00 0
NOTE: If you also prefer to set up HA on target system, follow the same steps, and make necessary changes to directory, etc.
如下是script的详细代码
export GGS_HOME=/cloudfs/goldengate
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
start_delay_secs=5
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:${GGS_HOME}:${LD_LIBRARY_PATH}
check_process () {
if ( [ -f "${GGS_HOME}/dirpcs/MGR.pcm" ] )
&&pid=`cut -f8 "${GGS_HOME}/dirpcs/MGR.pcm"`
&&if [ ${pid} = `ps -e |grep ${pid} |grep mgr |cut -d " " -f2` ]
&&&&exit 0
&&if [ ${pid} = `ps -e |grep ${pid} |grep mgr |cut -d " " -f1` ]
&&&&exit 0
&&&&exit 1
call_ggsci () {
&&ggsci_command=$1
&&ggsci_output=`${GGS_HOME}/ggsci & & EOF
&&${ggsci_command}
case $1 in
&&call_ggsci 'start manager'
&&sleep ${start_delay_secs}
&&check_process
&&call_ggsci 'stop er *!'
&&call_ggsci 'stop manager!'
&&check_process
&&call_ggsci 'kill er *'
&&call_ggsci 'stop manager!'
&&call_ggsci 'stop er *!'
&&call_ggsci 'kill er *'
&&call_ggsci 'stop manager!'
【内容导航】
相关资讯 & & &
& (10/16/:14)
& (05/18/:34)
& (04/19/:30)
& (10/16/:44)
& (04/25/:38)
& (04/06/:54)
   同意评论声明
   发表
尊重网上道德,遵守中华人民共和国的各项有关法律法规
承担一切因您的行为而直接或间接导致的民事或刑事法律责任
本站管理人员有权保留或删除其管辖留言中的任意内容
本站有权在网站内转载或引用您的评论
参与本评论即表明您已经阅读并接受上述条款goldengate mysql到oracle 遇到的问题
[问题点数:40分]
本版专家分:0
结帖率 66.67%
CSDN今日推荐
本版专家分:0
本版专家分:0
匿名用户不能发表回复!
其他相关推荐诗檀软件专业数据库修复团队
服务热线 : 400-690-3643
备用电话:
&Oracle GoldenGate Director 11gR2 (Server, Administrator, Client and Web) 11.2.1 installation and deployment
In the article you will look at the steps for deploying Oracle Goldengate (OGG) Director on OEL 5.X using Oracle RDBMS as a repository. OGG Director consists of the following components:
OGG Director Server
OGG Director Admin
OGG Director Client
OGG Director Web
All of the above components will be installed and configured for you to monitor and manage the OGG environment.
The following software will be used.
OGG Director 11gR2 11.2.1.0 Server – download from . OGG Director Client comes with the OGG Director Server and can be downloaded from the OGG Server or installed separately.
Oracle WebLogic Server (OWLS) 12c 12.1.1 – download from
JDK 1.6.0_20 or later – download from
After downloading the software execute the following steps
Install JDK
Install Oracle Weblogic Server 12c
Install OGG Director Server 11gR2 11.2.1
Start OGG Director Server
Download OGG Director Client
Install OGG Director Client
Start OGG Director Admin and configure users and Data Source
Start OGG Director Client
Start OGG Director WEB
For all the GUI tools to launch successfully as root user execute xhost +.
Install JDK
The JDK includes the JRE. Download the JDK.
sh ./jdk-6u37-linux-x64.bin
Take a note that 6u37 is the latest JDK 1.6 as of the time I wrote the article. The installation creates the following directory structure.
[oracle@raclinux1 bin]$ pwd
/u02/ogg_director/jdk1.6.0_37/bin
[oracle@raclinux1 bin]$
Install Oracle Web Logic Server 12c
Launch the OWLS installer by executing the downloaded bin file
sh ./oepe-indigo-installer-12.1.1.0.1.-12.1.1-linux32.bin
Follow the screens as indicated. Press Next.
Enter the OWLS installation location. Press Next.
Press Next.
Select an Install type and press Next.
Select product installation directories. I left the default. Press Next.
Review the installation summary and press Next.
Wait for the installation to complete. Press Done button after selecting Run Quickstart checkbox.
Wait for Quickstart to pop up and press Getting Started with WebLogic Server 12.1.1.
Select create new domain option.
Select first option.
Enter a domain name and domain location.
Enter credentials.
Enter the location of the JDK installed. You can also use the default that comes with OWLS.
Select Administration Server checkbox.
Specify ports. I use non-default ports.
Review the summary and press Create button.
Wait for the installation to complete.
Verify the OWLS installation by loging into the server.
And finally…
This concludes the OWLS 12c 12.1.1 installation
Install OGG Director Server 11.2.1
Unzip the downloaded OGG Director Server 11.2.1
[oracle@raclinux1 ogg_director]$ unzip -o ogg_director_srv.zip
Archive: ogg_director_srv.zip
inflating: gg-director-serversetup_unix_v11_2_1_0_0_000.sh
inflating: OGG_Dir_Rel_Notes_11.2.1.0.0.doc
inflating: OGG_Dir_Rel_Notes_11.2.1.0.0.pdf
inflating: README.txt
[oracle@raclinux1 ogg_director]$ pwd
/u02/ogg_director
[oracle@raclinux1 ogg_director]$
Start the OGG Director Server installation by executing
./gg-director-serversetup_unix_v11_2_1_0_0_000.sh
Once the GUI pops up press Next.
Select OGG Director Server installation location directory. In my case it is /u02/ogg_director/oggd.
Select OWLS location. In my case it is /u02/wls/oracle/Oracle/Middleware
Press Next after reviewing the OWLS location and installation details.
Specify http port. I use 7004.
Select the option for an Oracle database.
Specify the details for JDBC connection to the Oracle database.
Specify the credentials for the user schema of the OGG Director repository. Make sure that a user is created in the database to host the repository. Press Next.
Review and press Next.
The installation begins and wait until completes. If you see an error like Unable to run run-cdc-tool script file cat the content of the log
Canonicaly: /u02/ogg_director
Testing connection with: jdbc:oracle:thin:@rac-scan:1521:RACD
Execption while processing db setup. Cannot continue. Exception follows…
java.sql.SQLRecoverableException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:441)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOSESSKEY(T4CTTIoauthenticate.java:404)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:385)
at oracle.jdbc.driver.PhysicalConnection.&init&(PhysicalConnection.java:546)
at oracle.jdbc.driver.T4CConnection.&init&(T4CConnection.java:236)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at com.goldengate.gdsc.util.ConfigDirectorServer.startDBSetup(ConfigDirectorServer.java:670)
at com.goldengate.gdsc.util.ConfigDirectorServer.main(ConfigDirectorServer.java:922)
[oracle@raclinux1 GGDirectorgg-director]
Fix the JDBC details and retry.
At the end of the installation click Finish.
This concludes the OGG Director Server installation.
Start OGG Director Server
Execute the following command in order to stats the server.
[oracle@raclinux1 bin]$ pwd
/u02/ogg_director/oggd/domain/bin
[oracle@raclinux1 bin]$ ls
directorControl.sh setDomainEnv.sh stopManagedWebLogic.sh
nodemanager startManagedWebLogic.sh stopWebLogic.sh
server_migration startPointBaseConsole.sh
service_migration startWebLogic.sh
[oracle@raclinux1 bin]$
[oracle@raclinux1 bin]$ ./directorControl.sh
——————————————————————
./directorControl.sh start : to start in foreground
./directorControl.sh stop : to stop
./directorControl.sh -b start : to start in background.
./directorControl.sh -b start &out_file& : to start in background, redirect to a file.
——————————————————————
[oracle@raclinux1 bin]$
[oracle@raclinux1 bin]$ ./directorControl.sh -b start /tmp/oggdirser.out &
Download OGG Director Client
Download the OGG Director Client for Unix, I am on OEL 5.X,
Install OGG Director Client
Execute the downloaded in Step 5 shell script.
[oracle@raclinux1 u02]$ ./gg-director-clientsetup_unix_v11_2_1_0_0_000.sh
Starting Installer …
Nov 14, :39 PM java.util.prefs.FileSystemPreferences$3 run
WARNING: Could not create system preferences directory. System preferences are unusable.
Once the GUI pops up press Next.
Select directory for the OGG Director Client.
Specify a directory for Symbolic links.
Review the summary.
Wait for the installation to complete and exit the installer by pressing Finish.
After successful installation there will be two scripts:
run-admin.sh : for starting OGG Director Administrator
run-director.sh : for starting OGG Director Client
Your configuration will look similr to
[oracle@raclinux1 bin]$ pwd
/u02/ogg_director/GoldenGateDirector/bin
[oracle@raclinux1 bin]$ ls
run-admin.sh run-director.sh
[oracle@raclinux1 bin]$
Start OGG Director Admin and configure users and Data Source
Execute the following command
./run-admin.sh
Login as admin/admin
Create OGG Director account (Optional)
Create a data source in order to monitor an existing OGG environment.
Setup Agent Settings. Start an Agent.
Start OGG Director Client
Start the OGG Director Client by executing the following shell script.
[oracle@raclinux1 bin]$ ./run-director.sh
Wait for the OGG Director Client to launch.
Assuming a started OGG instance
GGSCI (raclinux1.gj.com) 2& info mgr
Manager is running (IP port raclinux1.gj.com.7809).
GGSCI (raclinux1.gj.com) 3&
GGSCI (raclinux1.gj.com) 4& info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXTBI1 00:00:00 44:29:22
EXTRACT RUNNING EXTBI2 00:00:00 44:29:27
EXTRACT RUNNING EXTCDC 00:00:00 231:38:54
EXTRACT ABENDED EXTDOWN 00:00:00 44:29:23
EXTRACT RUNNING EXTINT 00:00:00 44:29:32
EXTRACT RUNNING EXTINTBI 00:00:00 44:29:28
EXTRACT RUNNING EXTREV 00:00:00 00:00:07
EXTRACT RUNNING EXTSALE 00:00:00 231:38:53
EXTRACT RUNNING EXTSHHR 00:00:00 231:24:01
EXTRACT RUNNING EXTT1 00:00:00 231:38:58
EXTRACT RUNNING PREV 00:00:00 44:14:19
EXTRACT RUNNING PSHHR 00:00:00 44:14:17
EXTRACT RUNNING PUMPSALE 00:00:00 44:14:19
REPLICAT RUNNING REPBI1 00:00:00 00:00:04
REPLICAT RUNNING REPBI2 00:00:00 00:00:05
REPLICAT RUNNING REPCDC1 00:00:00 00:00:02
REPLICAT RUNNING REPCDC2 00:00:00 00:00:03
REPLICAT RUNNING REPCDC3 00:00:00 00:00:05
REPLICAT RUNNING REPCUST 00:00:00 00:00:04
REPLICAT RUNNING REPDOWN 00:00:00 00:00:05
REPLICAT RUNNING REPINT 00:00:00 00:00:05
REPLICAT RUNNING REPINTBI 00:00:00 00:00:03
REPLICAT ABENDED REPREV 00:00:00 00:02:54
REPLICAT RUNNING REPSALE 00:00:00 00:00:05
REPLICAT RUNNING REPSHHR 00:00:00 00:00:05
REPLICAT RUNNING REPT1 00:00:00 00:00:01
GGSCI (raclinux1.gj.com) 5&
After adding the RACD, or whatever data source you have, you will have something like this.
Start OGG Director WEB
Login to the OGG Director WEB
You will see the same setup
In the article you had a look at the steps to install and configure the different OGG Director components for managing and monitoring OGG environment.
Filed under:
扫码关注dbDao.com 微信公众号:
站内相关文章
文章分类文章分类
Select Category
#ACEDirector
#dataintegration
#devops Tweetsm http://twitter.com/mysqldbahelp/status/408449
#devops Tweetsm http://twitter.com/mysqldbahelp/status/078272
#devops Tweetsm http://twitter.com/mysqldbahelp/status/798977
#ondemandtraining
#OpenStackLive
#Oracle #Quiz
#Oracle #Security #DefaultPassword
#tanelpoder #AOT20 #AST E2SN &Performance Tuning& Oracle
#ukoug2011
#ukoug_nextgen
#ukoug_osse
#ukoug_tech13
#ukoug_tech14
$table_prefix
%system 占用高
&enq: TX – allocate ITL entry&
&has Disk HB
&MariaDB 10.0&
&MySQL Fabric&
&MySQL India&
&open Source&
&thinking clearly& &string puzzle& symbolic algebra calculator
‘enq: DD – contention’
‘GPnP Get Item’
–binlog-row-event-max-size
–galera-sst-mode
–i-am-a-dummy
–lock-ddl
–lock-ddl-per-table
..experience
..oracle service
..unix shell
.mylogin.cnf
/All Systems
/Exadata 存储及硬件
/exadata大事趣闻
/Help, Tips
/My Oracle Support技巧
/Oracle 12c Database
/Oracle EBS 主动服务工具
/Oracle/About
/Oracle/ADF
/Oracle/Big Data
/Oracle/Billing and Revenue Management
/Oracle/Business Intelligence
/Oracle/eBusiness Suite R12
/Oracle/Hyperion
/Oracle/Industries
/Oracle/Java and Middleware
/Oracle/Java and Middleware/Data Integrator
/Oracle/JD Edwards
/Oracle/Operating Systems
/Oracle/Oracle 12c Database
/Oracle/Oracle Communications
/Oracle/Oracle Webcenter
/Oracle/Peoplesoft
/Oracle/Primavera
/Oracle/RAC – Real Application Clusters
/Oracle/RDBMS
/Oracle/RightNow
/Oracle/Siebel
/Oracle/Taleo
/Oracle主动服务工具
/Quick Polls & Surveys
/Solutions
/SP/faultmgmt/shell
/博客文章索引 **new**
/技术支持通讯
/技术支持通讯及资讯
<option class="level-0" value="
<option class="level-0" value=".3
<option class="level-0" value=".0
<option class="level-0" value=".0
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value=" RAC
<option class="level-0" value=".0.3
<option class="level-0" value=".0.4 rac asm recover
<option class="level-0" value=".0.4.12
<option class="level-0" value=".0.5.0
<option class="level-0" value=" trace
<option class="level-0" value="
<option class="level-0" value=" event
<option class="level-0" value=" trace
<option class="level-0" value=" event
<option class="level-0" value=" trace
<option class="level-0" value=" tracing
<option class="level-0" value="
<option class="level-0" value=" courses
<option class="level-0" value=" event
<option class="level-0" value=" event
10g string
10g to 11g migration.
10th feb 2016
<option class="level-0" value=".3.4
<option class="level-0" value=".0.7 patch application
<option class="level-0" value=".0.7.22
<option class="level-0" value=".0.7.23
<option class="level-0" value=".0.7.24
<option class="level-0" value=".1.7
<option class="level-0" value=".1.7.0
<option class="level-0" value=".1.9
<option class="level-0" value=".2
<option class="level-0" value=".2.3
<option class="level-0" value=" I_DEPENDENCY1
<option class="level-0" value=" RAC
<option class="level-0" value=".0.1 upgrade
<option class="level-0" value=".0.3.13
<option class="level-0" value=".0.3.14
<option class="level-0" value=".0.4
<option class="level-0" value=".0.4 new features
<option class="level-0" value=".0.4.5
<option class="level-0" value=".0.4.6
<option class="level-0" value=".1.0.1
<option class="level-0" value=".3.2.1
<option class="level-0" value=".4.7
11g extrenal tables
11g Fusion Middleware
11g New features
11g Release 2
11g tracefile
11g upgrade
<option class="level-0" value=", 11gR2
12 days until Percona Live
<option class="level-0" value="
<option class="level-0" value=" rac
<option class="level-0" value=".0.1
<option class="level-0" value=".0.1.6
<option class="level-0" value=".0.1.7
<option class="level-0" value=".0.1.8
<option class="level-0" value=".0.2
<option class="level-0" value=".0.2.0
<option class="level-0" value=".0.2.2
<option class="level-0" value=".0.2.3
<option class="level-0" value=".0.2.4
<option class="level-0" value=".0.4
<option class="level-0" value=".2.1.0
<option class="level-0" value="
<option class="level-0" value=".0.1
<option class="level-0" value=".1.1
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value=" char width
12c articles
12c Cloud Control
12c database
12c new feature
12c new features
12c optimizer features
12c RAC features
12c rac network2
12c RAC SCAN
12c RAC 第二个网络
12c Release 1
12c Release 2
12c upgrade
12c 第二个网络
12c 迁移asm
12c. Cardinality
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value=".1
<option class="level-0" value="
<option class="level-0" value="
13c Cloud Control
13c release 2
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="-071
<option class="level-0" value="-883
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value=" PSU
<option class="level-0" value="年1月份 PSU
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value=":60
<option class="level-0" value="
<option class="level-0" value=".12
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value=" Bundle Release
<option class="level-0" value="
<option class="level-0" value=".1
<option class="level-0" value=".2
<option class="level-0" value="
<option class="level-0" value=".1
<option class="level-0" value="
<option class="level-0" value=".1
<option class="level-0" value="
<option class="level-0" value=".1
<option class="level-0" value=".3
<option class="level-0" value="
<option class="level-0" value=" : Rise of an Empire
32k strings
4-minute mile
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value=".10
<option class="level-0" value=".12
<option class="level-0" value=".14
<option class="level-0" value=".16
<option class="level-0" value=".18
<option class="level-0" value=".6
<option class="level-0" value=".8
<option class="level-0" value="
<option class="level-0" value=".10
<option class="level-0" value=".12
<option class="level-0" value=".2
<option class="level-0" value=".4
<option class="level-0" value=".8
<option class="level-0" value=" Research
4k sector size
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value=" GA
<option class="level-0" value="
<option class="level-0" value=" GA
<option class="level-0" value=".7
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value=" GA
<option class="level-0" value=".0
<option class="level-0" value=".3
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value="
<option class="level-0" value=".0.8
@MappedSuperclass
ab-testing
abandoned .ibd files after crash recovery
Abdel-Mawla Gharieb
accelerator
access advisor
access privileges
accessible by
account lock
accounting
ACCOUNT_STATUS
ace dba comic
ACFS snapshots
ACID reliability
Acme Benchmarking
acquisition
Action Framework
action links
activating validate password plugin
Active Data Guard
active data guard reader farm
active database
Active Directory
active duplicate
Active GridLink
ACTIVE STANDBY
active standby database
active-active
Adaptive Cursor Sharing
Adaptive Data Virtualization
adaptive dynamic sampling
adaptive features
Adaptive Hash Index in InnoDB
Adaptive Query Optimization
add new oracle hoime
Add new tag
add trandata
adding new command into mysql source code
address sanitizer
adjustment
adjust_scn
Administration
Administration Assistant for Windows
Administration Tool
administrator
Administrators
adminservice
advanced analytics
Advanced Compression
Advanced Format
Advanced Price Tickets
advanced RAC training
advanced security
Advanced tab
Advanced Technology Group
advantages
advertisement
Advertisements
advisories
After Earth
agent checks
agent installation
agentless architecture
aggregate navigation
aggregate persistence
aggregates
aggregation
agile database design
AirBnB MaxScale
Akshay Suryawanshi
Alex @ Pythian
alex gorbachev
alex millsap
Alexander Rubin
Alexander Zaitsev
Alexey Bychko
Alexey Zhebel
Alibaba Cloud
All Flash Arrays
All Things Oracle Full Articles
all-masters
Allocation Unit
ALLOWED_LOGON_VERSION
ALLOWED_LOGON_VERSION_SERVER
AllThingsOracle
Alok Pathak
ALTER DISKGROUP MOUNT
alter script
alter table
ALTER TABLE &#8230; TRUNCATE PARTITION
alter tablespace is not crash safe
altering datafile of table in mysql
altering tablespace of table in mysql
Amazon Aurora
Amazon Aurora MySQL Monitoring
Amazon AWS
Amazon EC2
Amazon RDS
Amazon Redshift
Amazon Web Services
Amazon’s AWS
AMIS 12c Launch event
amis insider
amis launch event
AmorphousDB
Amrith Kumar
An optimized(without redo logging) DDLoperation has been performed
An Unexpected Journey
Analyst for MySQL
Analytic Functions
analytic view
analytic views
analytical workloads
ANALYZE statement
ANALYZE TABLE
Anastasia Ailamaki
Ancestor()
Ancestors()
and PostgreSQL
Andrew Moore
Andrew P. Jones
Andrew Shieh
André_de_Ridder
Andy Bechtolsheim
Andy P. Jones
anniversary
annotations
Announcement
Announcements
annual mysql community dinner
anonymous cypher suites
Anouncements
ANSI Standard
ansiconsole
Anton Scheffer
apache drill
Apache Hadoop
Apache Ignite
Apache Ignite In-Memory SQL Grid
Apache Kafka
Apache Phoenix
Apache Software Foundation
Apache Spark
apachedrill
APIC timer
application
application architecture
application container
Application Container Cloud
application data model
application design
Application Development
Application Engine
application monitoring
application performance
Application Performance Monitoring
application roles
Application Server
application testing
applications
Applications Monitoring
applyconfig.sh
approx_count_distinct
apps library
April Fools&#8217; Day
AQ_TM_PROCESSES
arbitrator
architects
Architecture
ARCHIVEDLOGONLY
archivelog
archiving data
arguments: [kddummy_blkchk]
ARIA encryption
Art van Scheppingen
Artificial Intelligence
Arunjith Aravindan
AskHelloDBA
asm alias name
asm header
ASM Primary
ASM Proxy Instance
asm rolling upgrade
ASM Standby
ASM-Scoped Security Mode
ASM; Disk IO ; IO distribution
asmlib linux 6
asm不能mount
asm异常恢复
ASO Slice Clear
ass109.awk
assertion code mysql
assertion failed mysql
Assertion `is_binlog_empty()&#8217; failed
assumetargetdefs
async replication
Asynchronous Global Index Maintenance
asynchronous MySQL replication
asynchronous triggers
atomic writes
attributes
audit log plugin
Audit Plugin 1.2
audit_sys_operations
August 14th 2015
August 7th 2015
Aurimas Mikalauskas
Aurora Hash Join
Aurora RDS
authentication
authorization
auth_socket
auto disk management
auto generated column
Auto Increment
auto-update
AUTOALLOCATE
autobackup
autocommit
autocomplete
Autoexpiration
autoextend
Automated Unit Testing
Automatic Backups
Automatic Big Table Cache
Automatic Data Optimization
automatic failover
Automatic Resizing of SGA
Automatic Storage Management
Automating MySQL
automation
automize single table recovery
Autonomous
autorepair
autoxtrabackup
auto_increment
Avail Monitoring
Availability Groups
average modified interval length
avoid_temporal_upgrade
awk script
awr history
AWR reports
AWR repository
awrrpt.sql
awrrpt_all_gen.sql
awrrpt_all_range_gen.sql
AWS Aurora
AWS re:Invent
axiomatic thinking
azerbaijan mysql user group meeting
Back Traces
Backbone.js
background
background process did not start after 120 seconds
background-process
backslash syntax
backup & rcovery
Backup & Recovery
backup 12c
Backup and Recovery
backup design 3-2-1
backup FRA
backup history
backup locks
backup recovery area to destination
backup tags mysql
backup validation
backup&recovery
Backup/Restore
Baltimore PHP
Bangalore Meetup
bare-metal server
Barracuda default
barry boehm
base64-output=DECODE-ROWS
bash on windows
bash script
bash scripts
Bash Training
Bash Upskill
basic programming
BasicKnowledge
Basisregistraties Adressen en Gebouwen
Batch Timings
bb enqueue
bbed 64 for windows
bbed for windows 64
bbed win64
bbed修改记录
be excellent
Beats by Dre
Beginner Series
Beginners Guide
Beginning Oracle SQL
begin_operation
being a good DBA
Benchmark MongoDB with sysbench
benchmarketing
benchmarking
Benchmarks
BerkeleyDB
Bernhard_Kinkel
best practice
Best Practices
best wishes
Better WP Security
BI (General)
BI integrations
BI Publisher
bi-directional
Big Data Analytics
big data appliance
Big Data Connectors
Big Data Discovery
big data lite
Big Data Platforms
Big Data Preparation Cloud Service
Big Fish Games
big oh notation
bijdbc.jar
Bill Karwin
Billing_and_Revenue_Management
Binary Log
Binary Log Events
binary log file encryption
Binary Logging
binary logs
Binary-, CLOB-, Object Relational Storage
bind variables
binlog encryption
binlog group commit
binlog server
binlog_format
BIN_TO_UUID
bipublisher
Birds of a Feather
Bitmap Indexes
black friday
block corruptions
Block Dumps
Blockchain
blocking sessions
blog issues
blog rolling
bloom filter
BMS_CORE_INTERNAL
Book Review
Book Reviews
Booking.com
Bootstrapping
Boston MySQL Meetup
Bounded Recovery
BR interval
breakout sessions
breakpoint
Brendan Howes
Brief Introduction
broken website
brown noise
Bruce Daley
Bryana Knight
BTREE index
Buenos Aires
buffer busy waits
buffer cache
buffer copy
Buffer Pool
Bug 6376915
BUG Reports
bug-or-feature
bugfighting
Bugs in MySQL 8.0
Build a MySQL Server
Build Percona Server
Build Scripts
Build Tools
BULK INSERT
Bullet to the Head
Bundle Patch
Bundle Patch 23
business analyst
business continuity
Business Insights
business intelligence
business of software
business service
but no Network HB&
C client library SSL
C.J. Insider
C/C++ Programming
Cache Buffer Chains
cache fusion mtu
CACHEDIRECTORY
calibrate_io
california
call for papers
calling python from mysql udf
callProcedureWithResults
Calvin Sun
Cambridge Analytica
campus recruitment
can&#8217;t
capacity planning
captain support
cardinality
Cardinality feedback
Career Advice
Carlos Rolo
Carlos Sierra
Carnegie Mellon
cascaded standby databae
Case sensitive
case studies
case study
cassandra configuration
Cassandra DBA
Cassandra Developer
Casual Consistency
catalog validation
catupgrd.sql
cause and effect
cell event
cell hidden parameter
cell physical IO bytes sent directly to DB node to balance CPU
Cell storage views
celldiag.pl
cellsrvstat
cellsrv_dump
cellsrv_setparam
CentOS/RHEL 6
CentOS7 修改主机名
CentOS7.2 CPU高
certificate
certification
certification protocol
certification-magazine
César Trigo Esteban
Change Data Capture
change management
change mysql binary log location
change mysql binary log path
change mysql relay log location
change mysql relay log path
change Oracle Warehouse Builder home
change OWB home
change OWB oracle home
Change Streams
change synchronization
change table prefix
Change user password in MySQL 5.7
Chapterhouse: Dune
character encoding
Character Sets
characterset
Charity Majors
Charles Colin
cheap oakleys
CHECKDB From Every Angle
checkip.sh
checkpoint
Chelsea Winfree
Chet Justice
Children of Dune
child_cursor
chnage oracle home
Chris Nelson
Chris Schneider
Chris Stone
Christian Rober
Christopher Alexander
classic capture
Clayton O’Neill
ClickHouse
ClickHouse. Webinar
clickstream data
CLIENT_STATISTICS
closed source
Cloud and MySQL
Cloud and NoSQL
Cloud and OpenStack
Cloud Computing
cloud control
Cloud Control. Release 4
cloud database
cloud management
cloud performance
cloud platform
cloud sharing
cloud stores
Cloud Tech
Cloudera data science workbench
cloudera impala
cloudflare
cloudformation
cloudlinux
cloudstack
clssgmpcBuildNodeList
Cluster 7.3
Cluster 7.5
Cluster Health Monitor
Cluster Manager
Cluster Time
clustercontrol
clustering
Clustering Factor
clusterware
clusterware startup
clusterware upgrade
cluvfy comp healthcheck
cmake changes
cmake mysql
Coalesce Cleanup
CockroachDB
Codelevels
coe_load_sql_profile
coe_xfr_sql_profile
coffeeshop
coincidence
Colin Charles
COLLABORATE
collaborate 16
collaborate 2012 presentations
Collaborate IOUG
Collaborate14
Collaborate16
collations
collection
collections
collectl-utils
colliertech
Column Groups
column mapping
column store
Column Store Database
column stores
columnar database
columnar databases
columnstore
Combo Patch
comic books
command completion
command line client
command-line
command-line tools
commentary
commercial licence
Commercial Products
commit monitor
commitmonitor
Common Table Expressions
communication
Communication Server
communications
Community Dinner
Community Love
community team
Company Culture
Company news
compare database
comparecols
comparing current past
comparison
compatibility
competence
Compilation
compilation errors
compile mysql group replication plugin on ubuntu
completion
complex queries
compliance
component KM
Component Processor
Components
compound statements
Compressed columns
compression
computer science
computerworld
Com_show_create_user
concatenation
concurrency
concurrent C++
conditional formatting
Conditional SQL
Conference
conferences
Conferences/Events
Conferneces
confidence
Configuration
configuration assistant
Configuration Variables
conflict detection
conflict resolution
Confluence
confluent platform
Connect 1.03.0005
Connect 1.03.0006
Connect 1.03.0007
connection
Connection Manager CMAN Oracle Network
connection pool
connection pooling
Connection-Control Plugins
connectionpool
connections
connector-c++
connector-j
connector-net
connector-net-core
connector-odbc
connector-python
Connector/C
Connector/J
Connector/NET
Connector/ODBC
connector/python
Connectors
connect_exact_info
connect_use_tempfile
connie smith
Consistency
consistent backups
consistent gets
consistent gets from cache
consistent gets from cache(fastpath)
Consistent IF EXISTS
consistent read
consolidation
constraint
constraint violation
consulting
container database
container databases
containerization
containers
Contention
Context Switches
Continuent
Continuent Tungsten
Continuent Tungsten Replicator
Continuous Delivery
ContinuousIntegration
contribution
Control Chart
control group
controlfile
controlfile backup to trace
controlfile missing
ConvexHull
Cool Stuff
coordinated
coordinates
copenhagen
Core analysis
corporate consciousness
corporate responsibility
Corrupt OCR
corrupted block
corrupted filesystem
corrupted table
Corruption
corruted table recovery
cost based optimizer presentations
cost monitoring
cost-based optimizer
count(*) optimizer work
counttable
covering index
CPU Benchmarks
CPU governor performance
CPU monitoring
cpufreq-info
cracklib_password_check password
craigslist
Crash courses
crash recovery
Crash-safe Replication
crashing bug
CREATE ANY DIRECTORY
create core dump in mysql
create table as select
CREATE TABLE of death
create user
credentials
critical metrics
critical patch update
CRM Composer
cross platform
Cross Platform Incremental Backup
cross platform transportable tablespace
crowdfunding
crsctl replace votedisk
crs不能关闭
cryptography
cssd not joining cluster
CURRENT_SCHEMA
current_scn
current_thd
cursor obsolete threshold
cursor sharig
Cursor Sharing
cursor: pin S
cursor: pin X
cursordump
cursortrace
cursor_sharing
custom build
custom functions
customer experience
customer success
cyber attacks
Cyber Security
dallas oracle users group
Dan Norris
Dan Simmons
Daniel Guzmán Burgos
Daniel Nichter
Dashboard Design
Dashboard Prompts
dashboards
data analysis
data analytics
Data at Rest Encryption
data cartridges
data column
data compare
data dictionary
data discovery
Data Durability
Data Egret
data files
Data Flow ML
Data flows
Data Frames
data freshness
data generator
data growth rates
Data Guard
data guard broker
Data in the Cloud
Data in the Cloud track at Percona Live
Data Infrastructure
data insertion
data integration
data integration tips
Data Integrator
data integrity
data integrity violation
data management
data mashup
data masking
Data Masking Pack
data migration
Data Mining
Data Mirroring
data modeling
data models
data only container
Data Performance
Data Quality
Data Recovery
data recovery advisor
Data Redaction
data reduction
Data Reservoir
data restoration
data science
data security
data stores
Data Streaming
Data Structures
Data Transfer
data types
data visualization
Data Visualization Desktop
data volume
data volume estimate
Data Warehouse
Data Warehousing
database 12
database 12c
Database Administration
Database Administration & Monitoring
database administrator
Database auditing
Database backup and recovery
database cluster
database community
database compression
Database Compression Methods
Database Concerns
Database Consolidation
Database Control
database deployment
database design
Database Development
Database DevOps
Database Economics
database express
Database File System
database files
database graphs
database high availabiluty
database identifier
Database in the cloud
database link
Database Links
Database Maintenance
Database Management
database metrics
Database Migrations
Database Mirroring
database monitor
Database Monitoring
database operations
database outage
database performance
Database Performance Team
Database performance Tuning
Database Poll
database recovery
Database Repair
database replication
Database security
database sequence
Database Snapshots
Database Stuff
database support
Database Technologies
database theory
database tools
database traffic
Database Trends and Applications
Database Vault
Database Virtualisation
database warm up
DataBase-as-a-Service
Database-Scoped Security Mode
datacenter
datapump slow
datapump utilities
datasetsvc
datawarehouse
date format
date range of the SSL certificates
date_created
date_updated
Datometry Hyper-Q
Davi Arnaut
David Bennett
David Bowie
David Busby
David Ducos
David Murphy
David Turner
David_North
db express
db tech Showcase
db-parameter-group
db4free.net
dba best practises
DBA Lounge
dba manager
dba team management
DBA Tools & Scripts
DBAs vs Devs
dbaspytools
DBA_ADVISOR_EXECUTIONS
DBA_ADVISOR_FINDINGS
dba_advisor_parameters
DBA_ADVISOR_RATIONALE
DBA_ADVISOR_RECOMMENDATIONS
DBA_ADVISOR_TASKS
dba_extents
dba_free_space
dba_hist_active_sess_history
DBA_HIST_INTERCONNECT_PINGS
DBA_REGISTRY_HISTORY
DBA_REGISTRY_SQLPATCH
DBA_SQLTUNE_BINDS
DBA_SQLTUNE_PLANS
dba_sql_profiles
DBD::Oracle
dbdeployer
DBLOGREADER
DBLOGREADERBUFSIZE
dbm configurator
DBMS developer
DBMS_APPLICATION_INFO
dbms_cloud
DBMS_COMPRESSION
DBMS_CRYPTO
dbms_datapump
dbms_diskgroup
dbms_feature_awr
dbms_feature_usage_report
dbms_file_transfer
DBMS_FLASHBACK_ARCHIVE
DBMS_LOGMNR_D.BUILD
DBMS_METADATA
dbms_monitor
dbms_output
dbms_part.cleanup_gidx
DBMS_QOPATCH
dbms_rcvcat
dbms_redact
dbms_resource_manager
DBMS_RESOURCE_MANAGER.CALIBRATE_IO
dbms_rowid
DBMS_Scheduler
DBMS_SPACE
DBMS_SQLTUNE
dbms_sql_monitor
dbms_start_logmnr
DBMS_STATS
DBMS_SYSTEM_INTERNAL
dbms_utility
dbms_workload.add_colored_sql
dbms_workload_repository
dbms_xplan
dbms_xplan advanced
dbms_xplan allstats last
dbtechshowcase
dd for windows
DDL synchronization
DDL trigger
deadlock detection
debra lilley
declaration
Dedicated hot spare disk
deduplication
Deep Information Sciences
Default Configuration
default port
default roles
default_password_lifetime
Deferred Segment Creation
define variable
definition
defrag innodb
defrag innodb tablespace
defragment innodb
defragment innodb tablespace
Defragmentation
delete recover
dependencies
dependency hell
deploy112.sh
deploy11203.sh
deployment
deprecating PerconaFT
Derek Downey
descending indexes
Desktop Heap Size
Desupported
desynced node
desynchronized nodes
deterministic
deterministic database systems
developer day
Developer insight
Developer Meeting
developers
development
Development & Performance
development and testing
Development Tools
Development with MySQL
device mapper
DG&RAC&OGG
diagnosing Oracle performance problems
Diagnostic tools
diagnostics
diagnostics.iso
dictionary
dictionary cache
dict_set_corrupted
difference
DigitalOcean
dimensional
Dimensional Modelling
dimensions
Dimitri Kravtchuk
Dimitri Vanoverbeke
direct load
direct path read
dirty galera reads
dirty pages
disadvantages
Disaster Recovery
disconnect
discovery service
Disjunctive Subquery
Disk Encryption
disk full error in slave server
disk full error with binary log
disk header
Disk Performance
Diskgroup and Database Details
display_awr
display_cursor
disruption
distributed
Distributed Binlog Server Service
Distributed command line interface
Distributed Computing
distributed database systems
Distributed Recovery
distributed transactions
Distributions
Django Unchained
DMA Exadata Administration Management
dml删index
dmp corruption
dmp recovery
Do not ignore warnings
docker io overhead
docker machine
Docker network
Docker Swarm
docker volume
Document database
document size in MongoDB
document store
document stores
documentation
documenter
domain_id b
Domas Mituzas
Don Norman
donors choose
double column feature
double-write buffer
DoubleWrite
Doug Burns
Doug Shelley
Douglas Mendizábal
download mariadb
download mariadb 10.0
download MariaDB 10.0.15
download MariaDB 10.0.16
download MariaDB 10.0.17
download MariaDB 10.0.18
download MariaDB 10.0.19
download MariaDB 10.0.20
download mariadb 10.1
download MariaDB 10.1.4
download MariaDB 10.1.5
download MariaDB 10.1.6
Download MariaDB 5.5.41
Download MariaDB 5.5.42
Download MariaDB 5.5.43
Download MariaDB 5.5.44
download mysql 5.6
download mysql 5.7
Downloding MariaDB&#8217;s MaxScale binaries
downstream
Downstream Capture
DRM freeze
Drop column
DROP DATABASE
drop database recover
Drop Index
drop table
drop table recover
drop_caches
DROWN mitigation CVE-
dumping file header
dumpnodeview
Duncan Ford
Dune Messiah
dunning-kruger
duplicate database
duplicate database from active
duplicate values
Duplication
DVD plugin
dvt-graph-skin.xml
DW Offloading
dx enqueue
Dynamic Code
dynamic groups
dynamic range
Dynamic Resource management
dynamic sampling
dynamic sql
Dynamic Statistics
dynamic views
dynamic_sampling
E-business
E-Business Suite
e-business+suite
e-commerce
eager_size
Early Bird
eBusiness Suite R12
Edge of Tomorrow
editing mysql source code
educational course
Educational Video
Edward Tufte
Effective MySQL
EffectiveMySQL
efficiency
efficient function calls
eight-socket
elasticsearch
election Protocol
eli goldratt
EM Grid Control
Embarcadero
emctl reload agent
emoms.properties
enablemonitoring
encryption
Encryption at rest
encryption,rman
encryptkey
end of life
end-user experience
end_operation
engineered
engineering
enhanced usage tracking
enhancements
Enkitec Extreme Exadata Expo (E4)
enq: TM &#8211; contention
enq: TX &#8211; row lock contention
enterprise
Enterprise Edition
Enterprise Infrastructure
enterprise linux
Enterprise Manager
enterprise security
entertainment
entrepreneurship
environment
ercona Server
Eric Brewer
Erik Beebe
Ernie Souhrada
Errant Transactions
errno: 140 &Wrong create options&
ERROR 1005 (HY000): Can&#8217;t create table
error 1045
ERROR ): Unknown column &#8221; in &#8216;field list&#8217;
error 1236
error code
Error Correction
errorstack
ER_WARN_PURGE_LOG_IN_USE
ER_WARN_PURGE_LOG_IS_ACTIVE
essbase analytics link
essbase studio
Estimate Index Size
etherchannel
ETL processes
Europe/Zurich
european tour
Eva Donaldson
Evangelist
event 10049
Event 60060
Event Scheduler
Events and Announcements
Events and Conferences
eventual consistency
everything
EVOLVE_SQL_BASELINE
exadat X5-2
Exadata Architecture
exadata ASM
Exadata Config
Exadata Configuration
Exadata dbm
exadata dhcp
Exadata Diagnostic
Exadata FAQ
Exadata Flashcache
Exadata Fundamental
Exadata Installation
exadata nfs
Exadata OS
Exadata pam
exadata password
Exadata Patch
Exadata Patching
Exadata PXE
Exadata Security
Exadata Simulator
Exadata Smart Flash Logging
exadata tftp
Exadata Troubleshooting
Exadata Utility
Exadata Virtuabox
Exadata VM
exadata X5
Exadata X5-2
exadata_express
Exadata健康检查
Exadata升级
Exadata安全
Exadata安全加固
Exadata密码
Exadata文件系统
Exadata自动磁盘管理
Exadata虚拟机
Exadata诊断
Exadata进程
Exadata部署
Example Scripts
exceptions
exchange partition
exclude and include parameters
exclusive pool
execute physical
Execution Plan
Execution plans
exended SQL trace
eXFlash DIMMs
exp dmp恢复
expdp poor performance
expdp sqldeveloper
expdp stuck
expdp to ASM
Experimental build
experimentation
Expert Services Desk
Expiration Date
EXPIRED(GRACE)
expire_logs_days
Explain command
EXPLAIN FOR CONNECTION
EXPLAIN FORMAT=JSON
EXPLAIN FORMAT=JSON is cool!
explain plan
Explain Plan For Index
EXPLAIN statement output
export by view
exportserviceinstance
expression
Expression Filters
expressions
EXT4 transactions
extended data types
Extended Events
extended statistics
external table
External tables
external tools
ExtractValue
extreme programming
extundelete
Fabric Database
Facet Aggregation
Fahd Mirza
failed jobs
failure scenarios
Fake Indexes
fake oakley sunglasses cheap
fake oakleys
Fast & Furious 6
Fast Connection Failover
fast queries
Fault Detection
Featured Session
featured talk
Fernando Ipar
Fernando Laudares
fetch first
File carving
file ownership
file per table tabplespace in mysql
File table overflow
file-key-management
file-key-management-filename
filesystem
filesystems
filter early
filter late
Filter Pushdown
final episode
financials
fine grained access control
Firewalling
fixing mysql bug
fixing-bugs
flame graph
flash cache
flash memory
flashback database
flashback pdb
Flashback Query
flashquery
Flex Clusters
flexible schema
flow control
flow control status
flow_control
FLUSH LOGS
flush table with read lock
FLUSH TABLES WITH READ LOCK
force_matching_signature
foreign key
Foreign Keys
foreignkey
format release. goldengate
formatting
Forrester Research
Forum Spam
FOSDEM 2015
FOSDEM2015
Foundation
FoundationDB
fractal tree
Fractal Trees
Fractal Tree(R) Indexing
fractional
fractional seconds
Fractured block
fragmentation
fragmentation and reassembly
frameworks
Franciso Bordenave
Frank Herbert
Free Software
freedomeverywhere
freesoftware
Friday Philosophy
friend of a friend
Frits Hoogland
FromDual GmbH
fsync performance
fts_optimize_thread
full backup
full database caching
full page load monitoring
Full Text Search
full transport
full-text search indexes
Function Based Indexes
function-based index
functional index
fundamentals
Fusion Applications
GA MariaDB
galera cluster
Galera Error
Galera Error Failed to Report Last Committed
Galera GTID
galera replay transaction
Galera replication
galera repliction
Galera&#8217;s
galera.cache
game of thrones
gamification
Gartner Operational DBMS
Gary Goodman
gather_table_statistics
gc block lost
gc buffer busy
gc buffer busy acquire
gc buffer busy release
gc lost packets
gcache purge
gcache.page_size
gcache.recover
gcache.size
Geek culture
Geir Hoydalsvik
General Administration
General Availability MariaDB
General Engineering
General Network Information
General Oracle
generated as always
Generated columns
genloadfiles
geo enabled applications
geo search
geo-cluster
Geoffrey Anderson
geographic information system
Geographic Replication
geographical redundancy
GeoJSON and MySQL
George Lorch
georgia oracle users group
geospatial
geospatial programming
gerwin hendriksen
ges resource
ges_cache_ress
getbeforecols
GETPARAMINFO
GGUSR.DDLREPLICATION
Gillian Gunson
github.com
Giuseppe Maxia
giuseppe maxima
Global Cache Average CR Get Time
global counter
global hint
global hints
global hot spare disk
Global Indexes
Global Payroll
Global Transaction IDs
global variables
globalfoundries
GLOBAL_NAME
global_temporary_tables
Global_THD_manager
God Emperor of Dune
golden gate
GoldenGate
goldengate 11.2.1
GoldenGate 12.2
goldengate 12c release 3
goldengate 12c veridata jagent monitor
goldengate director
goldengate director client
goldengate director server
goldengate performance tuning
Good practice / Bad practice
Google Analytics
Google Big Query
Google Cloud
Google Cloud Platform
Google Cloud Services
Google Cloud Spanner
Google Cloud SQL
Google Compute Engine
Google Container Engine
Google Developer Console
Google Drive
google glass
Google Maps
google plus
google reader
governance
government
graph analysis
graph analytics
graph database
Graph Databases
Graph descriptions
Grid control
Grid control and agents
grid infrastructure
Grid Infrastructure / RAC
grid infrastructure 12c
grid insfrastructure
Group Communication System
group replication
Group Replication Certification
group replication plugin on ubuntu
GTID Replication
GTID-based replication
guest blogger
GUI monitoring tools
GV$EVENT_HISTOGRAM
gv$session
gwen shapira
Gwen_Lazenby
hadoop node.js hdfs
hadoop summit
HandlerSocket
Handler_icp_%
Handler_icp_attempts
Handler_icp_matches
hang manager
hanganalyze
happy holidays
happy-birthday
happynewyear
hard drive replacement
hard parse
Hardware and Storage
Harrison Fisk
hash anti join
HASH GROUP BY
hash join bufferred
hash partitioning
Hawkular Metrics
heartbeat fatal
heat matrix
HeidiSQL 9.1
Heikki Tuuri
heinemeier-hansson
HelloWorld
help wanted
henry ford
Heretics of Dune
heterogeneous
heterogenous
hetherington
Hewlett-Packard
Hibernate training
Hibernate tutorial
hidden column
Hidden columns
hierarchical data
Hierarchical SQL
hierarchies
high availabiity
high availability
High Availability & Backup/Recovery
High Availability (HA)
high availability with asynchronous replication
high latency network environment
High Performance
High Performance MySQL
high-load clusters
Higher Education
Hints and tips
histograms
holiday shopping
home selector
Hortonworks
hostnamectl
hosts.sample
hot cloning
HOTSOS 2010
hotsos 2013
Hotsos Symposium
HotUKDeals
housekeeping
how to add debug option in mysql?
how to apply patch to mysql?
how to be a DBA
how to install debug mysql?
how to install patch to mysql?
How to set up MariaDB Connector C
How to use LDAP with MariaDB PAM
How to use MariaDB Connector C
how to use ssl connection in mysql?
how to use ssl with mysql?
How X Plugin
hp to solaris
HP Vertica
Hrvoje Matijakovic
huge database migration
Huge Pages
hugepages_settings.sh
Hung MySQL Transaction
hybrid columnar compression
Hybrid Hash
Hyper-threading
Hyperion Cantos
Hyperion Essbase
Hyperion Smart View
hyperthreading
I/O thread
ibdata1 恢复
idempotent
identified by values
identifier
identifiers
identify objects redo
identify patch
identity column
Identity Columns
if_not_found
IGNOREDELETES
IGNOREUPDATES
Ignoring Hints
Igor Canadi
imagehistory
impdp sqldeveloper
impersonate
Implicit Conversion Hierarchy
implicit statement results
IMPORT TABLESPACE
importance of documentation
importeren van BAG data
importserviceinstance
in memory option
in-database archiving
in-memory computing
In-Memory Computing Summit 2017
In-Memory Data Fabric
In-Memory Data Grid
in-memory data grids
In-Memory Databases
In-memory processing
Incarnation
Incident Packaging Service
incomplete recovery
inconsistency
incremental
incremental backup
incremental backups
incremental recovery
incremental recovery of standby from primary
incremental state transfers
incremental_statistics
Index Block Size
Index Coalesce
Index full fast scan
Index Internals
Index Joins
Index key not found
Index Organized Tables
Index Rebuild
Index Rebuilds
Index Scan
index sort order
Index statistics
Indexes From Every Angle
Indexes in Exadata
index_merge_intersection
Industry Info
Industry Round-Up
infiniband
infinichecke
InfoBright
Informatica
information
information schema
information technology
information_schema
INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYP
infrastructure
inheritance
init script
init.ohasd
initial load
Initial Load Methods
initialrender
inject queries
InMemory Advisor
innobackupex
innochecksum tool
InnoDB 32KB and 64KB page size
InnoDB 5.6.21
InnoDB 5.6.22
InnoDB 5.6.23
InnoDB 5.6.24
InnoDB 5.6.25
InnoDB buffer pool
InnoDB buffer pool size
innodb bug
InnoDB Cluster
InnoDB Compression
InnoDB Concurrency
InnoDB crash recovery
InnoDB crashing bug
InnoDB enhancements
innodb flush method
InnoDB general tablespace
Innodb internals
InnoDB isolation modes
InnoDB lock up
InnoDB locks
InnoDB native partitioning
InnoDB page compression
InnoDB Performance
InnoDB Persistent Statistics
Innodb recovery
InnoDB Redo Logs
InnoDB regression bug
InnoDB Ruby Tool
InnoDB Scalability metrics
InnoDB stall halt bug
InnoDB table
InnoDB Table Compression
innodb table corruption
InnoDB tables
InnoDB tablespace
InnoDB. monitoring
innodb_buffer_pool_chunk_size
innodb_buffer_pool_instances
innodb_buffer_pool_size
innodb_compression_level
innodb_corrupt_table_action
innodb_deadlock_detect
innodb_fas
innodb_fast_shutdown
innodb_file_per_table
innodb_file_per_table=OFF
innodb_force_primary_key
innodb_force_recovery
innodb_io_capacity
innodb_io_capacity_max
innodb_kill_idle_transaction
innodb_log_file_size
INNODB_METRICS
innodb_page_size
innodb_sort_buffer_size
innodb_stats_traditional
innovation
Innovation Pack
inondb_force_recovery
insert causing deadlocks
insert data from mysql into mongodb
insert into slow
insertallrecords
Inside Pythian
Inside the Storage Engine
Insight for DBAs
Insight for Developers
Insight Lab
instala??o
install group replication enabled mysql with sandbox
install upgrade migrate
Installation
Installation and Deinstall
Installation and Upgrade
Installation template
installations
installing haproxy and keepalived with pxc
installing mysql from source
installing mysql from source using cmake
installing percona xtradb cluster on centos 7
instance caging
instance crash
instance viewer
instanceconfig.xml
instant client
Instantiating disk: failed
instantiation
instruction
Instrumentation
integrated
integrated capture
integrated extract
integrated replicat
Integration
integrator
integrity violation
intel edison
intelligence
interactive_timeout
interested transaction list
interleaved griddisk
interleaving griddisk
internal_tmp_disk_storage_engine
internet archive
Internet Explorer
Internet Explorer 11
internet of things
interval partitioning
interview question
Interviews
introduction
invalid ASM block header
invalid identifier
invalidation
inverstigate disk full errors
investment model
invisible column
Invisible Columns
invisible index
invisible indexes
io overhead
IO Performance
IO Subsystems
IO-bound workload
IPC Send timeout
ipfrag_high_thres
ipfrag_low_thres
ipfrag_time
ip_arp_done: init failed
Iron Man 3
irqbalance
isolation levels
isolation mode
iSomething
IST not SST
It&#8217;s my life
ITL shortage
I_DEPENDENCY1
I_DEPENDENCY2
Jacco Landlust
Jacque Istok
James Bond
James Gosling
james harkey
james morle
Jan Peterson
January PSU
Jared Still
jason fried
Jason Rouault
Jason Stamper
java agent
Java and Middleware
Java Developer
Java Virtual Machine
javascript
javatshirt
Jay Janssen
JDeveloper
Jean-Fran?ois Gagné
Jenni Snyder
Jeremy Cole
Jeremy Tinley
Jervin Real
Jim Butcher
Jim Doherty
Jim Starkey
joel garry
joel spolsky
Johan Andersson
John Scott
JOIN elimination
Jonas Oreland
Jonathan Ive
jonathan lewis
jooq-development
Josh Snyder
journal table
JPublisher
JQuery JavaScript
jQuery Mobile
JSON data type
JSON document fast lookup with MySQL 5.7
JSON functions
JSON Schema validation
JSONCONTAINS
json_array
json_arrayagg
JSON_EXTRACT
json_object
json_objectagg
json_query
json_table
json_value
July 3 2015
July 9 2015
Jumbo Chunks in MongoDB
Jumbo Frame
Jumbo frames
jumping to conclusions
June 12 2015
June 17 2015
June 24th 2015
June 26 2015
June 3 2015
June 30 2015
June 4 2015
jupyterhub
justin kestelyn
Justin Swanhart
kafka connect
Kaleidoscope
Karthik Appigatla
Kat Styons
kclchkblk_4
kcrfr_update_nab_2
keep identity
keepalived
Kenny Gorman
Kenny Gryp
kernel engineer
kernel extensions
kernel_mutex
kerry osborne
Kevin Closson
key value pairs
keyboard shortcut
key_block_size
kfbtTraverseBlock
kfed write
KFED-00322
kffbAddBlk04
Kickstarter
kill cssd.bin
Kill Idle Transactions
kill long running transactions
killSessions
Kim Wilkins
Kirk Leibert
kjbcrcomplete
kkoutlCreatePh
kksfbc child completion
Konstantin Osipov
Kortney Runyan
ksh: no space
Kubernetes
kupc$que_init.receive
kxs-heap-c
Kyle Bader
La La La Human Steps
labalchemy
labs.mysql.com
Lahdenmaki
Laine Campbell
Lambda Architecture
large database migration
large object
large tables
large+pages
Larry Ellison
last login time
Latch Statistics
latch: library cache
lateral view
Latin America
LDAP and MariaDB PAM
LDAP MySQL
LDAP. authentication
leadership
Leaf Blocks
LeakSanitizer
Leap Second
leap seconds
Learning Session
Least Recently Used
Legacy Applications
Leif Walsh
Lennart Poettering
LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (16198)
LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
libmysqlclient
libnuma.so.1
Library Cache
library cache lock
library cache pin
libttsh11.so
Lifeatpythian
LifeStreet
lightning talk
Lightning Talks
limitations
Limitread is not enabled for standby db
line breaks
linear scaling
link listener.ora
link tnsnames.ora
LinkBenchX
linked data
Linux Administration
Linux Administrator
linux commands
Linux Developer
Linux Development
Linux Foundation
Linux Insider
linux scripting
Linux System Admin
Linux Training
Linux Upskill
Linux, UNIX
linux-kernel
Linux7 修改主机名
LinuxQuestions.org
linux、unix、windows
Linux安全加固
Linux服务器
list databases
list failure
list partitioning
Listener Logs
listener_networks
little endian
Live Debugging
live patching
Liz van Dijk
lloyd williams
LMD0: terminating instance due to error 482
LMON process terminated
load average
load balancer
Load Balancing
load data infile
load profile
lob storage
Local Indexes
local undo
Locally Managed Tablespace
lock escalation
LOCK TABLE
lockdown profile
lockdown profiles
locked accounts
locking issues
LOCK_ESCALATION
Log Buffer
log buffer space
log file parallel write
log file size
log file sync
log file sync waits
log rotate script for mysql
log rotating mysql
Log Shipping
log writer
logdef* : kkoabr
logical backup
Logical I/O
Logical MySQL backup tool
logical reads
Logical Replication
Logical Sequence Number
Logical Sequence Numbers
logical sql
logical standby
Loic Dachary
look and feel
loose_ option
loss of all database files
lossless RBR
lost controlfile
low-level Client API
lower_case_table_names make unavailable uppercase database and tables
lower_case_table_names option caution
Lucas Jellema
Luis Motta Campos
M17 Conference
macbook pro
Machine Learning
Machine Zone
Machine-generated data
Madrid MySQL Users Group
Magic Quadrant
maintenance
major upgrade
makeImageMedia
Man of Steel
Management
Management Agent
management server
Managing Multimedia and Unstructured Data in the Or}

我要回帖

更多关于 oracle11g配置 的文章

更多推荐

版权声明:文章内容来源于网络,版权归原作者所有,如有侵权请点击这里与我们联系,我们将及时删除。

点击添加站长微信