News

  1. Home
  2. All posts
All posts, Golden Gate, Oracle by Team Ajara

Errors and Solutions in Oracle GoldenGate Setup

Errors and Solutions in Oracle GoldenGate Setup.

Errors and solution 

 

1.ERROR:

GGSCI (ol6-GG-sys1.localdomain) 3> start extract DPUMP_NR

Sending START request to MANAGER …

ERROR: opening port for MGR MGR (Network is unreachable).

 

Solution:

ifconfig eth1 192.168.56.101 netmask 255.255.255.0 up

 

 

2.ERROR:

[root@ol6-GG-sys1 ogg]# ./ggsci

./ggsci: error while loading shared libraries: libnnz

11.so: cannot open shared object file: No such file or directory

 

Solution:

There might be installation Issue try to Reinstall GoldenGate.

 

3.ERROR:

GGSCI (ol6-GG-sys1.localdomain) 5> add extract ext_IN tranlog begin now

: Could not create checkpoint file /u01/app/oracle/product/ogg1/dirchk/EXT_IN.cpe (error 2, No such file or directory).

 

Solution:

GGSCI> Create subdirs

############

2016-03-16 15:57:39  ERROR   OGG-01044  Oracle GoldenGate Capture for Oracle, pump_in.prm:  The trail ‘/u01/app/oracle/product/ogg2/dirdat/BI_DIR/RI’ is not assigned to extract ‘PUMP_IN’. Assign the trail to the extract with the command “ADD EXTTRAIL/RMTTRAIL /u01/app/oracle/product/ogg2/dirdat/BI_DIR/RI, EXTRACT PUMP_IN”.

2016-03-16 15:57:39  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, pump_in.prm:  PROCESS ABENDING.

######################

 

4.ERROR:

GGSCI (ol6-GG-sys1.localdomain) 9> ADD EXTRACT init_load, SOURCEISTABLE

ERROR: Invalid group name (must be at most 8 characters).

 

Solution:

GGSCI (ol6-GG-sys1.localdomain) 10> ADD EXTRACT initload ,SOURCEISTABLE

EXTRACT added.

 

5.ERROR:

GGSCI (ol6-GG-sys1.localdomain) 15> info INITLOAD

EXTRACT    INITLOAD  Initialized   2016-04-12 14:48   Status STOPPED

Checkpoint Lag       Not Available

Log Read Checkpoint  Not Available

First Record         Record 0

Task                 SOURCEISTABLE

 

Solution:

Create Checkpoint Lag

 

6.ERROR:

GGSCI (GGS-EAST.localdomain) 22> start extract ext_1

Sending START request to MANAGER …

ERROR: opening port for MGR MGR (Connection refused).

————————————————————————————————-

GGSCI (GGS-EAST.localdomain) 4> stop mgr !

Sending STOP request to MANAGER …

ERROR: opening port for MGR MGR (Connection refused).

 

Solution:

Verify ip address ,if eth0/eth1 is not up , then make it up

Example:

Ifconfig eth1 192.168.1.2 netmask 255.255.255.0 up

—————————————————————————————————–

 

7.ERROR:

GGSCI (GGS-EAST.localdomain) 15> add trandata POS_WEST.inventory cols (prod_category,qty_in_stock, last_dml)

2016-03-13 17:27:47  WARNING OGG-00706  Failed to add supplemental log group on table POS_WEST.INVENTORY

due to ORA-01031: insufficient privileges SQL ALTER TABLE “POS_WEST”.”INVENTORY” ADD SUPPLEMENTAL LOG GROUP

“GGS_74619” (“PROD_ID”,”PROD_CATEGORY”,”QTY_IN_STOCK”,”LAST_DML”) ALWAYS  /* GOLDENGATE_DDL_REPLICATION */.

 

Solution:

Add privilege

Grant alter any table to <GG_OWNER>;

 

 

See Also: