读取设置
支持JDBC 读取方式
支持Logminer数据读取方式
支持Datapipeline Oracle 采集代理 数据读取方式
权限及使用要求
- 开启日志补全:
ALTER DATABASE FORCE LOGGING;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL, PRIMARY KEY, UNIQUE) COLUMNS ; - 创建视图、用户并赋权:
CREATE OR REPLACE VIEW XKCCLE AS SELECT FROM sys.x$kccle;
CREATE OR REPLACE VIEW XKCCCP AS SELECT FROM sys.x$kcccp;
CREATE OR REPLACE VIEW DPXKSPPI AS SELECT FROM X$KSPPI;
CREATE OR REPLACE VIEW DP_XKSPPSV AS SELECT FROM X$KSPPSV;
CREATE OR REPLACE VIEW DP_KSPPCV AS SELECT * FROM X$KSPPCV;
create user agent1 identified by agent1 account unlock; --密码强度可按照要求修改。
grant CONNECT,SELECT ANY TABLE,SELECT ANY DICTIONARY to agent1;
grant select on sys.fzs_pdbs to agent1;
grant select on sys.ts$ to agent1;
grant select on sys.tabsubpart$ to agent1;
grant select on sys.obj$ to agent1;
grant select on sys.seg$ to agent1;
grant select on sys.coltype$ to agent1;
grant select on sys.xkccle to agent1;
grant select on sys.xkcccp to agent1;
grant select on sys.DP_XKSPPI to agent1;
grant select on sys.DP_XKSPPSV to agent1;
grant select on sys.DP_KSPPCV to agent1;
grant select on sys.seq$ to agent1;
grant select on sys.user$ to agent1;
grant select on sys.col$ to agent1;
grant select on sys.ind$ to agent1;
grant select on sys.tab$ to agent1;
grant select on sys.lob$ to agent1;
grant select on sys.indpart$ to agent1;
grant select on sys.lobfrag$ to agent1;
grant select on sys.user$ to agent1;
grant select on sys.source$ to agent1;
grant select on sys.view$ to agent1;
grant select on sys.ts$ to agent1;
grant select on sys.profname$ to agent1;
grant select on sys.profile$ to agent1;
grant select on sys.sysauth$ to agent1;
grant select on sys.props$ to agent1;
grant select on sys.idl_ub1$ to agent1;
grant select on sys.user$ to agent1;
grant select on sys.ntab$ to agent1;
grant select on sys.sum$ to agent1;
grant select on sys.com$ to agent1;
grant select on sys.partlob$ to agent1;
grant select on sys.attrcol$ to agent1;
grant select on sys.ccol$ to agent1;
grant select on sys.subpartcol$ to agent1;
grant select on sys.tabpart$ to agent1;
grant select on sys.indpart$ to agent1;
grant select on sys.indcompart$ to agent1;
grant select on sys.defrole$ to agent1;
grant select on sys.v$instance to agent1;
grant select on SYS.v$database to agent1;
grant select on sys.v$datafile to agent1;
grant select on sys.V$SESSION to agent1;
grant select on sys.v$log to agent1;
grant select on sys.v$logfile to agent1;
grant select on sys.gv$logfile to agent1;
3. ASM实例要求:
ASM 的用户
-- 创建用户名/密码
create user agentasm identified by agentasm;
-- ASM 用户须有 SYSDBA 角色
grant sysdba to agentasm;