Time synchronization in Oracle causes Ogg deployment exception

Source: Internet
Author: User
Tags character set file size reserved oracle database linux

First, error checking

[Oracle@srtcreen ~]$ Ggsci

Oracle Goldengate Command Interpreter for Oracle

Version 11.1.1.1.1 oggcore_11.1.1.1.1_platforms_110729.1700

Linux, x64, 64bit (optimized), Oracle 10g on June 29 2011 19:43:29

Copyright (C) 1995, Oracle and/or its affiliates. All rights reserved.

Ggsci (srtcreen) 1> info All

Program Status Group Lag time Since chkpt

MANAGER RUNNING

Replicat RUNNING r_1 00:00:00 00:00:07

Replicat RUNNING r_2 00:00:00 00:00:05

Replicat abended r_3 19:19:34 00:17:33

Replicat STOPPED r_4 00:00:00 19:44:24

Replicat STOPPED r_5 00:00:00 19:44:13

Ggsci (srtcreen) 2> View r_3

***********************************************************************

Oracle Goldengate Delivery for Oracle

Version 11.1.1.1.1 oggcore_11.1.1.1.1_platforms_110729.1700

Linux, x64, 64bit (optimized), Oracle 10g on Sep 13 2011 21:33:03

Copyright (C) 1995, Oracle and/or its affiliates. All rights reserved.

Starting at 2011-12-02 16:36:58

***********************************************************************

Operating System Version:

Linux

Version #1 SMP Fri Apr 2 14:58:14 EDT, release 2.6.18-194.el5

Node:srtcreen

Machine:x86_64

Soft Limit Hard Limit

Address Space Size:unlimited Unlimited

Heap Size:unlimited Unlimited

File Size:unlimited Unlimited

CPU Time:unlimited Unlimited

Process id:13398

Description:

***********************************************************************

* * Running with the following parameters * *

***********************************************************************

Replicat r_3

Assumetargetdefs

Handlecollisions

Setenv (Nls_lang =american_america. ZHS16GBK)

Set environment variable (nls_lang=american_america. ZHS16GBK)

UserID It1ogg, Password ********

--file for dicarded transaction--

Discardfile/opt/ogg/discard/r_3.txt, append, megabytes 100

Ddl

MAP cscnew. Tab_cs_call_pickup, TARGET Srt_creen. Tab_cs_call_pickup, Keycols (call_id);

Cachemgr virtual memory values (may have been adjusted)

cachebuffersize:64k

cachesize:512m

Cachebuffersize (Soft max): 4M

Cachepageoutsize (normal): 4M

PROCESS VM Avail from OS (min): 1G

Cachesizemax (strict force to disk): 881M

Database Version:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bi

Pl/sql Release 10.2.0.4.0-production

CORE 10.2.0.4.0 Production

TNS for Linux:version 10.2.0.4.0-production

Nlsrtl Version 10.2.0.4.0-production

Database Language and Character Set:

Nls_lang = "American_america." ZHS16GBK "

Nls_language = "American"

Nls_territory = "AMERICA"

Nls_characterset = "ZHS16GBK"

For further information in character set settings, please refer to user manual.

***********************************************************************

* * Run Time Messages * *

***********************************************************************

Opened Trail file/opt/ogg/dirdat/u3000000 at 2011-12-02 16:36:58

MAP Resolved (Entry cscnew. Tab_cs_call_pickup):

MAP cscnew. Tab_cs_call_pickup, TARGET Srt_creen. Tab_cs_call_pickup, Keycols (call_id);

More Wonderful content: http://www.bianceng.cn/database/Oracle/

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.