Problem Statement
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).
ERROR OGG-01668 PROCESS ABENDING.
Problem Detail Report
GGSCI (stby.localdomain as ggowner@GGTGT) 6> view report GGREPL01***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 01:27:04
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
Starting at 2017-08-14 02:27:21
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Sat Jun 23 02:39:07 EDT 2012, Release 2.6.39-200.24.1.el6uek.x86_64
Node: stby.localdomain
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: 9311
Description:
2017-08-14 02:27:21 WARNING OGG-02904 Replication of PARTIAL XML containing NCHAR/NVARCHAR/NCLOB data may cause divergence.
***********************************************************************
** Running with the following parameters **
***********************************************************************
2017-08-14 02:27:21 INFO OGG-03059 Operating system character set identified as US-ASCII.
2017-08-14 02:27:21 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
REPLICAT GGREPL01
USERID ggowner, PASSWORD ***
Source Context :
SourceModule : [ggdb.ora.sess]
SourceID : [/scratch/aime/adestore/views/aime_adc4150408/oggcore/OpenSys/src/gglib/ggdbora/ocisess.c]
SourceFunction : [oci_try]
SourceLine : [871]
ThreadBacktrace : [18] elements
: [/u01/app/oracle/product/11.2.0/goldengate/libgglog.so(CMessageContext::AddThreadContext()+0x1b)
[0x7fc03d57df1b]]
: [/u01/app/oracle/product/11.2.0/goldengate/libgglog.so(CMessageFactory::CreateMessage(CSourceCont
ext*, unsigned int, ...)+0x134) [0x7fc03d5780a4]]
: [/u01/app/oracle/product/11.2.0/goldengate/libgglog.so(_MSG_ERR_ORACLE_OCI_ERROR_WITH_DESC(CSourc
eContext*, int, char const*, char const*, CMessageFactory::MessageDisposition)+0x41) [0x7fc03d563007]]
: [/u01/app/oracle/product/11.2.0/goldengate/replicat(OCISESS_context_def::oci_try(int, char const*
, ...)+0x47e) [0x7290de]]
: [/u01/app/oracle/product/11.2.0/goldengate/replicat(OCISESS_context_def::logon(ggs::gglib::ggapp:
:CLoginName const&, ggs::gglib::ggapp::CDBObjName<(DBObjType)12> const&, ggs::gglib::ggunicode::UString const&, int, bool, in
t)+0x732) [0x726602]]
: [/u01/app/oracle/product/11.2.0/goldengate/replicat(ggs::gglib::ggdbora::OraConnUtil::initConnect
ionLogon(ggs::gglib::ggdbapi::DBAuthParams const&)+0x1c8) [0x753958]]
: [/u01/app/oracle/product/11.2.0/goldengate/replicat(ggs::gglib::ggdbora::OraConnUtil::openDataSou
rce(ggs::gglib::ggdbapi::DBAuthParams const&)+0x28) [0x753d08]]
: [/u01/app/oracle/product/11.2.0/goldengate/replicat(ggs::gglib::ggdbora::OraRepConnUtil::openData
Source(ggs::gglib::ggdbapi::DBAuthParams const&)+0x9) [0x755309]]
: [/u01/app/oracle/product/11.2.0/goldengate/replicat() [0x6f2732]]
: [/u01/app/oracle/product/11.2.0/goldengate/replicat(odbc_param(char*, char*)+0x263) [0x6f2a73]]
: [/u01/app/oracle/product/11.2.0/goldengate/replicat(get_infile_params(time_elt_def*, time_elt_def
*, char**, ggs::gglib::ggdatasource::DataSourceParams&, ggs::Heartbeat::MapGeneratorParams&)+0x1870) [0x5a7fc0]]
: [/u01/app/oracle/product/11.2.0/goldengate/replicat() [0x621150]]
: [/u01/app/oracle/product/11.2.0/goldengate/replicat(ggs::gglib::MultiThreading::MainThread::ExecM
ain()+0x60) [0x6d9d50]]
: [/u01/app/oracle/product/11.2.0/goldengate/replicat(ggs::gglib::MultiThreading::Thread::RunThread
(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x6dacdd]]
: [/u01/app/oracle/product/11.2.0/goldengate/replicat(ggs::gglib::MultiThreading::MainThread::Run(i
nt, char**)+0xb1) [0x6dadc1]]
: [/u01/app/oracle/product/11.2.0/goldengate/replicat(main+0x3b) [0x624a6b]]
: [/lib64/libc.so.6(__libc_start_main+0xfd) [0x3aeea1ecdd]]
: [/u01/app/oracle/product/11.2.0/goldengate/replicat() [0x55b0a9]]
2017-08-14 02:27:21 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).
2017-08-14 02:27:21 ERROR OGG-01668 PROCESS ABENDING.
Solution :
This issue occurs were more than once oracle instances are running on to the database
Solution 1:- Provide the tnsname of instance which you want to connect
USERID ggowner@GGTGT, PASSWORD ggowner
Solution2:- Add setevn parameters to set Oracle SID and Oracle Home
SETENV (ORACLE_SID=GGTGT)
SETENV (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_home)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
REPLICAT GGREPL01USERID ggowner@GGTGT, PASSWORD ggowner
DISCARDFILE /u01/app/oracle/product/11.2.0/goldengate/dirrpt/ggext01.dsc
ASSUMETARGETDEFS
MAP GGOWNER.EMPLOYEE, TARGET GGOWNER.EMPLOYEE;
REPLICAT GGREPL01
SETENV (ORACLE_SID=GGTGT)
SETENV (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_home)
USERID ggowner, PASSWORD ggowner
DISCARDFILE /u01/app/oracle/product/11.2.0/goldengate/dirrpt/ggext01.dsc
ASSUMETARGETDEFS
MAP GGOWNER.EMPLOYEE, TARGET GGOWNER.EMPLOYEE;
No comments:
Post a Comment