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
Comments
Post a Comment