Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29 Using GoldenGate to replicate between databases on same host | Oracle DBA – Tips and Techniques
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
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?
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
3 Comments