GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

SETENV SID for Rac Environment with 4 nodes

edited Feb 8, 2017 6:25PM in GoldenGate, Streams and Distributed Database (MOSC) 7 commentsAnswered

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center