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

Oracle Streams configuration

The documment streams_replication_1dir_v2.doc includes:

  • replication using streams overview
  • replication environment configuration
  • scripts to join a new database to the 3D testbed environment

The entry you must add to your tnsnames.ora file is:

RLS1R1.CERN.CH =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = lxshare084d.cern.ch)(PORT =1521))

(CONNECT_DATA = (SID = rls1))

)

Streams user and administrator PRIVILEGES

Streams USER PRIVILEGES (schema owner)

  • connect, resource
  • select_catalog_role (to look into data dictionary)
  • create and drop public synonym
  • exp_full_database and imp_full_database (to instantiate streams)

Streams ADMINISTRATOR PRIVILEGES

  • dba privilege is a requirement (Oracle 10g)
Topic attachments
I Attachment History Action Size Date Who Comment
Microsoft Word filedoc streams_replication_1dir_v2.doc r2 r1 manage 84.5 K 2005-10-11 - 11:48 EvaDafonte Streams (Replication) configuration
Edit | Attach | Watch | Print version | History: r11 | r9 < r8 < r7 < r6 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r7 - 2005-11-29 - unknown
 
    • 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