Monthly Archives: 六月 2014

GoldenGate cannot acquire password for jmxUser

0

Posted on by

版本:

Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 
Linux, x64, 64bit (optimized), Oracle 10g on Oct  4 2011 23:50:20

 

  在启动agent的时候,报密码不对,报错如下:

2014-06-18 14:50:33  WARNING OGG-01689  Oracle GoldenGate Manager for Oracle, mgr.prm:  Thread: agentRegistration, Message: MBeansContainerImpl.java::::::1266 javax.security.sasl.SaslException: DIGEST-MD5: cannot acquire password for jmxUser in re[......]

查看全文

GoldenGate Error loading function jvm from JNI_GetCreatedJavaVMs

0

Posted on by

版本:

Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 
Linux, x64, 64bit (optimized), Oracle 10g on Oct  4 2011 23:50:20

 

ogg在配置monitor agent时报错:

2014-06-18 14:38:59  INFO    OGG-00983  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started (port 7809).
2014-06-18 14:38:59  INFO    OGG-01227  Oracle GoldenGate Manager for Oracle, mgr.prm:  Waiting for connection on port 7809 ..
2014-06-[......]

查看全文

postgres Synchronous replication 搭建

0

Posted on by

     Synchronous replication 其实就是同步复制,即意味着直到被主服务器和复制服务器均接收完事务时,事务才会返回给应用程序。这点就确保了即便在主服务器永久下线的情况下,任何已提交事务的数据都不会丢失。

    其实同步搭建和异步搭建只需要在主库上和备库上新增一个配置文件就可以了。

    异步同步搭建链接:postgres streaming replication 搭建

 

主库:

在postgresql.conf配置文件中新增:

synchronous_standby_names = 'mydb_standby'

 

备库:

在recovery.conf 配置文件修改:

primary_conninfo = 'host=192.168.1.11 port=5432 u[......]

查看全文