I'm trying to configure stream replication from 'server1' to 'server2'. I have created 'stradmin' users and stream_tbs tablespaces on both servers using 'Cloud Control'.
I can tnsping and connect from server1 to server2, and from server2 to server1 on the command line, i.e:
[oracle@server1 ~]$ tnsping DB2.SERVER2.EXAMPLE.COM
TNS Ping Utility for Linux: Version 126.96.36.199.0 - Production on 06-FEB-2012 14:06:39
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server2.example.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = db2.server2.example.com)))
OK (0 msec)
[oracle@tesla ~]$ sqlplus stradmin@DB2.SERVER2.EXAMPLE.COM
SQL*Plus: Release 188.8.131.52.0 Production on Mon Feb 6 14:06:46 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
And the reverse (connecting from server2 to server1 works the same way.
When I try to configure stream replication using Cloud Control, I am able to configure a job to start the replication, but when it runs, I get the following: