ORACLE STREAMS TESTS with ATLAS GEOMETRY

ACCOUNTS

• The script attlasdd_accounts.sql creates a copy of the accounts structure for the Atlas Geometry application.

• CERN roles and profiles must be created before running the scripts:
  • Memo explaining the CERN roles and Profiles
  • Script to create CERN roles and Profiles

STREAMS CONFIGURATION

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

HOW TO JOIN

• Create Oracle Atlas Geometry accounts (please use the script provided in the section above)
• Export and import the data on ATLASDD schema from the source database to the target site:
  • You can see a similar example on Example using the regular export and import utilities or Data Pump on 10g
• Add the necessary rules to the current Streams configuration to propagate and apply the changes made to the Atlas Geometry schemas created. Please use the following script:
  • addNewSchema_ATLASDD_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