Tuesday 1 July 2014

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

No comments: