管理中心无法创建oracle数据库
金蝶云社区-Hardy
Hardy
0人赞赏了该文章 909次浏览 未经作者许可,禁止转载编辑于2017年12月19日 18:28:56

cloud版本是7.0,管理中心win2012,数据服务器是linux,管理中心创建Oracle数据库时,提示创建失败: ORA-39002: invalid operationORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3507
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3756
ORA-06512: at line 7|declare
按照论坛帖子处理后,也是这个错误。请远程指导下:QQ401001259
创建失败: ORA-39001: invalid argument value
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3507
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3756
ORA-06512: at line 9|declare
h1 NUMBER;
l1 varchar2(20);
begin
h1 := dbms_datapump.open (operation => 'IMPORT', job_mode => 'SCHEMA', job_name => 'JOB_EXP2', version => 'COMPATIBLE');
dbms_datapump.set_parallel(handle => h1, degree => 1);
dbms_datapump.add_file(handle => h1, filename => 'OracleMCPatternDB171219151650.log', directory => 'DATA_PUMP_DIR', filetype => 3);
dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 0);
dbms_datapump.add_file(handle => h1, filename => 'OracleMCPatternDB.dmp', directory => 'DATA_PUMP_DIR', filetype => 1);
dbms_datapump.metadata_filter(handle => h1, name => 'SCHEMA_EXPR', value => 'IN(''KDSA'')');
dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', value => 1);
dbms_datapump.set_parameter(handle => h1, name => 'DATA_ACCESS_METHOD', value => 'AUTOMATIC');
dbms_datapump.set_parameter(handle => h1, name => 'SKIP_UNUSABLE_INDEXES', value => 0);
dbms_datapump.set_parameter(handle => h1, name => 'TABLE_EXISTS_ACTION', value => 'REPLACE');
dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_SCHEMA', old_value => 'KDSA', value => 'FINANCE1');
dbms_datapump.metadata_filter(handle => h1,name => 'EXCLUDE_PATH_EXPR', value => 'IN(''STATISTICS'')');
dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_TABLESPACE', old_value => 'USERS', value => 'FINANCE');
dbms_datapump.metadata_transform(handle => h1, name => 'OID', value => 0);
dbms_datapump.start_job(handle => h1, skip_current => 0, abort_step => 0);
dbms_datapump.wait_for_job(handle => h1, job_state => l1);
dbms_datapump.detach(handle => h1);
end;

Stack Trace: at Kingdee.BOS.ServiceHelper.DataCenterService.CreateDataCenter(ICreateDataCenter dc)
at Kingdee.BOS.Web.CMC_Ajax.CreateDBCenterInformation(