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)