1 2 Previous Next 15 Replies Latest reply: Jun 21, 2013 10:39 AM by yxes2013 RSS

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

    862070
      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