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 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