Link to home
Start Free TrialLog in
Avatar of walkerdba
walkerdba

asked on

oracle streams

All there were created

what is next to created oracle streams

BEGIN
  DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE(
    grantee          => 'strmadmin',    
    grant_privileges => FALSE,
    file_name        => 'grant_strms_privs.sql',
    directory_name   => 'admin_dir');
END;
/
-- rule privileges section
grant execute on dbms_rule_adm to "STRMADMIN"
/
BEGIN
  dbms_rule_adm.grant_system_privilege(
    privilege => dbms_rule_adm.CREATE_EVALUATION_CONTEXT_OBJ,
    grantee => '"STRMADMIN"',
    grant_option => true);
END;
/
BEGIN
  dbms_rule_adm.grant_system_privilege(
    privilege => dbms_rule_adm.CREATE_RULE_SET_OBJ,
    grantee => '"STRMADMIN"',
    grant_option => true);
END;
/
BEGIN
  dbms_rule_adm.grant_system_privilege(
    privilege => dbms_rule_adm.CREATE_RULE_OBJ,
    grantee => '"STRMADMIN"',
    grant_option => true);
END;
/
BEGIN
  dbms_rule_adm.grant_system_privilege(
    privilege => dbms_rule_adm.CREATE_ANY_RULE_SET,
    grantee => '"STRMADMIN"',
    grant_option => true);
END;
/
BEGIN
  dbms_rule_adm.grant_system_privilege(
    privilege => dbms_rule_adm.ALTER_ANY_RULE_SET,
    grantee => '"STRMADMIN"',
    grant_option => true);
END;
/
BEGIN
  dbms_rule_adm.grant_system_privilege(
    privilege => dbms_rule_adm.EXECUTE_ANY_RULE_SET,
    grantee => '"STRMADMIN"',
    grant_option => true);
END;
/
BEGIN
  dbms_rule_adm.grant_system_privilege(
    privilege => dbms_rule_adm.CREATE_ANY_RULE,
    grantee => '"STRMADMIN"',
    grant_option => true);
END;
/
BEGIN
  dbms_rule_adm.grant_system_privilege(
    privilege => dbms_rule_adm.ALTER_ANY_RULE,
    grantee => '"STRMADMIN"',
    grant_option => true);
END;
/
BEGIN
  dbms_rule_adm.grant_system_privilege(
    privilege => dbms_rule_adm.EXECUTE_ANY_RULE,
    grantee => '"STRMADMIN"',
    grant_option => true);
END;
/
-- queue privileges section
grant execute on dbms_aq to "STRMADMIN"
/
grant execute on dbms_aqadm to "STRMADMIN"
/
BEGIN
  dbms_aqadm.grant_system_privilege(
    'ENQUEUE_ANY',
    '"STRMADMIN"',
    admin_option => TRUE);
END;
/
BEGIN
  dbms_aqadm.grant_system_privilege(
    'DEQUEUE_ANY',
    '"STRMADMIN"',
    admin_option => TRUE);
END;
/
BEGIN
  dbms_aqadm.grant_system_privilege(
    'MANAGE_ANY',
    '"STRMADMIN"',
    TRUE);
END;
/
grant select on dba_queue_tables to "STRMADMIN"
/
grant select on dba_queues to "STRMADMIN"
/
grant select on dba_queue_schedules to "STRMADMIN"
/
grant select on sys.v_$aq to "STRMADMIN"
/
grant select on sys.gv_$aq to "STRMADMIN"
/
grant select on sys.aq$_propagation_status to "STRMADMIN"
/
grant execute on sys.dbms_aqin to "STRMADMIN"
/
grant select on sys.aq$internet_users to "STRMADMIN"
/
grant execute on sys.dbms_transform to "STRMADMIN"
/
grant execute on sys.dbms_aqelm to "STRMADMIN"
/
grant select on dba_aq_agents to "STRMADMIN"
/
grant select on dba_aq_agent_privs to "STRMADMIN"
 
 
 
/
grant select on dba_queue_subscribers to "STRMADMIN"
/
-- streams packages section
grant execute on dbms_capture_adm to "STRMADMIN"
/
grant execute on dbms_propagation_adm to "STRMADMIN"
/
grant execute on dbms_apply_adm to "STRMADMIN"
/
grant execute on dbms_streams_adm to "STRMADMIN"
/
grant execute on dbms_streams_messaging to "STRMADMIN"
 
 
 
/
grant execute on dbms_streams_advisor_adm to "STRMADMIN"
/
grant execute on dbms_capture_switch_adm to "STRMADMIN"
/
grant execute on dbms_xstream_adm to "STRMADMIN"
/
grant execute on dbms_streams_handler_adm to "STRMADMIN"
/
-- streams views section
grant select on dba_streams_global_rules to "STRMADMIN"
/
grant select on dba_streams_schema_rules to "STRMADMIN"
/
grant select on dba_streams_table_rules to "STRMADMIN"
/
grant select on dba_streams_transform_function to "STRMADMIN"
/
grant select on dba_streams_administrator to "STRMADMIN"
/
grant select on dba_streams_message_rules to "STRMADMIN"
/
grant select on dba_streams_message_consumers to "STRMADMIN"
/
grant select on dba_apply to "STRMADMIN"
/
grant select on dba_apply_parameters to "STRMADMIN"
/
grant select on dba_apply_instantiated_objects to "STRMADMIN"
/
grant select on dba_apply_instantiated_schemas to "STRMADMIN"
/
grant select on dba_apply_instantiated_global to "STRMADMIN"
/
grant select on dba_apply_key_columns to "STRMADMIN"
/
grant select on dba_apply_conflict_columns to "STRMADMIN"
/
grant select on dba_apply_dml_handlers to "STRMADMIN"
/
grant select on dba_apply_progress to "STRMADMIN"
/
grant select on dba_apply_error to "STRMADMIN"
/
grant select on dba_apply_enqueue to "STRMADMIN"
/
grant select on dba_apply_execute to "STRMADMIN"
/
grant select on sys.gv_$streams_apply_coordinator to "STRMADMIN"
/
grant select on sys.v_$streams_apply_coordinator to "STRMADMIN"
/
grant select on sys.gv_$streams_apply_server to "STRMADMIN"
/
grant select on sys.v_$streams_apply_server to "STRMADMIN"
/
grant select on sys.gv_$streams_apply_reader to "STRMADMIN"
/
grant select on sys.v_$streams_apply_reader to "STRMADMIN"
/
grant select on dba_capture to "STRMADMIN"
/
grant select on dba_capture_parameters to "STRMADMIN"
/
grant select on dba_capture_prepared_database to "STRMADMIN"
/
grant select on dba_capture_prepared_schemas to "STRMADMIN"
/
grant select on dba_capture_prepared_tables to "STRMADMIN"
/
grant select on dba_capture_extra_attributes to "STRMADMIN"
/
grant select on dba_registered_archived_log to "STRMADMIN"
/
grant select on sys.gv_$streams_capture to "STRMADMIN"
/
grant select on sys.v_$streams_capture to "STRMADMIN"
/
grant select on dba_rule_sets to "STRMADMIN"
/
grant select on dba_rulesets to "STRMADMIN"
/
grant select on dba_rules to "STRMADMIN"
/
grant select on  dba_rule_set_rules to "STRMADMIN"
/
grant select on dba_evaluation_contexts to "STRMADMIN"
/
grant select on dba_evaluation_context_tables to "STRMADMIN"
/
grant select on dba_evaluation_context_vars to "STRMADMIN"
/
grant select on dba_queue_publishers to "STRMADMIN"
/
grant select on sys.gv_$buffered_queues to "STRMADMIN"
/
grant select on sys.v_$buffered_queues to "STRMADMIN"
/
grant select on sys.gv_$buffered_subscribers to "STRMADMIN"
/
grant select on sys.v_$buffered_subscribers to "STRMADMIN"
/
grant select on sys.gv_$buffered_publishers to "STRMADMIN"
/
grant select on sys.v_$buffered_publishers to "STRMADMIN"
/
grant select on dba_propagation to "STRMADMIN"
 
 
 
/
-- streams views section
grant select on dba_streams_unsupported to "STRMADMIN"
/
-- streams views section
grant select on dba_streams_newly_supported to "STRMADMIN"
/
grant select on dba_streams_rules to "STRMADMIN"
/
grant select on dba_apply_table_columns to "STRMADMIN"
/
grant select on dba_streams_add_column to "STRMADMIN"
/
grant select on dba_streams_delete_column to "STRMADMIN"
/
grant select on dba_streams_rename_column to "STRMADMIN"
/
grant select on dba_streams_rename_schema to "STRMADMIN"
/
grant select on dba_streams_rename_table to "STRMADMIN"
/
grant select on dba_streams_transformations to "STRMADMIN"
/
grant select on dba_apply_spill_txn to "STRMADMIN"
/
grant select on sys.gv_$streams_transaction to "STRMADMIN"
/
grant select on sys.v_$streams_transaction to "STRMADMIN"
/
grant select on dba_sync_capture to "STRMADMIN"
/
grant select on dba_sync_capture_prepared_tabs to "STRMADMIN"
/
grant select on sys.gv_$streams_message_tracking to "STRMADMIN"
/
grant select on sys.v_$streams_message_tracking to "STRMADMIN"
/
grant select on DBA_STREAMS_TP_COMPONENT to "STRMADMIN"
/
grant select on DBA_STREAMS_TP_COMPONENT_LINK to "STRMADMIN"
/
grant select on DBA_STREAMS_TP_COMPONENT_STAT to "STRMADMIN"
/
grant select on DBA_STREAMS_TP_DATABASE to "STRMADMIN"
/
grant select on DBA_STREAMS_TP_PATH_BOTTLENECK to "STRMADMIN"
/
grant select on DBA_STREAMS_TP_PATH_STAT to "STRMADMIN"
/
grant select on DBA_STREAMS_COLUMNS to "STRMADMIN"
/
grant select on "_DBA_STREAMS_COMPONENT" to "STRMADMIN"
/
grant select on "_DBA_STREAMS_COMPONENT_LINK" to "STRMADMIN"
/
grant select on "_DBA_STREAMS_COMPONENT_PROP" to "STRMADMIN"
/
grant select on "_DBA_STREAMS_COMPONENT_STAT" to "STRMADMIN"
/
grant select on "_DBA_STREAMS_COMPONENT_EVENT" to "STRMADMIN"
/
grant select on "_DBA_STREAMS_TP_COMPONENT_PROP" to "STRMADMIN"
/
grant select on dba_streams_keep_columns to "STRMADMIN"
/
grant select on dba_streams_split_merge to "STRMADMIN"
/
grant select on dba_streams_split_merge_hist to "STRMADMIN"
/
grant select on dba_comparison to "STRMADMIN"
/
grant select on dba_comparison_columns to "STRMADMIN"
/
grant select on dba_comparison_row_dif to "STRMADMIN"
/
grant select on dba_comparison_scan to "STRMADMIN"
/
grant select on dba_comparison_scan_values to "STRMADMIN"
/
grant select on dba_recoverable_script to "STRMADMIN"
/
grant select on dba_recoverable_script_blocks to "STRMADMIN"
/
grant select on dba_recoverable_script_errors to "STRMADMIN"
/
grant select on dba_recoverable_script_hist to "STRMADMIN"
/
grant select on dba_recoverable_script_params to "STRMADMIN"
/
grant select on dba_comparison_scan_summary to "STRMADMIN"
/
grant select on dba_xstream_inbound to "STRMADMIN"
/
grant select on dba_xstream_outbound to "STRMADMIN"
/
grant select on dba_xstream_inbound_progress to "STRMADMIN"
/
grant select on dba_xstream_outbound_progress to "STRMADMIN"
/
grant select on dba_xstream_rules to "STRMADMIN"
/
grant select on dba_streams_stmt_handlers to "STRMADMIN"
/
grant select on dba_streams_stmts to "STRMADMIN"
/
grant select on dba_apply_change_handlers to "STRMADMIN"
/
grant select on sys.gv_$streams_pool_statistics to "STRMADMIN"
/
grant select on sys.v_$streams_pool_statistics to "STRMADMIN"
/
-- miscellaneous privileges section
grant restricted session to "STRMADMIN"
/
grant execute on dbms_flashback to "STRMADMIN"
/
BEGIN
  dbms_streams_auth.grant_remote_admin_access('"STRMADMIN"');
END;
/
grant select_catalog_role to "STRMADMIN"
/
grant select on DBA_DB_LINKS to "STRMADMIN"
/
grant select on DBA_SCHEDULER_JOBS to "STRMADMIN"
/
Avatar of guruworld
guruworld

hope you set global names to true in both databases, coz that is very important. Also hope u have DB links already in place between the 2 databases.

Now what u need is creating rules, and then instantiation.. Are you propagating at table or schema level?
Is there any particular error you are getting or thing which is stopping for the streams configuration. You can put that. That will help in resolving your problem more easliy.
ASKER CERTIFIED SOLUTION
Avatar of Sanjeev Labh
Sanjeev Labh
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of walkerdba

ASKER

yes