GBase数据库产品--GBaseUp跨引擎数据交换报错

gbase> insert into test_ora.t select * from test.t1;

ERROR 29913 (HY000): ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-29400: data cartridge error

KUP-04094: preprocessing cannot be perfo

解决方法

需要卸载oracle 数据安全控制

确认过程：

a) 查询oracle存在vault SQL> select * from v$option where parameter like '%Vault%';

PARAMETER

---

VALUE

---

Oracle Database Vault

TRUE

b) 卸载vault

停服务

SQL> shutdown immediate;

关闭监听

lsnrctl stop

关闭em

[oracle@b7-node1-178 rdbms]$ emctl status dbconsole

Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.

[oracle@b7-node1-178 rdbms]$ emctl stop dbconsole

Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.

Disable过程

cd $ORACLE_HOME/rdbms/lib

make -f ins_rdbms.mk dv_off ioracle

/usr/bin/ar d /home/oracle/U01/ORAHOME/rdbms/lib/libknlopt.a kzvidv.o

/usr/bin/ar cr /home/oracle/U01/ORAHOME/rdbms/lib/libknlopt.a /home/oracle/U01/ORAHOME/rdbms/lib/kzvndv.o

chmod 755 /home/oracle/U01/ORAHOME/bin

chopt disable dv

c) 启动监听，启动服务，确认no vault

select * from v$option where parameter like '%Vault%';

PARAMETER

---

VALUE

---

Oracle Database Vault

FALSE