Oracle Streams configuration

The document StreamsReplication_unidir.doc includes:

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

The entry you should add to your tnsnames.ora file looks like:

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)