SETENV SID for Rac Environment with 4 nodes
Good morning folks!
I have a doubt about SETENV parameter on extracts and replicats.
Today i have a Cluster with 4 nodes. My whole configuration for GondenGate is in only one node because I don't have any ideia what kind of parameter I put in this field.
My Example:
EXTRACT intext
(SETENV ORACLE_SID=prenf1) -- I have prenf1, prenf2, prenf3 and prenf4
USERID ggate, PASSWORD ggate
TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 100)
EXTTRAIL /u01/app/ggate/dirdat/lt
TABLE sh.customers;
How can I put a SID Like UNIKE NAME in this parameter which can be recognized in all nodes?
Thanks and best Reguards.