0 Replies Latest reply: Aug 30, 2013 2:34 AM by 868428 RSS

    ORA-01749: you may not GRANT/REVOKE privileges to/from yourself SQL grant all on MYlOGIX.INVENTORY to gg_admin

    868428

      Hi Guys,

      Greetings, I am new to golden gate and have been practicing unidirectional and bidirectional replication via vmware. I have a problem where my target "Replication" Status is abended with a error "ORA-01749: you may not GRANT/REVOKE privileges to/from yourself SQL grant all on MYlOGIX.INVENTORY to gg_admin ".  Let me explain you my set up.

       

      Database version 11.2.0.3

      GG - 11g

       

      Primary Database(Source)

      Extract (Ext01)

      Data Pump (EPMP01)

      Replicate (Rep01)

      Schema name : logix

      Table Name : Inventory

      DDL Replication enabled using marker and other scripts

       

      Secondary Database ( Target)

      Extract (Ext02)

      Data Pump (EPMP02)

      Replication (Rep02)

      Schema name : mylogix

      Table Name : Inventory

      DDL replication enabled using marker and other sciprts

       

      Golden Gate User name : gg_admin on both the machines with dba previlige

       

      All my process are running fine except the target - Rep01 which fails with error "ORA-01749: you may not GRANT/REVOKE privileges to/from yourself SQL grant all on MYlOGIX.INVENTORY to gg_admin"

       

      Source Parameters:

       

      Extract :  (Ext01)                                                                                                                                                                                                   

      EXTRACT EXT01                                                                                                 

      USERID gg_admin, PASSWORD gg_admin

      EXTTRAIL /u01/app/oracle/gg/dirdat/aa

      ddl include mapped

      TABLE LOGIX.INVENTORY;

       

      Datapump: (EPMP01):

       

      EXTRACT EPMP01

      USERID gg_admin,PASSWORD gg_admin

      PASSTHRU

      RMTHOST 192.168.5.17, MGRPORT 7809

      RMTTRAIL /u01/app/oracle/gg/dirdat/ab

      TABLE LOGIX.INVENTORY;

       

      Replication (Rep02):

      REPLICAT rep02

      ASSUMETARGETDEFS

      USERID gg_admin,PASSWORD gg_admin

      handlecollisions

      DISCARDFILE /u01/app/oracle/gg/discard.txt,append,

      MAP MYLOGIX.INVENTORY, TARGET LOGIX.INVENTORY;

       

      Target Parameters:

      Extract :

      EXTRACT ext02

      USERID gg_admin,PASSWORD gg_admin

      EXTTRAIL /u01/app/oracle/gg/dirdat/ac

      TRANLOGOPTIONS EXCLUDEUSER gg_admin

      ddl include mapped

      TABLE MYLOGIX.INVENTORY;

       

      Datapump:

      EXTRACT EPMP02

      USERID gg_admin,PASSWORD gg_admin

      RMTHOST 192.168.5.15, MGRPORT 7809

      RMTTRAIL /u01/app/oracle/gg/dirdat/ad

      PASSTHRU

      TABLE MYLOGIX.INVENTORY;

       

      Replicat: ( THE ONE WHICH GETS ABENDED ALL THE TIME WITH THE ABOVE MENTIONED ERROR)

      REPLICAT rep01

      USERID gg_admin,PASSWORD gg_admin

      ASSUMETARGETDEFS

      handlecollisions

      DISCARDFILE /u01/app/oracle/gg/dirrpt/discard.txt, append,

      MAP LOGIX.INVENTORY, TARGET MYlOGIX.INVENTORY;

       

      Any help with be highly appreciated. I have already tried giving permission all on inventory to gg_admin but no use.

       

      Regards,

      Sadiq.