Send email using utl_smtp in Oracle 11g (results in ORA-24247)(11g ACL 网络访问控制列表)

ORA-24247: network access denied by access control list (ACL)
ORA-06512: at “SYS.UTL_TCP”, line 17
ORA-06512: at “SYS.UTL_TCP”, line 267

OGG-01028 Oracle GoldenGate Capture for Oracle,Table compression is not supported

2013-09-29 10:03:15 ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, eicmec.prm: Object with object number 81069 is compressed. Table compression is not supported.

Oradebug Security

DEMO 1,How to use oradebug to call OS commands via the database
DEMO 2,Disable sys audit

How to imp job to another schema in same db(同一数据库导入JOB到另外一用户)

ORA-39083: Object type JOB failed to create with error:
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated

Goldengate source and target table differ in column structure part-2(ogg同步不同的表结构数据)

map icme.test_s, target icme.test_t,
COLMAP(usedefaults,
create_date =@IF(@STREQ(@GETENV(“GGHEADER”,”OPTYPE”),”INSERT”),@DATENOW(),@COLSTAT(MISSING)),
last_update_date=@datenow()

Goldengate source and target table differ in column structure part-1(ogg同步不同的表结构数据)

昨天一朋友问如果用GOLDENGATE同步数据(ETL),如果目标端比源端多出一个时间字段表示最后的修改日期, […]

Dynamically Changing shared_pool_size fail!(动态修改Shared pool size失败)

因安装数据库时启用了ASMM,过了几天发现分配不太理想想禁用ASMM,手动调整shared_pool_size, 这是一个动态参数,修改后立即生效无需重启数据库实例,但修改时遇到了比较奇怪的现象。