学海无涯

2020-12-11 王殊勋 阅读(118) 评论(0)

源端是警告 ：WARNING OGG-01194 Oracle GoldenGate Capture for Oracle, eini_1.prm: EXTRACT task RINI_1 abended : Could not open checkpoint file /home/ora...

2020-12-10 王殊勋 阅读(105) 评论(0)

ORACLE RAC 配置OGG时，启动rac 的extract 进程时日志提示如下：2017-10-25T23:55:10.619+0800 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, ext1.prm: error ...

2020-12-10 王殊勋 阅读(101) 评论(0)

conn /as sysdba alter user scott account unlock; commit;

2020-12-10 王殊勋 阅读(103) 评论(0)

有时候我们需要通用的实验数据，emp表与dept表，但是数据库中有没有。这时，我们可以手动创建。创建表与数据：CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(...

2020-12-09 王殊勋 阅读(92) 评论(0)

ogg启动同步的时候ggserr.log报错：Operating system character set identified as UTF-8. Locale: zh_CN, LC_ALL:. OCI Error beginning session (status = 1034-ORA-0...

2020-12-09 王殊勋 阅读(56) 评论(0)

执行ggsci出现报错：./ggsci ./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory [oracl...

2020-12-09 王殊勋 阅读(61) 评论(0)

部署ogg过程中遇到如下错误：GGSCI (db1) 1> dblogin userid ogg,password seeyon ERROR: Unable to connect to database using user ogg. Please check privileges. O...