内容发布更新时间 : 2025/2/6 23:31:53星期一 下面是文章的全部内容请认真阅读。
Oracle Net Services 配置:
1. Xlib: connection to \Xlib: No protocol specified Error: null
解决: 切换到root用户执行一下：xhost local:oracle 将listener.ora和tnames.ora中带host改成ip
GGSCI (ogg1) 35> delete trandata test.demo
2. Database error 54 (ORA-00054: resource busy and acquire with NOWAIT specified, SQL ALTER TABLE \\ /* GOLDENGATE_DDL_REPLICATION */). 解决：清楚对demo表的占用即可
3. 2013-09-05 09:50:54 ERROR OGG-01161 Bad column index (3) specified for table GGS.DEMO2, max columns = 3. 表结构不一致原因
4. Switching to next trail file ./dirdat/VJ000045 at 2013-09-05 14:23:54 due to EOF, with current RBA 2245 队列文件捕捉错误
5. 2013-09-05 14:23:54 INFO OGG-01020 Processed extract process RESTART_ABEND record at seq 45, rba 1989 (aborted 0 records). 队列文件错误
6. 2013-09-09 14:07:15 ERROR OGG-01028 Incompatible record (logical EOF) in ./dirdat/VB000010, rba 1469. 队列文件出错，队列文件絮乱
7. 2013-09-10 12:56:47 ERROR OGG-00664 OCI Error beginning session (status = 12705-ORA-12705: Cannot access NLS data files or inval id environment specified).
8. 2013-09-10 12:56:47 ERROR OGG-01668 PROCESS ABENDING. 编码双引号为中文状态
9. 2013-10-14 09:16:04 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, extbam.prm: Getting attributes for ASM file +dcods/yyjc/archivelog/2_36623_810668564.dbf, SQL
10. 2013-09-15 09:48:37 ERROR OGG-00360 WHERE cannot be used with PASSTHRU. 过滤条件有where不能用passthru
修改ogg配置参数过后必须要从新启动该进程
11. 2013-09-16 22:58:31 ERROR OGG-00446 Unable to lock file \ Lock currently held by process id (PID) 2562. ERROR OGG-01668 PROCESS ABENDING. 进程名称不一致，和添加远程队列不一致
12. 2013-09-25 09:50:23 ERROR OGG-00664 OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available 13. ORA-27101: shared memory realm does not exist 数据库实例为启动
14. ERROR OGG-00014 Oracle GoldenGate Delivery for Oracle, treplbj.prm: Unrecognized parameter: EPLICAT. Parameter could be misspelled or unsupported. 参数错误
15. ERROR OGG-00199 Oracle GoldenGate Delivery for Oracle, treplcq.prm: Table XF_OGG_TEST.ECP_CONPERF_RECEIVED does not exist in target database. 不存在这个表，参数错误
16. WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, treplcq.prm: OCI Error ORA-00001: unique constraint (XF_OGG_TEST.PK_PRE_BUS_ITEMFACT_S) violated (status = 1), SQL 17. ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, treplcq.prm: Error mapping from XF_OGG_TEST.PRE_BUS_ITEMFACT_S to XF_OGG_TEST.PRE_BUS_ITEMFACT_S. 数据不一致 18. ERROR OGG-01028 Oracle GoldenGate Delivery for Oracle, treplcq.prm: Incompatible record in ./dirdat/CQ000067, rba 4779 (getting header). 19. ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, treplcq.prm: PROCESS ABENDING. 队列文件读取错误【discard文件详细信息】 20. SQL error 1403 mapping XF_OGG_TEST.PRE_BUS_ITEMFACT_S to XF_OGG_TEST.PRE_BUS_ITEMFACT_S. 数据不一致【discard文件详细信息】 21. ERROR OGG-01161 Oracle GoldenGate Delivery for Oracle, treplvj.prm: Bad column index (3) specified for table GGS.DEMO2, max columns = 3 表结构不一致 22. ERROR OGG-01044 Oracle GoldenGate Capture for Oracle, spumpbj.prm: The trail './dirdat/CQ' is not assigned to extract 'SPUMPBJ'. Assign the trail to the extract with the command \未添加所要投递队列的名称，或者添加错误 23. ERROR OGG-00664 Oracle GoldenGate Capture for Oracle, spumpbj.prm: OCI Error during OCIServerAttach (status = 12514-ORA-12514: TNS:listener does not currently know of service requested in connect descriptor). 24. GGSCI (ogg1) 16> add trandata mytest.demo; ERROR: No viable tables matched specification ogguser权限不足 25. ./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory export LD_LIBRARY_PATH=$ORACLE_HOME/lib环境变量未引入 vi .bash_profile ---. .bash_profile source .bash_profile 26．ERROR OGG-00868 no data found retrieving if to ignore this object 异构文件生成过程中报错。用户下面没有某张表。表所在用户填写错误。 27. OGG-01028 encountered commit SCN 0.234946815 (234946815) that is not greater thanthe highest SCN already processed 0.234946819 解决办法: Document searched : OGG Encountered SCN That Is Not Greater Than The Highest SCN Already Processed [ID 957112.1] Applies to: Oracle GoldenGate - Version: 6.0.0 and later [Release: 6.0.0 and later ] Information in this document applies to any platform. Solution Issue: Extract ERROR 180 encountered commit SCN Solution Overview: This error occurs shortly after a transaction is written to the idle node but does not yet appear in the redo log when the current transaction is processed. This transaction will have a higher SCN than the previous transaction Solution Details: In an Oracle RAC environment, Extract has a coordinator thread. This thread assembles the operations that are generated on each of the RAC nodes into SCN order. Before starting to assemble the transactions, Extract waits for a short time after Oracle writes the transaction to the redo log. If a node has