This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Jun 21, 2013 8:39 AM by yxes2013 RSS

OGG-00664 .. status = 1017-ORA-01017: /;

862070 Newbie
Currently Being Moderated
hi all,

evn:
source:Sqlserver 2008R2
target:Oracle 11gR2


--the replicat paramater
GGSCI (single.localdomain) 33> edit params msrep

REPLICAT MSREP
SOURCEDEFS /u01/app/ora11g/gg/dirdef/emp.def
USERID gg_user,PASSWORD welcome1
MAP hrschema.emp, TARGET gg_user.emp;


--login db is no problem
GGSCI (single.localdomain) 34> dblogin USERID gg_user,PASSWORD welcome1
Successfully logged into database.


--when start the replicat process,ggserr.log error info..
GGSCI (single.localdomain) 34> start msrep

ggserr.log:
......
2012-05-07 16:27:41 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, msrep.prm: REPLICAT MSREP starting.
2012-05-07 16:01:52 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, msrep.prm: Operating system character set identified as US-ASCII. Locale: zh_CN, LC_ALL:.
*2012-05-07 16:01:52 ERROR OGG-00664 Oracle GoldenGate Delivery for Oracle, msrep.prm: OCI Error beginning session (status = 1017-ORA-01017: /; ).*
2012-05-07 16:01:52 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, msrep.prm: PROCESS ABENDING.

the report info:
GGSCI (single.localdomain) 37> view report msrep


***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 11.2.1.0.0 OGGCORE_11.2.1.0.0_PLATFORMS_120131.1910_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Feb 1 2012 01:09:15

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


Starting at 2012-05-07 16:27:41
***********************************************************************

Operating System Version:
Linux
Version #1 SMP Tue Jan 18 20:11:49 EST 2011, Release 2.6.32-100.26.2.el5
Node: single.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: 29676

Description:

***********************************************************************
** Running with the following parameters **
***********************************************************************

2012-05-07 16:27:41 INFO OGG-03035 Operating system character set identified as US-ASCII. Locale: z
h_CN, LC_ALL:.
REPLICAT MSREP
SOURCEDEFS /u01/app/ora11g/gg/dirdef/emp.def
USERID gg_user,PASSWORD ********

Source Context :
SourceModule : [ggdb.ora.sess]
SourceID : [/scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/gglib/gg
dbora/ocisess.c]
SourceFunction : [oci_try]
SourceLine : [629]
ThreadBacktrace : [13] elements
: [/u01/app/ora11g/gg/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0
x7fefb7a6845e]]
: [/u01/app/ora11g/gg/libgglog.so(CMessageFactory::CreateMessage(CSourceContex
t*, unsigned int, ...)+0x2cc) [0x7fefb7a649ac]]
: [/u01/app/ora11g/gg/libgglog.so(_MSG_ERR_ORACLE_OCI_ERROR_WITH_DESC(CSourceC
ontext*, int, char const*, char const*, CMessageFactory::MessageDisposition)+0x41) [0x7fefb7a510e7]]
: [/u01/app/ora11g/gg/replicat(OCISESS_context_def::oci_try(int, char const*,
...)+0x4da) [0x61b88a]]
: [/u01/app/ora11g/gg/replicat(OCISESS_context_def::logon(ggs::gglib::ggapp::C
LoginName const&, ggs::gglib::ggapp::CDBObjName<(DBObjType)12> const&, ggs::gglib::ggunicode::UString co
nst&, int, bool, int, int, int)+0x6da) [0x61a8da]]
: [/u01/app/ora11g/gg/replicat(DBOCI_init_connection_logon(ggs::gglib::ggapp::
CLoginName const&, ggs::gglib::ggapp::CDBObjName<(DBObjType)12> const&, char const*, int, int, int, char
*)+0x91) [0x5faac1]]
: [u01/app/ora11g/gg/replicat [0x5f039d]]
: [u01/app/ora11g/gg/replicat [0x5f0610]]
: [u01/app/ora11g/gg/replicat(odbc_param(char*, char*)+0x144) [0x5f0a34]]
: [/u01/app/ora11g/gg/replicat(get_infile_params(time_elt_def*, time_elt_def*,
char**)+0x1139) [0x51fce9]]
: [u01/app/ora11g/gg/replicat(main+0x117) [0x543977]]
: [lib64/libc.so.6(__libc_start_main+0xf4) [0x3de661d994]]
: [u01/app/ora11g/gg/replicat(__gxx_personality_v0+0x31a) [0x4bcb9a]]

2012-05-07 16:27:42 ERROR OGG-00664 OCI Error beginning session (status = 1017-ORA-01017: /; ).

2012-05-07 16:27:42 ERROR OGG-01668 PROCESS ABENDING.


GGSCI (single.localdomain) 38>

regards,

Edited by: user12030691 on 2012-5-7 上午2:29

Edited by: user12030691 on 2012-5-7 上午2:38
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points