2017-06-03 10:12:31 ERROR
OGG-00664 OCI Error beginning
session (status = 1034-ORA-01034: ORACLE not available
ORA-27101: shared memory realm does
not exist
Linux-x86_64 Error: 2: No such file
or directory
Additional information: 3651
Additional information: -609063181).
2017-06-03 10:12:31 ERROR
OGG-01668 PROCESS ABENDING.
Step 1 : Un Register the Extract from database.
GGSCI (localhost as c##ogg@LOCALCDB1/CDB$ROOT) 8> UNREGISTER EXTRACT EXTPP01 DATABASE
GGSCI (localhost as c##ogg@LOCALCDB1/CDB$ROOT) 9> info
all
Program
Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED
EXTPP01 00:00:00 00:12:38
REPLICAT
RUNNING REPP001 00:00:00 00:00:05
GGSCI (localhost as
c##ogg@LOCALCDB1/CDB$ROOT) 10> view report EXTPP01
***********************************************************************
Oracle GoldenGate Capture for
Oracle
Version 12.1.2.1.10 21604177
OGGCORE_12.1.2.1.0OGGBP_PLATFORMS_150902.1337_FBO
Linux, x64, 64bit (optimized), Oracle 12c on
Sep 2 2015 22:06:14
Copyright (C) 1995, 2015,
Oracle and/or its affiliates. All rights reserved.
Starting at 2017-06-03
10:03:18
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Fri May 6
14:54:05 EDT 2016, Release 2.6.32-642.1.1.el6.x86_64
Node: localhost
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: 5302
Description:
***********************************************************************
** Running with the following
parameters **
***********************************************************************
2017-06-03 10:03:18 INFO
OGG-03059 Operating system
character set identified as UTF-8.
2017-06-03 10:03:18 INFO
OGG-02695 ANSI SQL parameter
syntax is used for parameter parsing.
EXTRACT extpp1
SETENV
(ORACLE_HOME='/u01/app/oracle/product/12.1.0/db_1')
2017-06-03 10:03:18 INFO
OGG-02095 Successfully set environment
variable
ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1.
SETENV (ORACLE_SID=LOCALCDB1)
2017-06-03 10:03:18 INFO
OGG-02095 Successfully set
environment variable ORACLE_SID=LOCALCDB1.
USERID C##OGG, PASSWORD ***
-------------
-------------
-------------
-------------
2017-06-03 10:03:18 ERROR
OGG-00664 OCI Error beginning
session (status = 1034-ORA-01034: ORACLE not available
ORA-27101: shared memory
realm does not exist
Linux-x86_64 Error: 2: No
such file or directory
Additional information: 3651
Additional information:
-609063181).
2017-06-03 10:03:18 ERROR
OGG-01668 PROCESS ABENDING.
Step 2 : Restart Manager
Process
GGSCI (localhost as
c##ogg@LOCALCDB1/CDB$ROOT) 10> stop mgr
Manager process is required
by other GGS processes.
Are you sure you want to
stop it (y/n)?y
Sending STOP request to
MANAGER ...
Request processed.
Manager stopped.
GGSCI (localhost as
c##ogg@LOCALCDB1/CDB$ROOT) 11> start mgr
Manager started.
GGSCI (localhost as
c##ogg@LOCALCDB1/CDB$ROOT) 12> info all
Program Status
Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED
EXTPP01 00:00:00 00:16:57
REPLICAT RUNNING
REPP001 00:00:00 00:00:04
Step 3 : Delete and Add Extract
process.
GGSCI (localhost as
c##ogg@LOCALCDB1/CDB$ROOT) 24> delete extract EXTPP01
Deleted EXTRACT EXTPP01.
GGSCI (localhost as
c##ogg@LOCALCDB1/CDB$ROOT) 26> add extract EXTPP01, INTEGRATED tranlog, SCN
133822379
EXTRACT added.
GGSCI (localhost as
c##ogg@LOCALCDB1/CDB$ROOT) 27> info all
Program Status
Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED
EXTPP01 00:00:00 00:00:02
REPLICAT RUNNING
REPP001 00:00:00 00:00:03
GGSCI (localhost as
c##ogg@LOCALCDB1/CDB$ROOT) 28> add exttrail /ggtrail/et, extract EXTPP01,
megabytes 50
EXTTRAIL added.
Step 4 : Register extract in
Database.
GGSCI (localhost as
c##ogg@LOCALCDB1/CDB$ROOT) 29> REGISTER EXTRACT EXTPP01 DATABASE CONTAINER
(pdblocal)
Extract EXTPP01 successfully
registered with database at SCN 133959101.
GGSCI (localhost as
c##ogg@LOCALCDB1/CDB$ROOT) 30> info all
Program Status
Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED
EXTPP01 00:00:00 00:01:18
REPLICAT RUNNING
REPP001 00:00:00 00:00:00
Step 5 : Start Extract process
GGSCI (localhost as
c##ogg@LOCALCDB1/CDB$ROOT) 31> start EXTPP01
Sending START request to
MANAGER ...
EXTRACT EXTPP01 starting
GGSCI (localhost as
c##ogg@LOCALCDB1/CDB$ROOT) 49> info all
info all
Program Status
Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING
EXTPP01 00:00:00 00:01:48
REPLICAT RUNNING
REPP001 00:00:00 00:00:00
☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺
