0 Replies Latest reply: Feb 10, 2012 4:48 PM by Raj_writer RSS

    SQl server to Oracle -- Replicat error command disallowed by current ..

    Raj_writer
      I am trying to set replication b/w sql serve *& oracle..

      Source -- SQL server 2005 SP4.
      Target - Oracle 11.2.0.3 - using ASM ..single instance..

      The error log is ....
      2012-02-10 17:33:47 ERROR OGG-00664 Oracle GoldenGate Delivery for Oracle, rcatd1.prm: OCI Error beginning session (status = 15000-ORA-15000: command disallowed by current instance type).
      2012-02-10 17:33:47 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rcatd1.prm: PROCESS ABENDING.
      2012-02-10 17:34:00 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params RCATD1.
      2012-02-10 17:34:10 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start replicat RCATD1.
      2012-02-10 17:34:10 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 10.1.7.80 (START REPLICAT RCATD1 ).
      2012-02-10 17:34:10 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT RCATD1 starting.
      2012-02-10 17:34:10 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rcatd1.prm: REPLICAT RCATD1 starting.
      2012-02-10 17:34:11 ERROR OGG-00664 Oracle GoldenGate Delivery for Oracle, rcatd1.prm: OCI Error beginning session (status = 15000-ORA-15000: command disallowed by current instance type).
      2012-02-10 17:34:11 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rcatd1.prm: PROCESS ABENDING.

      edit params RCATD1

      REPLICAT RCATD1
      SOURCEDEFS /home/oracle/GG/dirdef/catalog.def
      USERID ggs,PASSWORD ggs
      MAP dbo.tmp_webskuchs,TARGET catalog.tmp_webskuchs;

      the steps I am doing are

      [oracle@fl1dvmatgdb2 GG]$ ./ggsci

      Oracle GoldenGate Command Interpreter for Oracle
      Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
      Linux, x64, 64bit (optimized), Oracle 11g on Oct 4 2011 23:49:46

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

      GGSCI (fl1dvmatgdb2) 1> dblogin userid ggs, password ggs
      Successfully logged into database.

      GGSCI (fl1dvmatgdb2) 2> start replicat RCATD1

      Sending START request to MANAGER ...
      REPLICAT RCATD1 starting

      GGSCI (fl1dvmatgdb2) 3> info RCATD1, detail

      REPLICAT RCATD1 Initialized 2012-02-10 15:28 Status STOPPED
      Checkpoint Lag 00:00:00 (updated 02:19:44 ago)
      Log Read Checkpoint File dirdat/l2000000
      First Record RBA 0

      Extract Source Begin End

      dirdat/l2000000 * Initialized * First Record


      Current directory /home/oracle/GG

      Report file /home/oracle/GG/dirrpt/RCATD1.rpt
      Parameter file /home/oracle/GG/dirprm/rcatd1.prm
      Checkpoint file /home/oracle/GG/dirchk/RCATD1.cpr
      Checkpoint table GGS.CHKPT
      Process file /home/oracle/GG/dirpcs/RCATD1.pcr
      Stdout file /home/oracle/GG/dirout/RCATD1.out
      Error log /home/oracle/GG/ggserr.log



      can anybody give me a clue why I am getting ora-15000 on GG

      Thanks in advance..

      Edited by: 898080 on Feb 10, 2012 2:47 PM