GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

10gR2 Streams Config errors

edited Feb 22, 2011 6:51AM in GoldenGate, Streams and Distributed Database (MOSC) 8 commentsAnswered
After following ALL necessary pre-reqs for configuring A unidirectional streams replication between 2 test databases, I ran the MAINTAIN_SCHEMAS procedure for 2 schemas, but I'm getting the following errors (see below).

 

SQL> BEGIN
  2  DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS(
  3       schema_names            => 'SCHEMA1,SCHEMA2',
  4       source_directory_object         => 'STREAMS_DIR',
  5       destination_directory_object => 'STREAMS_DIR',
  6       source_database                 => 'TESTDB1.DOMAIN.ORG,
  7       destination_database    => 'TESTDB2.DOMAIN.ORG',
  8       capture_name            => 'CAPTURE_TESTDB1',
  9       capture_queue_table     => 'CAPTURE_TESTDB1_QT',
 10       capture_queue_name              => 'CAPTURE_TESTDB1_QN',
 11       capture_queue_user      => 'STREAMS_ADMIN',
 12       propagation_name                => 'PROPAGATION_TESTDB2',
 13       apply_name                      => 'APPLY_TESTDB2',
 14       apply_queue_table               => 'APPLY_TESTDB2_Qt',

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center