Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose
Heterogeneous replication and XStreams support for GoldenGate
AUTHID
CURRENT_USER
Dependencies
DBMS_APPLY_ADM
DBMS_DBFS_SFS_ADMIN
DBMS_STREAMS_DECL
DBMS_APPLY_ADM_INTERNAL
DBMS_LOGREP_UTIL
DBMS_XSTREAM_GG_INTERNAL
DBMS_DBFS_CONTENT_ADMIN
Documented
No
Exceptions
Error Code
Reason
ORA-26947
Oracle GoldenGate replication is not enabled
First Available
11.2
Security Model
Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
Direct access to some objects in this package is prevented by means of an Accessible By clause.
exec dbms_xstream_gg.disable_tdup_workspace;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 308
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 85
ORA-06512: at line 1
Generates an error if GG replication is not enabled
dbms_xstream_gg.enable_tdup_workspace;
exec dbms_xstream_gg.enable_tdup_workspace;
*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 290
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 54
ORA-06512: at line 1
BEGIN
IF dbms_xstream_gg.is_ctas_no_dml_at_session THEN
dbms_output.put_line('Enabled');
ELSE
dbms_output.put_line(' Not Enabled');
END IF;
END;
/
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 348
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 274
ORA-06512: at line 2
BEGIN
IF dbms_xstream_gg.is_foo_trigger_fire_at_session THEN
dbms_output.put_line('Enabled');
ELSE
dbms_output.put_line(' Not Enabled');
END IF;
END;
/
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 264
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 28
ORA-06512: at line 2
BEGIN
IF dbms_xstream_gg.is_tdup_workspace_enabled THEN
dbms_output.put_line('Enabled');
ELSE
dbms_output.put_line(' Not Enabled');
END IF;
END;
/
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 299
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 70
ORA-06512: at line 2
dbms_xstream_gg.set_ctas_session_context('suppress_dml IN BOOLEAN);
ALTER SYSTEM SET
enable_goldengate_replication=TRUE SID='*' SCOPE=spfile;
exec dbms_xstream_gg.set_ctas_session_context(TRUE);
*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 339
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 259
ORA-06512: at line 1
dbms_xstream_gg.set_foo_trigger_session_contxt(fire IN BOOLEAN);
ALTER SYSTEM SET
enable_goldengate_replication=TRUE SID='*' SCOPE=spfile;
exec dbms_xstream_gg.set_foo_trigger_session_contxt(TRUE);
*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 255
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 13
ORA-06512: at line 1
dbms_xstream_gg.set_gg_no_stmt_buf(set IN BOOLEAN);
ALTER SYSTEM SET
enable_goldengate_replication=TRUE SID='*' SCOPE=spfile;
exec dbms_xstream_gg.set_gg_no_stmt_buf(TRUE);
*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 320
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 104
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 162
ORA-06512: at line 1
dbms_xstream_gg.set_gg_no_ws_for_def_cons(set IN BOOLEAN);
exec dbms_xstream_gg.set_gg_no_stmt_buf(TRUE);
exec dbms_xstream_gg.set_gg_no_ws_for_def_cons(FALSE);
*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 320
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 104
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 232
ORA-06512: at line 1
exec dbms_xstream_gg.set_gg_session(FALSE);
*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 320
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 104
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 135
ORA-06512: at line 1
dbms_xstream_gg.set_gg_session_flags(
gg_flags IN BINARY_INTEGER,
smode IN BINARY_INTEGER);
exec dbms_xstream_gg.set_gg_no_stmt_buf(TRUE);
exec dbms_xstream_gg.set_gg_session_flags(1,1);
*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 320
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 104
ORA-06512: at line 1
dbms_xstream_gg.set_gg_xml_schema(set IN BOOLEAN);
exec dbms_xstream_gg.set_gg_no_stmt_buf(TRUE);
exec dbms_xstream_gg.set_gg_xml_schema(TRUE);
*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 320
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 104
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 197
ORA-06512: at line 1
SET_SESSION_ACTION_GG
Undocumented
dbms_xstream_gg.set_session_action_gg(
action_name IN VARCHAR2,
logmnr_session# IN NUMBER,
action_type IN VARCHAR2,
action_options IN NUMBER,
xid_usn IN NUMBER,
xid_slt IN NUMBER,
xid_sqn IN NUMBER,
thread# IN NUMBER,
start_scn IN NUMBER,
start_sub_scn IN NUMBER,
end_scn IN NUMBER,
end_sub_scn IN NUMBER,
rba_sqn IN NUMBER,
rba_blk IN NUMBER,
rba_byte IN NUMBER,
session# IN NUMBER,
obj# IN NUMBER,
attr1 IN NUMBER,
attr2 IN NUMBER,
attr3 IN NUMBER);
TBD
UNSET_SESSION_ACTION_GG
Undocumented
dbms_xstream_gg.unset_session_action_gg(
action_name IN VARCHAR2,
logmnr_session# IN NUMBER,
force IN BOOLEAN);