I have never worked with Streams. But some of my colleagues are working with streams and they have come to me with a problem.
First thing I found that they are to set up a Distributed Hotlog Publishing streams, but, they are using 220.127.116.11 db as source and 10.2.0.4 db as target. Both database is on same box.
Is it possible to configure with different versions?
Now, they are following metalink note [ID 550597.1] (sorry not attaching the complete note, it is long) and followed upto step 7. Well, they have not used SYS account to give grant. They had their own dba user to give grant.
At step 8, on staging db when they fire the create_hotlog_change_source then the procedure executed successfully. But while checking CHANGE_SOURCES on source db the new change_source_name is not found.
Step 9 is getting failed with...
ORA-31401: change source SRC is not an existing change source
ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 560
ORA-06512: at line 2
CDC is the user they are using as Stream admin. All grants to this user has been given by another DBA user(not sys). Apart from the grant given we have given below grant as sys.
DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE(GRANTEE => 'CDC');