oracle数据库无法创建管理中心

云小爱

1,777次浏览编辑于2014年05月13日 18:09:44

测试成功，点击创建后，“正在创建管理中心，请稍后”，通过pl/sql查询后台，没有创建表。应用服务器与数据库服务器分别装在两台服务器上。操作系统均为windows2008,日志文件如下：
2014-05-13 17:41:29,869 [8] INFO - - Begin restore Data Center By DATA_PUMP_DIR\OracleMCPatternDB.dmp...
2014-05-13 17:41:49,899 [8] ERROR - - Fail to create datacenter 999
System.Exception: ORA-39001: invalid argument value
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3444
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3693
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 => 'OracleMCPatternDB.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.metadata_remap(handle => h1, name => 'REMAP_SCHEMA', old_value => 'KDSA', value => 'K3CLOUD');
dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_TABLESPACE', old_value => 'USERS', value => 'CLOUD_D_STANDARD');
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;

at Kingdee.BOS.App.Security.DataCenter.Service.OracleDataBaseHelper.RestoreDataCenter()
at Kingdee.BOS.App.Security.K3DataCenterService.RestoreDataCenter(Context ctx, IRestoreDataCenter dc)
at Kingdee.BOS.App.Security.K3DataCenterService.CreateOrUpgradeDataCenter(IDataCenterInfo dc, String bakFile, StartArg arg)
at Kingdee.BOS.App.Security.K3DataCenterService.InternalCreateDataCenter(ICreateDataCenter dc, StartArg arg)
2014-05-13 17:45:53,559 [8] ERROR - - Fail to Invoke [35vuw4dvtiwtr2uonphncyyb]
发生时间： 2014/5/13 17:45:53
错误来源：
错误类型： Oracle.DataAccess.Client.OracleException, Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342
错误信息： ORA-00942: table or view does not exist
===================================================
调用堆栈：

Server stack trace:
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
at Oracle.DataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior)
at Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, CommandBehavior cmdBehavior)
at Kingdee.BOS.App.Core.SystemParameterService.GetGetParamterXML(Context ctx, Int64 orgId, Int64 acctBookId, String parameterObjId, Int64 acctpolicyID)
at Kingdee.BOS.App.Core.SystemParameterService.Load(Context ctx, Int64 orgId, Int64 acctBookId, String parameterObjId, Int64 acctpolicyID, Boolean bIsRunTime)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Kingdee.BOS.Contracts.ISystemParameterService.Load(Context ctx, Int64 orgId, Int64 acctBookId, String parameterObjId, Int64 acctpolicyID, Boolean bIsRunTime)
at Kingdee.BOS.MC.App.ManagementCenterService.GetMCSysParameterValue[T](Context ctx, String key)
at Kingdee.BOS.App.Security.K3DataCenterService.GetDataCenterList(Context ctx, DataBaseCategory curDBCategory, String siteId)
at Kingdee.BOS.ServiceHelper.DataCenterService.GetDataCentersFromMC(String ServerUrl, DataBaseCategory curDBCategory)

2014-05-13 17:45:53,761 [8] ERROR - - Unhandel ServiceEx
发生时间： 2014/5/13 17:45:53
错误来源：
错误类型： Oracle.DataAccess.Client.OracleException, Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342
错误信息： ORA-00942: table or view does not exist
===================================================
调用堆栈：

2014-05-13 17:47:50,307 [27] ERROR - - Fail to Invoke [t2ml31e2mnozqtnf3u0o4xu4]
发生时间： 2014/5/13 17:47:50
错误来源：
错误类型： Oracle.DataAccess.Client.OracleException, Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342
错误信息： ORA-00942: table or view does not exist
===================================================
调用堆栈：

2014-05-13 17:47:50,307 [27] ERROR - - Unhandel ServiceEx
发生时间： 2014/5/13 17:47:50
错误来源：
错误类型： Oracle.DataAccess.Client.OracleException, Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342
错误信息： ORA-00942: table or view does not exist
===================================================
调用堆栈：

2014-05-13 17:58:34,591 [11] INFO - - Begin restore Data Center By DATA_PUMP_DIR\OracleMCPatternDB.dmp...
2014-05-13 17:58:37,072 [11] ERROR - - Fail to create datacenter 999
System.Exception: ORA-39001: invalid argument value
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3444
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3693
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 => 'OracleMCPatternDB.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.metadata_remap(handle => h1, name => 'REMAP_SCHEMA', old_value => 'KDSA', value => 'CLOUDTEST');
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;

赞 0 评论 1 收藏

oracle数据库无法创建管理中心

恭喜您！