xpp_derr.ppt

Common Streams Error Messages Objectives After completing this lesson, you should be able to use error messages for the troubleshooting of: Capture process Propagation Apply process Streams Advanced Queuing Troubleshooting Capture:ORA-00902 Error ORA-00902: invalid data type The capture process is aborted. Trace file shows ORA-00902. Review rules to verify that rules are defined only on tables with columns of supported data types. Remove rules for the table that is generating the error. Troubleshooting Capture: ORA-00258 Error ORA-00258: manual archiving in NOARCHIVELOG mode must identify log Verify that archive logging is configured for the source database. Common Capture Errors ORA-00258 ORA-00902 ORA-01291 and ORA-01323 ORA-1280 ORA-01291 and ORA-01323 Capture Errors ORA-01291: missing logfile ORA-01323: invalid state Indicates that an archived log file cannot be opened by the capture process Common Propagation Errors ORA-12154: TNS:could not resolve service name. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. ORA-12541: TNS-12541 TNS:no listener ORA-25315 unsupported configuration for propagation of buffered messages. Common Apply Errors ORA-00001: unique constraint (%s.%s) violated ORA-02291: parent key not found ORA-02292: child record found ORA-01031: insufficient privileges ORA-06550: line x, column y: ORA-23416: table does not contain a primary key constraint ORA-23607: invalid column ORA-26687: no instantiation SCN provided ORA-26688: missing key in LCR ORA-26688: metadata mismatch ORA-26689: column datatype mismatch in LCR ORA-26786: no data found (on top of ORA-01403) ORA-26787: no data found (on top of ORA-01403) Common Data Conflict Errors Unique conflicts ORA-00001: unique constraint (%s.%s) violated Foreign key or ordering conflicts ORA-02291: parent key not found ORA-02292: child record found ORA-01031: Insufficient Privileges The designated apply user must have the privileges to perform SQL on th