DB Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
==== Setting Up Sequences in Bi-Directional GoldenGate ====

Log on as GGATE user

**Run on ANDRACAA**
<code>exec mol_sequences.mol_seqoddeven('FBIAGENT');
exec mol_sequences.mol_seqoddeven('MAILONLINE');</code>

**Run on MOLBB**
<code>exec mol_sequences.mol_seq_alternate('FBIAGENT');
exec mol_sequences.mol_seq_alternate('MAILONLINE');</code>

**SQL Statement to Check that the above was Successful**
<code>set lines 120
col sequence_name format a30

select owner, sequence_name, valueint ANDRACA_VALUE, valuepoc MOLBB_VALUE,
       case when mod(ValueInt,2) = mod(ValuePOC,2) then 'ERROR'
         else 'ODD EVEN SUCCESS'
       end Validation
from ggate.mol_gg_sequences where owner in ('FBIAGENT','MAILONLINE')
order by owner, sequence_name;</code>

==== Unlock Accounts On MOLBB ====
<code>ALTER USER ANALYTICS ACCOUNT UNLOCK;
ALTER USER ANDCOMMUNITIES ACCOUNT UNLOCK;
ALTER USER APTECO ACCOUNT UNLOCK;
ALTER USER CLEARSPACE ACCOUNT UNLOCK;
ALTER USER CSMIG ACCOUNT UNLOCK;
ALTER USER EAGLEEYE ACCOUNT UNLOCK;
ALTER USER FBIAGENT ACCOUNT UNLOCK;
ALTER USER GATEKEEPER ACCOUNT UNLOCK;
ALTER USER GATEKEEPERADMIN ACCOUNT UNLOCK;
ALTER USER GKREAD ACCOUNT UNLOCK;
ALTER USER JOBMANAGER ACCOUNT UNLOCK;
ALTER USER MAILONLINE ACCOUNT UNLOCK;
ALTER USER MAILREAD ACCOUNT UNLOCK;
ALTER USER MOFEEDS ACCOUNT UNLOCK;
ALTER USER MOLAPP ACCOUNT UNLOCK;
ALTER USER MOLEM ACCOUNT UNLOCK;
ALTER USER MOLSUPP ACCOUNT UNLOCK;
ALTER USER MOUSER ACCOUNT UNLOCK;
ALTER USER SCHOOL ACCOUNT UNLOCK;
ALTER USER TIMBOARDS ACCOUNT UNLOCK;
ALTER USER TIMDEBATE ACCOUNT UNLOCK;
ALTER USER TRAVELMAIL ACCOUNT UNLOCK;</code>