Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Oracle 11.2.0.4 ogg 12.3.0.1.0 standby rep process starts error OGG-00446

2025-01-17 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Active and standby operating system: rhel 6.6

Database version: oracle 11.2.0.4

Ogg version: 12.3.0.1.0

Today, a novice is taught to use oracle 11.2.0.4 ogg 12.3.0.1.0 for data synchronization. The deployment process is not standard, and the slave database does not make checkpoint tables for goldengate users. As a result, the reference process of the slave database cannot be started.

The parameters and status of the slave rep_hr process are as follows:

Parameters of rep_hr:

GGSCI (ZB as goldengate@ora) 50 > view param rep_hr

-- eplicat group--

Replicat rep_hr

SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)

-- source and target definitions

ASSUMETARGETDEFS

HANDLECOLLISIONS

-- target database login--

Userid GOLDENGATE, password oracle

-- file for dicarded transaction--

Discardfile / u01/app/oracle/OGG/product/dirdat/rep_hr_discard.txt, append, megabytes 10

-- ddl support DDL--

DDL INCLUDE ALL

DDLERROR DEFAULT IGNORE RETRYOP

-Specify table mapping-

MAP hr.*,TARGET hr.t

Status of rep_hr

GGSCI (ZB as goldengate@ora) 43 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

REPLICAT STOPPED REP_HR 00:00:00 00:11:10

GGSCI (ZB as goldengate@ora) 26 > info rep_hr

REPLICAT REP_HR Initialized 2017-10-29 19:18 Status STOPPED

Checkpoint Lag 00:00:00 (updated 00:09:29 ago)

Log Read Checkpoint File / u01/app/oracle/OGG/product/dirdat/et000000000

First Record RBA 0

GGSCI (ZB as goldengate@ora) 27 >

The error message for rep_hr startup is as follows:

2017-10-29T19:40:39.927+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start rep_hr.

2017-10-29T19:40:39.931+0800 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.21.129]: 27254 (START REPLICAT REP_HR).

2017-10-29T19:40:39.933+0800 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT REP_HR starting.

2017-10-29T19:40:40.275+0800 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: REPLICAT REP_HR starting.

2017-10-29T19:40:40.280+0800 WARNING OGG-02904 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: Replication of PARTIAL XML containing NCHAR/NVARCHAR/NCLOB data may cause divergence.

2017-10-29T19:40:40.280+0800 INFO OGG-03059 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: Operating system character set identified as US-ASCII.

2017-10-29T19:40:40.282+0800 INFO OGG-02695 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: ANSI SQL parameter syntax is used for parameter parsing.

2017-10-29T19:40:40.284+0800 INFO OGG-02095 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.ZHS16GBK.

2017-10-29T19:40:41.443+0800 INFO OGG-06451 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: Triggers will be suppressed by default.

2017-10-29T19:40:41.466+0800 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: Virtual Memory Facilities for: COM

Anon alloc: mmap (MAP_ANON) anon free: munmap

File alloc: mmap (MAP_SHARED) file free: munmap

Target directories:

/ u01/app/oracle/OGG/product/dirtmp.

2017-10-29T19:40:41.490+0800 INFO OGG-06604 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: Database ORA CPU info: CPU Count 4, CPU Core Count 4, CPU Socket Count 2

2017-10-29T19:40:41.511+0800 ERROR OGG-00446 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: Checkpoint table GOLDENGATE.checkpoint does not exist. Create this table with the ADD CHECKPOINTTABLE command.

2017-10-29T19:40:41.511+0800 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: PROCESS ABENDING.

2017-10-29T19:41:23.633+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): ADD CHECKPOINTTABLE.

2017-10-29T19:48:16.623+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): ADD CHECKPOINTTABLE goldengate.checkpoint.

2017-10-29T19:48:33.225+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start rep_hr.

2017-10-29T19:48:33.239+0800 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.21.129]: 27445 (START REPLICAT REP_HR).

The error message of the solution occurred in the initialization of ERROR OGG-00446 has been mentioned, and the processing process is as follows:

GGSCI (ZB as goldengate@ora) 45 > start rep_hr

Sending START request to MANAGER...

REPLICAT REP_HR starting

GGSCI (ZB as goldengate@ora) 46 > ADD CHECKPOINTTABLE

ERROR: Missing checkpoint table specification.

GGSCI (ZB as goldengate@ora) 47 > ADD CHECKPOINTTABLE goldengate.checkpoint

Successfully created checkpoint table goldengate.checkpoint.

GGSCI (ZB as goldengate@ora) 48 > start rep_hr

Sending START request to MANAGER...

REPLICAT REP_HR starting

GGSCI (ZB as goldengate@ora) 49 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNING REP_HR 00:00:00 00:00:00

GGSCI (ZB as goldengate@ora) 50 >

GGSCI (ZB as goldengate@ora) 45 > start rep_hr

Sending START request to MANAGER...

REPLICAT REP_HR starting

GGSCI (ZB as goldengate@ora) 46 > ADD CHECKPOINTTABLE

ERROR: Missing checkpoint table specification.

GGSCI (ZB as goldengate@ora) 47 > ADD CHECKPOINTTABLE goldengate.checkpoint

Successfully created checkpoint table goldengate.checkpoint.

GGSCI (ZB as goldengate@ora) 48 > start rep_hr

Sending START request to MANAGER...

REPLICAT REP_HR starting

GGSCI (ZB as goldengate@ora) 49 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNING REP_HR 00:00:00 00:00:00

GGSCI (ZB as goldengate@ora) 50 >

GGSCI (ZB as goldengate@ora) 51 > info rep_hr

REPLICAT REP_HR Last Started 2017-10-29 19:48 Status RUNNING

Checkpoint Lag 00:00:00 (updated 00:00:02 ago)

Process ID 12507

Log Read Checkpoint File / u01/app/oracle/OGG/product/dirdat/et000000000

First Record RBA 1409

GGSCI (ZB as goldengate@ora) 52 >

GGSCI (ZB as goldengate@ora) 45 > start rep_hr

Sending START request to MANAGER...

REPLICAT REP_HR starting

GGSCI (ZB as goldengate@ora) 46 > ADD CHECKPOINTTABLE

ERROR: Missing checkpoint table specification.

GGSCI (ZB as goldengate@ora) 47 > ADD CHECKPOINTTABLE goldengate.checkpoint

Successfully created checkpoint table goldengate.checkpoint.

GGSCI (ZB as goldengate@ora) 48 > start rep_hr

Sending START request to MANAGER...

REPLICAT REP_HR starting

GGSCI (ZB as goldengate@ora) 49 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNING REP_HR 00:00:00 00:00:00

GGSCI (ZB as goldengate@ora) 50 >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report