安装ogg过程中成功，ogg安装成功，12c多租户数据库做的测试，pdb1用户nw，nw表，数据同步到pdb1用户nw，nw1，表做测试在nw表插入一条数据，查询备表没有数据

我来答

2019-08-17

这是数据库alert.log

ORA-04031: unable to allocate 3280 bytes of shared memory ("streams pool","unknown object","streams pool","sob_kgqmrec")

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

2019-08-17T02:16:03.730883+08:00

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

2019-08-17T02:16:17.583087+08:00

Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_q005_5801.trc:

ORA-04031: unable to allocate 3280 bytes of shared memory ("streams pool","unknown object","streams pool","sob_kgqmrec")

2019-08-17T02:16:18.075247+08:00

Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_q00a_5803.trc (incident=41296) (PDBNAME=CDB$ROOT):

ORA-04031: unable to allocate 3280 bytes of shared memory ("streams pool","unknown object","streams pool","sob_kgqmrec")

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

2019-08-17T02:16:18.150684+08:00

Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_q00a_5803.trc:

ORA-04031: unable to allocate 3280 bytes of shared memory ("streams pool","unknown object","streams pool","sob_kgqmrec")

2019-08-17T02:16:18.516909+08:00

DDE: Problem Key 'ORA 4031' was completely flood controlled (0x6)

Further messages for this problem key will be suppressed for up to 10 minutes

2019-08-17T02:16:18.598961+08:00

Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_q00b_5805.trc:

ORA-04031: unable to allocate 3280 bytes of shared memory ("streams pool","unknown object","streams pool","sob_kgqmrec")

2019-08-17T02:16:19.094090+08:00

Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_q006_5807.trc:

ORA-04031: unable to allocate 3280 bytes of shared memory ("streams pool","unknown object","streams pool","sob_kgqmrec")

2019-08-17T02:16:22.731295+08:00

OGG Capture client successfully detached from GoldenGate Capture OGG$CAP_EORA (OS pid=5639).

[oracle@node ~]$ tail -100f /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_q00b_5805.trc

Trace file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_q00b_5805.trc

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Build label: RDBMS_12.2.0.1.0_LINUX.X64_170125

ORACLE_HOME: /u01/app/oracle/product/11.2.0/db_1

System name: Linux

Node name: node

Release: 2.6.32-431.el6.x86_64

Version: #1 SMP Fri Nov 22 03:15:09 UTC 2013

Machine: x86_64

Instance name: orcl

Redo thread mounted by this instance: 1

Oracle process number: 63

Unix process pid: 5805, image: oracle@node (Q00B)

*** 2019-08-17T02:16:18.453632+08:00 (CDB$ROOT(1))

*** SESSION ID:(87.35691) 2019-08-17T02:16:18.453725+08:00

*** CLIENT ID:() 2019-08-17T02:16:18.453745+08:00

*** SERVICE NAME:(SYS$BACKGROUND) 2019-08-17T02:16:18.453764+08:00

*** MODULE NAME:(Streams) 2019-08-17T02:16:18.453783+08:00

*** ACTION NAME:(QMON Slave) 2019-08-17T02:16:18.453801+08:00

*** CLIENT DRIVER:() 2019-08-17T02:16:18.453819+08:00

*** CONTAINER ID:(1) 2019-08-17T02:16:18.453872+08:00

AUTO MEM: PGA get fail 81 for 65, 65, 4, 4194304, 507510784, 272629760, 65, 780140544, 5

KSV 4031 error in slave process

*** 2019-08-17T02:16:18.596776+08:00 (CDB$ROOT(1))

ORA-04031: unable to allocate 3280 bytes of shared memory ("streams pool","unknown object","streams pool","sob_kgqmrec")

OPIRIP: Uncaught error 447. Error stack:

*** 2019-08-17T02:16:18.603668+08:00

ORA-00447: fatal error in background process

*** 2019-08-17T02:16:18.603708+08:00

ORA-04031: unable to allocate 3280 bytes of shared memory ("streams pool","unknown object","streams pool","sob_kgqmrec")

测试数据

SQL> insert into lz.lz values(2);

1 row created.

SQL> commit

2 ;

Commit complete.

SQL> select * from lz.lz;

----------

SQL> select * from lz.lz1;

no rows selected

SQL>

我来答

添加附件

问题补充

4条回答

默认

最新

章芋文

看下OGG进程的状态以及日志。

有用 0

NIU

oggerr.log

[root@node ogg]# more ggserr.log

2019-08-17T01:32:02.079+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle, oby.oby: GGSCI command (oracle): CREATE SUBDIRS.

2019-08-17T01:32:03.228+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle, oby.oby: GGSCI command (oracle): START MGR.

2019-08-17T01:32:03.797+0800 WARNING OGG-01877 Oracle GoldenGate Manager for Oracle, mgr.prm: Missing explicit accessrule for server collector.

2019-08-17T01:32:03.916+0800 INFO OGG-00983 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started (port 7809).

2019-08-17T01:32:04.232+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle, oby.oby: GGSCI command (oracle): CREATE DATASTORE.

2019-08-17T01:53:03.356+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params ./globals.

2019-08-17T01:53:34.369+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit param mgr.

2019-08-17T01:54:31.354+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit param eora.

2019-08-17T01:55:35.392+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin USERID c##ggadmin password ***.

2019-08-17T01:59:18.670+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin userid c##ggadmin password ***.

2019-08-17T01:59:48.279+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin userid c##ggadmin password ***.

2019-08-17T02:00:46.817+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): register extract eora database container(pd

b1).

2019-08-17T02:00:47.289+0800 ERROR OGG-02060 Oracle GoldenGate Command Interpreter for Oracle: The Oracle mining database is not configured properly to support in

tegrated capture. The following configuration error must be fixed: Operation not supported because enable_goldengate_replication is not set to true.

2019-08-17T02:01:26.454+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): register extract eora database container(pd

b1).

2019-08-17T02:02:29.666+0800 INFO OGG-02003 Oracle GoldenGate Command Interpreter for Oracle: Extract EORA successfully registered with database at SCN 1844878.

2019-08-17T02:02:46.929+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin userid lz@abc password ***.

2019-08-17T02:03:26.448+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin userid lz@pdb1 password ***.

2019-08-17T02:03:51.947+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add trandata lz.lz.

2019-08-17T02:03:54.660+0800 INFO OGG-15132 Oracle GoldenGate Command Interpreter for Oracle: Logging of supplemental redo data enabled for table PDB1.LZ.LZ.

2019-08-17T02:03:54.672+0800 INFO OGG-15133 Oracle GoldenGate Command Interpreter for Oracle: TRANDATA for scheduling columns has been added on table PDB1.LZ.LZ.

2019-08-17T02:03:54.889+0800 INFO OGG-15135 Oracle GoldenGate Command Interpreter for Oracle: TRANDATA for instantiation CSN has been added on table PDB1.LZ.LZ.

2019-08-17T02:03:56.677+0800 INFO OGG-10471 Oracle GoldenGate Command Interpreter for Oracle: ***** Oracle Goldengate support information on table LZ.LZ *****

Oracle Goldengate support native capture on table LZ.LZ.

Oracle Goldengate marked following column as key columns on table LZ.LZ: ID.

2019-08-17T02:04:10.977+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): Add extract eora integrated tranlog,begin n

ow.

2019-08-17T02:04:20.423+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): ADD EXTTRAIL ./dirdat/ex EXTRACT EORA.

2019-08-17T02:04:45.529+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit param pump.

2019-08-17T02:05:53.766+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): ADD EXTRACT pump ExtTrailSource ./dirdat/

ex.

2019-08-17T02:06:01.665+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): ADD RMTTRAIL ./dirdat/pm EXTRACT pump,

megabytes 100.

2019-08-17T02:06:28.684+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params REPL.

2019-08-17T02:07:47.572+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): Add CheckPointTable lz.test1.

2019-08-17T02:08:01.574+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add Replicat repl ExtTrail./dirdat/pm,Check

PointTable lz.test1.

2019-08-17T02:12:27.161+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add Replicat repl ExtTrail ./dirdat/pm,Chec

kPointTable lz.test1.

2019-08-17T02:12:37.948+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.

2019-08-17T02:13:00.236+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start mgr.

2019-08-17T02:13:08.664+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start eora.

2019-08-17T02:13:08.713+0800 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.247.150]:47567 (START EXT

RACT EORA ).

2019-08-17T02:13:08.722+0800 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EORA starting.

2019-08-17T02:13:10.464+0800 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, eora.prm: EXTRACT EORA starting.

2019-08-17T02:13:10.531+0800 INFO OGG-03059 Oracle GoldenGate Capture for Oracle, eora.prm: Operating system character set identified as US-ASCII.

2019-08-17T02:13:10.531+0800 INFO OGG-02695 Oracle GoldenGate Capture for Oracle, eora.prm: ANSI SQL parameter syntax is used for parameter parsing.

2019-08-17T02:13:10.543+0800 INFO OGG-02095 Oracle GoldenGate Capture for Oracle, eora.prm: Successfully set environment variable ORACLE_SID=orcl.

2019-08-17T02:13:10.543+0800 INFO OGG-02095 Oracle GoldenGate Capture for Oracle, eora.prm: Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.AL32U

TF8.

2019-08-17T02:13:11.032+0800 INFO OGG-01360 Oracle GoldenGate Capture for Oracle, eora.prm: EXTRACT is running in Integrated mode.

2019-08-17T02:13:14.429+0800 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, eora.prm: Setting session time zone to source database time zone 'GMT'.

2019-08-17T02:13:14.444+0800 WARNING OGG-04033 Oracle GoldenGate Capture for Oracle, eora.prm: LOGALLSUPCOLS has set the NOCOMPRESSDELETES and GETUPDATEBEFORES par

ameters on.

2019-08-17T02:13:14.481+0800 INFO OGG-02623 Oracle GoldenGate Capture for Oracle, eora.prm: Default source catalog name pdb1 will be used for source table name l

z.lz mapping.

2019-08-17T02:13:14.483+0800 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, eora.prm: BOUNDED RECOVERY: reset to initial or altered checkpoint.

2019-08-17T02:13:14.564+0800 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, eora.prm: Virtual Memory Facilities for: BR

anon alloc: mmap(MAP_ANON) anon free: munmap

file alloc: mmap(MAP_SHARED) file free: munmap

target directories:

/home/oracle/ogg/BR/EORA.

2019-08-17T02:13:14.564+0800 INFO OGG-01851 Oracle GoldenGate Capture for Oracle, eora.prm: filecaching started: thread ID: 139847105791744.

2019-08-17T02:13:14.564+0800 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, eora.prm: Virtual Memory Facilities for: COM

anon alloc: mmap(MAP_ANON) anon free: munmap

file alloc: mmap(MAP_SHARED) file free: munmap

target directories:

/home/oracle/ogg/dirtmp.

2019-08-17T02:13:14.744+0800 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, eora.prm: Setting session time zone to source database time zone 'GMT'.

2019-08-17T02:13:16.899+0800 INFO OGG-02255 Oracle GoldenGate Capture for Oracle, eora.prm: The MININGDBLOGIN is connected to the source database ORCL.

2019-08-17T02:13:16.980+0800 INFO OGG-06604 Oracle GoldenGate Capture for Oracle, eora.prm: Database ORCL CPU info: CPU Count 1, CPU Core Count 0, CPU Socket Cou

nt 0.

2019-08-17T02:13:18.505+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start pump.

2019-08-17T02:13:18.506+0800 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.247.150]:47568 (START EXT

RACT PUMP ).

2019-08-17T02:13:18.508+0800 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT PUMP starting.

2019-08-17T02:13:18.718+0800 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, pump.prm: EXTRACT PUMP starting.

2019-08-17T02:13:18.719+0800 INFO OGG-03059 Oracle GoldenGate Capture for Oracle, pump.prm: Operating system character set identified as US-ASCII.

2019-08-17T02:13:18.719+0800 INFO OGG-02695 Oracle GoldenGate Capture for Oracle, pump.prm: ANSI SQL parameter syntax is used for parameter parsing.

2019-08-17T02:13:18.721+0800 INFO OGG-02095 Oracle GoldenGate Capture for Oracle, pump.prm: Successfully set environment variable ORACLE_SID=orcl.

2019-08-17T02:13:18.804+0800 INFO OGG-01360 Oracle GoldenGate Capture for Oracle, pump.prm: EXTRACT is running in Data Pump mode.

2019-08-17T02:13:18.903+0800 INFO OGG-01889 Oracle GoldenGate Capture for Oracle, pump.prm: Flush size (max message size) is set to 27,985.

2019-08-17T02:13:19.296+0800 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, pump.prm: Setting session time zone to source database time zone 'GMT'.

2019-08-17T02:13:19.296+0800 INFO OGG-02623 Oracle GoldenGate Capture for Oracle, pump.prm: Default source catalog name pdb1 will be used for source table name l

z.lz mapping.

2019-08-17T02:13:19.296+0800 INFO OGG-01851 Oracle GoldenGate Capture for Oracle, pump.prm: filecaching started: thread ID: 139784397776640.

2019-08-17T02:13:19.366+0800 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, pump.prm: Virtual Memory Facilities for: COM

anon alloc: mmap(MAP_ANON) anon free: munmap

file alloc: mmap(MAP_SHARED) file free: munmap

target directories:

/home/oracle/ogg/dirtmp.

2019-08-17T02:13:19.385+0800 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, pump.prm: EXTRACT PUMP started.

2019-08-17T02:13:19.391+0800 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host [192.168.247.150]:47569 (VERSION

2019-08-17T02:13:19.413+0800 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #1).

2019-08-17T02:13:19.425+0800 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host [192.168.247.150]:47570 (START S

ERVER CPU -1 PRI -1 TIMEOUT 300 PARAMS ).

2019-08-17T02:13:19.752+0800 INFO OGG-01888 Oracle GoldenGate Collector for Oracle: TCP network is configured as

OS DEFAULT SPECIFIED ACTUAL VALUE

IP_DSCP 0 N/A 0

IP_TOS 0 N/A 0

TCP_NODELAY 0 N/A 0

TCP_QUICKACK 1 N/A 1

TCP_CORK 0 N/A 0

SO_SNDBUF 8192 N/A 8192

SO_RCVBUF 43690 N/A 43690.

2019-08-17T02:13:19.775+0800 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from SERVER on host [::1]:13479 (REPORT 5633 7819).

2019-08-17T02:13:19.775+0800 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #1).

2019-08-17T02:13:19.864+0800 INFO OGG-00974 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started collector process (Port 7819).

2019-08-17T02:13:19.871+0800 INFO OGG-01228 Oracle GoldenGate Collector for Oracle: Timeout in 300 seconds.

2019-08-17T02:13:23.798+0800 WARNING OGG-02045 Oracle GoldenGate Capture for Oracle, eora.prm: Database does not have streams_pool_size initialization parameter con

figured.

2019-08-17T02:13:24.472+0800 INFO OGG-02248 Oracle GoldenGate Capture for Oracle, eora.prm: Logmining server DDL filtering enabled.

2019-08-17T02:13:24.865+0800 INFO OGG-01888 Oracle GoldenGate Capture for Oracle, pump.prm: TCP network is configured as

OS DEFAULT SPECIFIED ACTUAL VALUE

IP_DSCP 0 N/A 0

IP_TOS 0 N/A 0

TCP_NODELAY 0 N/A 0

TCP_QUICKACK 1 N/A 1

TCP_CORK 0 N/A 0

SO_SNDBUF 8192 N/A 8192

SO_RCVBUF 43690 N/A 43690.

2019-08-17T02:13:24.866+0800 INFO OGG-01229 Oracle GoldenGate Collector for Oracle: Connected to node:24070.

2019-08-17T02:13:24.895+0800 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, pump.prm: No recovery is required for target file ./dirdat/pm000000000, at RBA

0 (file not opened).

2019-08-17T02:13:24.895+0800 INFO OGG-01669 Oracle GoldenGate Collector for Oracle: Opening /home/oracle/ogg/./dirdat/pm000000000 (byte -1, current EOF 0).

2019-08-17T02:13:26.450+0800 INFO OGG-02068 Oracle GoldenGate Capture for Oracle, eora.prm: Integrated capture successfully attached to logmining server OGG$CAP_

EORA using OGGCapture API.

2019-08-17T02:13:26.451+0800 INFO OGG-02089 Oracle GoldenGate Capture for Oracle, eora.prm: Source redo compatibility version is: 12.2.0.

2019-08-17T02:13:26.474+0800 INFO OGG-02086 Oracle GoldenGate Capture for Oracle, eora.prm: Integrated Dictionary will be used.

2019-08-17T02:13:29.236+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start repl.

2019-08-17T02:13:29.237+0800 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.247.150]:47573 (START REP

LICAT REPL ).

2019-08-17T02:13:29.238+0800 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT REPL starting.

2019-08-17T02:13:29.849+0800 WARNING OGG-02905 Oracle GoldenGate Capture for Oracle, eora.prm: Replication of OID column in object tables may diverge.

2019-08-17T02:13:29.850+0800 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, eora.prm: EXTRACT EORA started.

2019-08-17T02:13:29.850+0800 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, eora.prm: No recovery is required for target file ./dirdat/ex000000000, at RBA

0 (file not opened).

2019-08-17T02:13:29.850+0800 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, eora.prm: Output file ./dirdat/ex is using format RELEASE 12.3.

2019-08-17T02:13:30.047+0800 INFO OGG-02243 Oracle GoldenGate Capture for Oracle, pump.prm: Opened trail file /home/oracle/ogg/dirdat/ex000000000 at 2019-08-17 0

2:13:30.047505.

2019-08-17T02:13:30.047+0800 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, pump.prm: Output file ./dirdat/pm is using format RELEASE 12.3.

2019-08-17T02:14:22.313+0800 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, repl.prm: REPLICAT REPL starting.

2019-08-17T02:14:22.780+0800 INFO OGG-03059 Oracle GoldenGate Delivery for Oracle, repl.prm: Operating system character set identified as US-ASCII.

2019-08-17T02:14:22.855+0800 INFO OGG-02695 Oracle GoldenGate Delivery for Oracle, repl.prm: ANSI SQL parameter syntax is used for parameter parsing.

2019-08-17T02:14:38.337+0800 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, eora.prm: Setting session time zone to source database time zone 'GMT'.

2019-08-17T02:15:29.059+0800 INFO OGG-02679 Oracle GoldenGate Delivery for Oracle, repl.prm: The Replicat process logged on to database PDB1 and can only apply t

o that database.

2019-08-17T02:15:32.919+0800 INFO OGG-02623 Oracle GoldenGate Delivery for Oracle, repl.prm: Default source catalog name pdb1 will be used for source table name

LZ.LZ mapping.

2019-08-17T02:15:33.256+0800 INFO OGG-02669 Oracle GoldenGate Delivery for Oracle, repl.prm: Default catalog name PDB1 will be used for target table name LZ.LZ1

mapping.

2019-08-17T02:15:34.119+0800 INFO OGG-06451 Oracle GoldenGate Delivery for Oracle, repl.prm: Triggers will be suppressed by default.

2019-08-17T02:15:35.107+0800 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, repl.prm: Virtual Memory Facilities for: COM

anon alloc: mmap(MAP_ANON) anon free: munmap

file alloc: mmap(MAP_SHARED) file free: munmap

target directories:

/home/oracle/ogg/dirtmp.

2019-08-17T02:15:36.330+0800 INFO OGG-06604 Oracle GoldenGate Delivery for Oracle, repl.prm: Database PDB1 CPU info: CPU Count 1, CPU Core Count 0, CPU Socket Co

unt 0.

2019-08-17T02:15:50.491+0800 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, repl.prm: REPLICAT REPL started.

2019-08-17T02:16:03.590+0800 INFO OGG-02243 Oracle GoldenGate Delivery for Oracle, repl.prm: Opened trail file /home/oracle/ogg/dirdat/pm000000000 at 2019-08-17

02:16:03.317906.

2019-08-17T02:16:12.146+0800 ERROR OGG-00662 Oracle GoldenGate Capture for Oracle, eora.prm: OCI Error ORA-04031: unable to allocate bytes of shared memory ("","

","","")

(status = 4031).

2019-08-17T02:16:12.516+0800 ERROR OGG-02078 Oracle GoldenGate Capture for Oracle, eora.prm: Extract encountered a fatal error in a processing thread and is abend

ing.

2019-08-17T02:16:12.642+0800 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, eora.prm: PROCESS ABENDING.

2019-08-17T02:54:02.730+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.

2019-08-17T08:39:25.280+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): send mgr childstatus debug.

2019-08-17T08:39:25.866+0800 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.247.150]:49116 (CHILDSTAT

US, DEBUG).

ogg进程

GGSCI (node) 1>

GGSCI (node) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT ABENDED EORA 00:11:53 24:19:13

EXTRACT RUNNING PUMP 00:00:00 00:00:10

REPLICAT RUNNING REPL 00:00:00 00:00:07

GGSCI (node) 2>

有用 0

章芋文

如下，日志已经说得很清楚了：

2019-08-17T02:13:23.798+0800  WARNING OGG-02045  Oracle GoldenGate Capture for Oracle, eora.prm:  Database does not have streams_pool_size initialization parameter con
2019-08-17T02:16:12.146+0800  ERROR   OGG-00662  Oracle GoldenGate Capture for Oracle, eora.prm:  OCI Error ORA-04031: unable to allocate  bytes of shared memory ("","
","","")

有用 0

NIU

2019-08-18T10:44:57.175+0800 ERROR OGG-00664 Oracle GoldenGate Delivery for Oracle, repl2.prm: OCI Error beginning session (status = 1017-ORA-01017: invalid username/password; logon denied).

2019-08-18T10:44:57.200+0800 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, repl2.prm: PROCESS ABENDING.

2019-08-18T10:45:42.662+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.

这是源端是12c数据库，目标端是11g repl2进程手动启后又停止，不知道问题在哪

源端进程：

GGSCI (node as lz@orcl/PDB1) 87> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING EORA 00:00:00 00:00:01

EXTRACT ABENDED EORA2 00:00:00 03:41:37

EXTRACT RUNNING PUMP 00:00:00 00:00:08

EXTRACT ABENDED PUMP2 00:00:00 02:28:55

REPLICAT RUNNING REPL 00:00:00 00:00:05

REPLICAT STOPPED REPL2 00:00:00 03:33:45

目标端进程：

GGSCI (oemtest as lz@orcl) 34> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNING REPL2 00:00:00 00:00:06

11g ggserr.log

2019-08-13T09:38:48.726+0800 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, repl2.prm: REPLICAT REPL2 started.

2019-08-13T09:38:49.004+0800 INFO OGG-02243 Oracle GoldenGate Delivery for Oracle, repl2.prm: Opened trail file /home/oracle/ogg1/dirdat/pu000000000 at 2019-08-13 09:38:49.004024.

2019-08-13T09:38:54.411+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.

2019-08-13T09:41:58.798+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.

2019-08-13T09:44:32.827+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all;.

2019-08-13T09:44:35.935+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.

2019-08-13T09:51:22.539+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all repl2.

2019-08-13T09:51:31.604+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info repl2.

2019-08-13T10:58:55.074+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.

有用 0

回答交流

提交

问题信息

请登录之后查看

邀请回答

暂无人订阅该标签，敬请期待~~

墨值悬赏