cloud 7.0 用oracle创建数据库失败
金蝶云社区-Dashwood
Dashwood
0人赞赏了该文章 1,130次浏览 未经作者许可,禁止转载编辑于2017年11月01日 14:29:19


已经创建新的oracle实例,但是在新建账套的时候总提示上图。服务器:server 2012 r2 ;64位;12G内存。
金蝶日志如下:
System.Exception: ORA-04021: 等待锁定对象 时发生超时|
CREATE OR REPLACE FUNCTION KD_HTTP_DOWNLOAD(ServerURL STRING)
RETURN VARCHAR2 IS --执行OS命令测试
LANGUAGE JAVA NAME ' KDExeSysCommand.DownloadFile(java.lang.String) return java.lang.String';
在 Kingdee.BOS.App.Security.DataCenter.Service.AbstractDataBaseHelper.ExecuteNoQuery(String sSQL, Boolean bSYSDBA, List`1 parameters)
在 Kingdee.BOS.App.Security.DataCenter.Service.OracleDataBaseHelper.EnableHTTPService()
在 Kingdee.BOS.App.Security.K3DataCenterService.GetDbPatternFileByHTTP(ICreateDataCenter dc, String& bakFile)
2017-11-01 13:53:22,368 [11] DEBUG - - Extract PattrenDbCabFile D:\Kingdee\K3clode\ManageSite\App_Data\DataBase\PatternDbFile\OracleBCPatternDB.cab to D:\Kingdee\K3clode\CommonFileServer\K3CloudPattrenDbFile\OracleBCPatternDB.dmp
2017-11-01 13:53:31,222 [11] INFO - - FTP Download Pattern DB - Begin:
2017-11-01 13:53:31,223 [11] DEBUG - -
-- Retrieve a binary file from a remote FTP server.
DECLARE
l_conn UTL_TCP.connection;
BEGIN
l_conn := ftp.login('win-sj1nhgj1ej5', '21', 'Anonymous', '');
ftp.binary(p_conn => l_conn);
ftp.get(p_conn => l_conn,
p_from_file => '/K3CloudFileServer/K3CloudPattrenDbFile/OracleBCPatternDB.dmp',
p_to_dir => 'DATA_PUMP_DIR',
p_to_file => 'OracleBCPatternDB.dmp');
ftp.logout(l_conn);
END;
2017-11-01 13:53:31,247 [11] ERROR - - FTP Download Pattern DB Failed: ORA-29260: 网络错误:尚未连接
ORA-06512: 在 "SYS.UTL_TCP", line 235
ORA-06512: 在 "SYS.UTL_TCP", line 473
ORA-06512: 在 "SYS.FTP", line 171
ORA-20000: 500 Command not understood. Use EPSV command.
ORA-06512: 在 "SYS.FTP", line 286
ORA-06512: 在 line 8|
-- Retrieve a binary file from a remote FTP server.
DECLARE
l_conn UTL_TCP.connection;
BEGIN
l_conn := ftp.login('win-sj1nhgj1ej5', '21', 'Anonymous', '');
ftp.binary(p_conn => l_conn);
ftp.get(p_conn => l_conn,
p_from_file => '/K3CloudFileServer/K3CloudPattrenDbFile/OracleBCPatternDB.dmp',
p_to_dir => 'DATA_PUMP_DIR',
p_to_file => 'OracleBCPatternDB.dmp');
ftp.logout(l_conn);
END;
2017-11-01 13:53:31,248 [11] INFO - - Begin restore Data Center By DATA_PUMP_DIR\OracleBCPatternDB.dmp...
2017-11-01 13:53:31,859 [11] DEBUG - - ======Begin import database by follow sql==========
2017-11-01 13:53:31,859 [11] DEBUG - - 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 => 'OracleBCPatternDB171101135331.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 => 'OracleBCPatternDB.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 => 'CR');
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 => 'USERS');
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;
2017-11-01 13:53:31,859 [11] DEBUG - - ========End========
2017-11-01 13:53:40,021 [11] ERROR - - Fail to create datacenter HT01
System.Exception: ORA-39001: 参数值无效
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: 在 "SYS.DBMS_DATAPUMP", line 4087
ORA-06512: 在 "SYS.DBMS_DATAPUMP", line 4338
ORA-06512: 在 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 => 'OracleBCPatternDB171101135331.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 => 'OracleBCPatternDB.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 => 'CR');
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 => 'USERS');
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;
在 Kingdee.BOS.App.Security.DataCenter.Service.OracleDataBaseHelper.RestoreDataCenter()
在 Kingdee.BOS.App.Security.K3DataCenterService.RestoreDataCenterForCreate(Context ctx, IRestoreDataCenter dc)
在 Kingdee.BOS.App.Security.K3DataCenterService.CreateOrUpgradeDataCenter(IDataCenterInfo dc, String bakFile, StartArg arg)
在 Kingdee.BOS.App.Security.K3DataCenterService.InternalCreateDataCenter(ICreateDataCenter dc, StartArg arg)
用了另一台服务器进行访问得到结果如下: