BOTH LINUX 5.10, OGG 12.2.1, ORACLE 11204
I want to copy some tables dml to another oracle db, When I start extract process ext_ap01, it return such error
| 2016-03-09 17:45:26 INFO | OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 172.16.1.101:18111 (START EXTRACT EXT_AP01 ). |
| 2016-03-09 17:45:26 INFO | OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT_AP01 starting. |
| 2016-03-09 17:45:26 INFO | OGG-00992 Oracle GoldenGate Capture for Oracle, ext_ap01.prm: EXTRACT EXT_AP01 starting. |
| 2016-03-09 17:45:26 INFO | OGG-03059 Oracle GoldenGate Capture for Oracle, ext_ap01.prm: Operating system character set identified as UTF-8. |
| 2016-03-09 17:45:26 INFO | OGG-02695 Oracle GoldenGate Capture for Oracle, ext_ap01.prm: ANSI SQL parameter syntax is used for parameter parsing. |
| 2016-03-09 17:45:26 INFO | OGG-02095 Oracle GoldenGate Capture for Oracle, ext_ap01.prm: Successfully set environment variable ORACLE_SID=deer. |
| 2016-03-09 17:45:26 INFO | OGG-02095 Oracle GoldenGate Capture for Oracle, ext_ap01.prm: Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.AL32UTF8. |
2016-03-09 17:45:26 ERROR OGG-02636 Oracle GoldenGate Capture for Oracle, ext_ap01.prm: The TABLE specification 'TABLE APPS.*' for the source table APPS.* does not include a catalog name. The database requires a catalog name.
2016-03-09 17:45:26 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext_ap01.prm: PROCESS ABENDING.
| 2016-03-09 17:45:29 INFO | OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all. |
GGSCI (oracle2mysql as ogg_user@deer) 31> view param ext_ap01
EXTRACT ext_ap01
setenv (ORACLE_SID="deer")
setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
REPORTCOUNT EVERY 1 MINUTES, RATE
numfiles 5000
DISCARDFILE ./dirrpt/ext_ap01.dsc, APPEND,MEGABYTES 100
DISCARDROLLOVER AT 3:00
exttrail ./dirdat/r1,megabytes 100
dynamicresolution
TRANLOGOPTIONS EXCLUDEUSER ogg_user
TABLE APPS.*;
Why?