News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

3 Comments

Sugandha
  • Feb 13 2011
Hi, I am new to goldengate. I was trying to use goldengate to replicate data between two databases I created on the same oracle instance Oracle10g on same host. My extract process is abending and the extract report is showing this error message: 2011-02-12 21:16:25 WARNING OGG-01194 EXTRACT task EMP_REP abended : OCI Error during OCIServerAttach (status = 12505-ORA-12505: TNS:listener does not currently know of SID given in connect descriptor). My DB SIDs are xe and n3. I have created corresponding TNS aliases as dbxe and dbn3. My extract and replicat params files are: EXTRACT emp_ext USERID ggate@dbxe, PASSWORD ggate RMTHOST Sugandha, MGRPORT 9500 RMTTASK replicat, GROUP emp_rep TABLE u1.EMPLOYEES; REPLICAT emp_rep USERID ggate@dbn3, PASSWORD ggate ASSUMETARGETDEFS MAP u1.employees, TARGET u1.employees; Please help in this regard Thanks, Sugandha
Anil
  • Jan 12 2017
Does goldengate replication supports for Roles and Privileges? Example: if we grant privilege on a source object, will it reflect on the object at target side?
Gavin Soorma
  • Jan 12 2017
Yes - if we have used DDL INCLUDE ALL in the extract parameter file, any system or object level privileges granted on source will be replicated on target

Leave Reply

Your email address will not be published. Required fields are marked *