| oracle streams global_names [message #573790] |
Thu, 03 January 2013 03:32  |
 |
maninderkrb
Messages: 41
Registered: August 2012
Location: India
|
Member |
|
|
In oracle stream multiple target and one source scenario.(table level replication)
we used to set the parameter global_names=true;
this is so ,bec the dblink and dbname has to be same.
but if we have dbname same on all the servers,
i.e
sourcedb=moddb
dest1db =moddb
dest2db=moddb
dest3db=moddb
we cant set global_names=true;?????
from same source it will not be possible to create dblink with same name as of db on all destinations as it is same.
if we can how ???
so will replication work with global_names=false;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: oracle streams global_names [message #574242 is a reply to message #574186] |
Tue, 08 January 2013 03:49  |
|
maninderkrb
Messages: 41
Registered: August 2012
Location: India
|
Member |
|
|
i create the db link but later found the error as mentioned below
create public database link moddb@moddbsource connect to strmadmin identified by strmadmin using 'MODDB133'
SQL> begin dbms_streams_adm.add_table_propagation_rules
2 ( table_name => 'MODDB.TBL_SPECIALZONEMASTER',
3 streams_name => 'source_TO_DB05',
4 source_queue_name => 'strmadmin.streams_queue',
5 destination_queue_name => 'strmadmin.streams_queue@"moddb@dest05"',
include_dml => true,
include_ddl => true,
source_database => 'moddb',
inclusion_rule => true);
end;
/ 6 7 8 9 10 11
begin dbms_streams_adm.add_table_propagation_rules
*
ERROR at line 1:
ORA-24045: invalid agent address "STRMADMIN"."STREAMS_QUEUE"@moddb@dest05,
agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 836
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 765
ORA-06512: at line 1
|
|
|
|
|
|
| Re: oracle streams global_names [message #574250 is a reply to message #574248] |
Tue, 08 January 2013 04:10 |
|
maninderkrb
Messages: 41
Registered: August 2012
Location: India
|
Member |
|
|
SQL> select * from dual@moddb@dest05;
D
-
X
#############################
SQL> select db_link from dba_db_links;
DB_LINK
--------------------------------------------------------------------------------
MODDB@DEST05
SQL>
SQL>
SQL> begin dbms_streams_adm.add_table_propagation_rules
2 ( table_name => 'MODDB.TBL_SPECIALZONEMASTER',
3 streams_name => 'source_TO_DB05',
4 source_queue_name => 'strmadmin.streams_queue',
5 destination_queue_name => 'strmadmin.streams_queue@moddb@dest05',
6 include_dml => true,
7 include_ddl => true,
8 source_database => 'moddb',
9 inclusion_rule => true);
10 end;
11 /
begin dbms_streams_adm.add_table_propagation_rules
*
ERROR at line 1:
ORA-24045: invalid agent address strmadmin.streams_queue@moddb@dest05, agent
address should be of the form [SCHEMA.]NAME[@DATABASE LINK]
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 836
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 765
ORA-06512: at line 1
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
