Pages

Monday, May 21, 2018

Golden Gate During dblogin error OGG-01117 and error OGG-01668 are coming

=====================
General
=====================
During dblogin error OGG-01117 and error OGG-01668 are coming

=====================
Example
=====================
oracle@my_server:/software/ogg/1212>% ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.1.2.0.0 17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Sep 25 2013 00:31:13
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.
GGSCI (my_server) 1> dblogin userid ogg  password xxx

Source Context :
  SourceModule            : [ggapp.util.pcs]
  SourceID                : [/scratch/aime1/adestore/views/aime1_adc4150472/oggcore/OpenSys/src/gglib/ggapp/pcsutl.c]
  SourceFunction          : [AbendHandler]
  SourceLine              : [938]
  ThreadBacktrace         : [21] elements
                          : [/software/ogg/1212/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f4acb86ddee]]
                          : [/software/ogg/1212/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x31c) [0x7f4acb86ac2c]]
                          : [/software/ogg/1212/libgglog.so(_MSG_ERR_SIGNAL_RECEIVED(CSourceContext*, int, char const*, CMessageFactory::MessageDisposition)+0x3b) [0x7f4acb84cb37]]
                          : [./ggsci() [0x4e4543]]
                          : [/lib64/libpthread.so.0() [0x399900f710]]
                          : [/lib64/libpthread.so.0(pthread_mutex_lock+0) [0x39990093a0]]
                          : [./ggsci(ggs::gglib::MultiThreading::Mutex::Lock()+0x9) [0x516159]]
                          : [./ggsci(CContextItem::operator char const*() const+0x15) [0x4c1a2b]]
                          : [./ggsci(DBOCI_init_connection_logon(ggs::gglib::ggapp::CLoginName const&, ggs::gglib::ggapp::CDBObjName<(DBObjType)12> const&, char const*, int, int, int, char*)+0x1e5) [0x524215]]
                          : [./ggsci() [0x534baf]]
                          : [./ggsci(gl_db_login(char const*, char const*, ggs::gglib::ggapp::CDBObjName<(DBObjType)11>&, ggs::gglib::ggapp::CDBObjName<(DBObjType)12>&, short, char (&) [2048])+0x5f) [0x534edf]]
                          : [./ggsci() [0x4888fb]]
                          : [./ggsci(GGSCIDB_get_command(char const*, char const*, char const*, short, short, char (&) [2048])+0x11b) [0x48628b]]
                          : [./ggsci(do_cmd(char*, unsigned long, char*, unsigned long)+0x908) [0x4bbe58]]
                          : [./ggsci() [0x4c0193]]
                          : [./ggsci(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [0x513c2f]]
                          : [./ggsci(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104) [0x513e34]]
                          : [./ggsci(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x8b) [0x513f2b]]
                          : [./ggsci(main+0x3f) [0x49d33f]]
                          : [/lib64/libc.so.6(__libc_start_main+0xfd) [0x3998c1ed1d]]
                          : [./ggsci() [0x47df19]]

2018-05-21 07:20:22  ERROR   OGG-01117  Received signal: Segmentation violation (11).

2018-05-21 07:20:22  ERROR   OGG-01668  PROCESS ABENDING.
Segmentation fault (core dumped)


=====================
Solution
=====================

Set the Oracle Environment variables.
In this example, it is done via script oraigt

oracle@my_server:~>% env | grep ORA
ORASH=/etc/sh/orash
BAS_ORACLE_LIST=igt


oracle@my_server:~>% oraigt
oracle@my_server:~>% env | grep ORA
ORASH=/etc/sh/orash
BAS_ORACLE_LIST=igt
ORA_VER=1120
ORACLE_SID=igt
ORACLE_BASE=/software/oracle
ORACLE_ENV_DEFINED=yes
ORA_NLS33=/software/oracle/112/ocommon/nls/admin/data
ORACLE_HOME=/software/oracle/112


oracle@my_server:/software/ogg/1212>% ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.1.2.0.0 17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Sep 25 2013 00:31:13
Operating system character set identified as UTF-8.

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

GGSCI (my_server) 1> dblogin userid ogg  password xxx
Successfully logged into database.

No comments:

Post a Comment