OGG:ERROR: Could not delete DB checkpoint for REPLICAT REPL
在OGG的配置过程中,可能你会遇到如题的错误。
它的具体场景是,你的OGG中有一个REPLICAT复制进程,但是你希望删掉重新配置:
1 2 3 4 |
GGSCI (ogg3) 17> delete replicat REPL ERROR: Could not delete DB checkpoint for REPLICAT REPL (Database login required to delete database checkpoint) GGSCI (ogg3) 18> |
解法:
其实,对于REPLICAT这样的进程要执行删除,你需要先“dblogin”才可以,如下:
1 2 3 4 5 6 7 8 |
GGSCI (ogg3) 18> dblogin userid oggadmin,password oracle Successfully logged into database. GGSCI (ogg3 as oggadmin@andy) 19> delete replicat repl Deleted REPLICAT REPL. GGSCI (ogg3 as oggadmin@andy) 20> |
————————————
Done。