Oracle+ogg-00664,OGG-00664 MGR进程无法启动

测试环境MGR进程无法启动 ，检查发现是ogguser用户密码过期，重置密码即可：

[code]GGSCI (localhost.localdomain) 4> start mgr

Manager started.

GGSCI (localhost.localdomain) 5> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER STOPPED

JAGENT STOPPED

EXTRACT ABENDED AWEN_EXT 00:00:00 1080:41:25

EXTRACT ABENDED AWEN_PMP 00:00:00 1080:41:27

REPLICAT ABENDED AWEN_REP 00:00:00 1080:41:25

GGSCI (localhost.localdomain) 6> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER STOPPED

JAGENT STOPPED

EXTRACT ABENDED AWEN_EXT 00:00:00 1080:41:31

EXTRACT ABENDED AWEN_PMP 00:00:00 1080:41:34

REPLICAT ABENDED AWEN_REP 00:00:00 1080:41:31

GGSCI (localhost.localdomain) 7> view report mgr

***********************************************************************

Oracle GoldenGate Manager for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230

Linux, x86, 32bit (optimized), Oracle 11g on Apr 23 2012 04:23:29

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

Starting at 2013-12-24 11:26:09

***********************************************************************

Operating System Version:

Linux

Version #1 SMP Tue Aug 18 15:51:54 EDT 2009, Release 2.6.18-164.el5

Node: localhost.localdomain

Machine: i686

soft limit hard limit

Address Space Size : unlimited unlimited

Heap Size : unlimited unlimited

File Size : unlimited unlimited

CPU Time : unlimited unlimited

Process id: 2794

Parameters...

USERID ogguser,PASSWORD ogguser

Source Context :

SourceModule : [ggdb.ora.sess]

SourceID : [/net/ap1109nap-vlan900/vol/ifarm_ports/ifarm_views/aime_oggcore_210874/oggcore/OpenSys/src/gglib/ggdbora/ocisess.c]

SourceFunction : [oci_try]

SourceLine : [642]

ThreadBacktrace : [14] elements

: [/u01/ogg/ogghome/libgglog.so(CMessageContext::AddThreadContext()+0x26) [0x562166]]

: [/u01/ogg/ogghome/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2c5) [0x55e125]]

: [/u01/ogg/ogghome/libgglog.so(_MSG_ERR_ORACLE_OCI_ERROR_WITH_DESC(CSourceContext*, int, char const*, char const*, CMessageFactory::MessageD

isposition)+0x40) [0x548398]]

: [./mgr(OCISESS_context_def::oci_try(int, char const*, ...)+0x3e4) [0x812a104]]

: [./mgr(OCISESS_context_def::logon(ggs::gglib::ggapp::CLoginName const&, ggs::gglib::ggapp::CDBObjName const&, ggs::gglib::gg

unicode::UString const&, int, bool, int, int, int)+0x78c) [0x812b33c]]

: [./mgr(DBOCI_init_connection_logon(ggs::gglib::ggapp::CLoginName const&, ggs::gglib::ggapp::CDBObjName const&, char const*,

int, int, int, char*)+0x6c) [0x81112dc]]

: [./mgr [0x812215f]]

: [./mgr(gl_odbc_param(char const*, char const*, char*)+0x4c) [0x812240c]]

: [./mgr(param_file_args(char*)+0x1538) [0x8087668]]

: [./mgr(init_functions(int, char**)+0x62c) [0x8087cfc]]

: [./mgr(main_loop(int, char**)+0x48) [0x808da68]]

: [./mgr(main+0xe8) [0x808e268]]

: [/lib/libc.so.6(__libc_start_main+0xdc) [0x580de9c]]

: [./mgr(__gxx_personality_v0+0x159) [0x807aba1]]

2013-12-24 11:26:09 ERROR OGG-00664 OCI Error beginning session (status = 28001-ORA-28001: the password has expired).

2013-12-24 11:26:09 ERROR OGG-01668 PROCESS ABENDING.

SQL> conn ogguser/ogguser

ERROR:

ORA-28001: the password has expired

Changing password for ogguser

New password:

Retype new password:

Password changed

Connected.

GGSCI (localhost.localdomain) 8> start mgr

Manager started.

GGSCI (localhost.localdomain) 9> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

JAGENT STOPPED

EXTRACT ABENDED AWEN_EXT 00:00:00 1080:42:55

EXTRACT ABENDED AWEN_PMP 00:00:00 1080:42:57

REPLICAT ABENDED AWEN_REP 00:00:00 1080:42:55 [/code]

「喜欢文章，快来给作者赞赏墨值吧」 赞赏

【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源(墨天轮)，文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

评论

请登录后发表评论