OGG-00664 OCI Error beginning session

GGSCI (pkdb4) 1> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     EXTTR       09:56:11      00:00:18

EXTRACT     STOPPED     EXTTRP      00:00:00      20:36:52

GGSCI (pkdb4) 2> start exttrp

Sending START request to MANAGER ...

EXTRACT EXTTRP starting

GGSCI (pkdb4) 3> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     EXTTR       09:56:11      00:00:23

EXTRACT     STOPPED     EXTTRP      00:00:00      20:36:57

GGSCI (pkdb4) 4> view report exttrp

***********************************************************************

                 Oracle GoldenGate Capture for Oracle

                     Version 11.1.1.0.0 Build 078

   HP/UX, IA64, 64bit (optimized), Oracle 10 on Jul 28 2010 15:49:30

Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.

                    Starting at 2014-07-01 07:29:55

***********************************************************************

Operating System Version:

HP-UX

Version U, Release B.11.31

Node: pkdb4

Machine: ia64

                         soft limit   hard limit

Address Space Size   :    unlimited    unlimited

Heap Size            :   4294967296   4294967296

File Size            :    unlimited    unlimited

CPU Time             :    unlimited    unlimited

Process id: 1468

Description:

***********************************************************************

**            Running with the following parameters                  **

***********************************************************************

EXTRACT exttrp

USERID ggs_dr_owner, PASSWORD ************

Source Context :

  SourceModule            : [ggdb.ora.sess]

  SourceID                : [/home/ecloud/workspace/Build_OpenSys_r11.1.1.0.0_078_[34100]/perforce/src/gglib/ggdbora/ocisess.c]

  SourceFunction          : [OCISESS_try]

  SourceLine              : [498]

2014-07-01 07:29:55  ERROR   OGG-00664  OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

HPUX-ia64 Error: 2: No such file or directory).

2014-07-01 07:29:55  ERROR   OGG-01668  PROCESS ABENDING.

Reason :

If we have multiple instances running on same host, We need to mention to which instance extract has to connect.

FIX : 

Option 1: Use SETENV ORACLE_SID and ORACLE_HOME values on param file

SETENV (ORACLE_SID=TXNTR1)

SETENV (ORACLE_HOME=/u01/app/oracle/product/10.2.0/db)

USERID ggs_owner, PASSWORD ggs_owner

Option 2: Use TNS entry (if multiple DB instances are running on same node)

USERID ggs_owner@tns_entry, PASSWORD ggs_owner

----------------------------------------------------------

GGSCI (pkdb4) 5> start exttrp

Sending START request to MANAGER ...

EXTRACT EXTTRP starting

GGSCI (pkdb4) 6> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     EXTTR       09:56:11      00:00:23

EXTRACT     RUNNING     EXTTRP      20:36:22      00:00:14