WARNING: This web is not used anymore. Please use PDBService.OracleStreamsTestswithCOOL instead!
 

ORACLE STREAMS TESTS with COOL

COOL ACCOUNTS: SCRIPTS and DOCUMENTATION

Please note that this page only deals with Oracle specific deployment issues

STREAMS CONFIGURATION

  • Streams setup at schema level for Oracle COOL accounts on CERN databases.

HOW TO JOIN

  • Add the necessary rules to the current Streams configuration to propagate and apply the changes made to the COOL schemas created. Please use the following script:
    • addNewSchema_COOL_joinSite.sql
    • The script will run the necessary actions on both sites, source and destination.
    • The script will ask you to enter the destination global name (site who join) and the propagation process name at the source database (select from the list displayed). For example: RAL
         Enter site name (global name): TEST3D.GRIDPP.RL.AC.UK 
 
         PROPAGATION_NAME
         ------------------------------
         STRMADMIN_PROPAGATE
         STRMADMIN_PROPAGATE_CGCL1
         STRMADMIN_PROPAGATE_CMSCALDR
         STRMADMIN_PROPAGATE_CNAFDB
         STRMADMIN_PROPAGATE_TEST3DRAL
         STRMADMIN_PROPAGATE_TW3DTEST

         Enter propagation name (see list): STRMADMIN_PROPAGATE_TEST3DRAL         
Topic attachments
I Attachment History Action Size Date Who Comment
Unknown file formatsql addNewSchema_COOL_joinSite.sql r3 r2 r1 manage 5.7 K 2005-10-12 - 15:10 EvaDafonte  
Texttxt export_import_example.txt r1 manage 0.9 K 2005-10-12 - 12:07 EvaDafonte  
Edit | Attach | Watch | Print version | History: r9 < r8 < r7 < r6 < r5 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r9 - 2006-08-02 - EvaDafonte
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback