OGG-00664 OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available

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

☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺