普元平台初始化数据库

在正确安装和配置普元平台以后，我们就可以登录到普元管理控制台 http://localhost:8088/eosmgr 进行更进一步的配置。这里就包括数据库的初始化工作。为了方便起见，我们只需要在oracle的样例数据库ORCL中添加一个用户xuwei，然后将普元的数据库初始化到xuwei账户下。oracle创建用户的方法请参考前一篇博客：使用Oracle SQLDeveloper连接数据库并创建用户。

登录普元管理控制台 http://localhost:8088/eosmgr，然后选择“应用管理->数据库初始化”，填写数据库连接配置，如下图所示。填写完毕以后点击“测试”以验证数据库是否正确连接。

消息：测试数据库连接成功！则表明我的数据库连接时正确的，这时候我们只需要点击“初始化”即可。

不过点击初始化以后会报错，这里我们不需要管这些错误。之所以出现这些错误是因为在创建数据库的时候，在建表前会删除同名的表，但是我们的数据库是空的，所以才会报错。错误如下：

数据库初始化完成，有错误发生：

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is:DROP TABLE EOSEJBRegister cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE EOSUniqueTable cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table BNCOMMON_T_Information cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table BNDICT_T_BusinType cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table BNDict_T_Dictionary cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop view BNDICT_V_Dictionary 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table EOSORG_T_EmpPosition cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table EOSORG_T_PositionRole cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table EOSORG_T_Position cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE EOSORG_T_EmpOrgRef cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE EOSORG_T_Employee cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE EOSORG_T_OrgRef cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE EOSORG_T_Organization cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE EOSOperatorConfig cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is:alter table EOSRoleDataPrivilege drop constraint FK_EOSDATA_REFERENCE_EOSROLE 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: alter table EOSRoleDataPrivilege drop constraint FK_EOSMODL_REFERENCE_EOSROLE 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: alter table EOSBizCatalogDef drop constraint FK_EOSBIZCA_REFERENCE_EOSBIZCA 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: alter table EOSBizCatalogDef drop constraint FK_EOSBIZCA_REFERENCE_EOSFUNCT 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: alter table EOSFunction drop constraint FK_EOSFUNCT_REFERENCE_EOSFUNCT 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: alter table EOSOperatorRole drop constraint FK_EOSOPERA_REFERENCE_EOSROLE 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: alter table EOSOperatorRole drop constraint FK_EOSOPERA_REFERENCE_EOSOPERA 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: alter table EOSRole drop constraint FK_EOSROLE_REFERENCE_EOSROLEG 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: alter table EOSRoleCatalog drop constraint FK_EOSROLEC_REFERENCE_EOSBIZCA 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: alter table EOSRoleCatalog drop constraint FK_EOSROLEC_REFERENCE_EOSROLE 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: alter table EOSRoleMenu drop constraint FK_EOSROLEM_REFERENCE_EOSROLE 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: alter table EOSRoleMenu drop constraint FK_EOSROLEM_REFERENCE_EOSMENU 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop view EOSVRoleMenu 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop view EOSVRoleCatalog 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop view EOSVOperatorRole 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop view EOSVOperatorMenu 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop view EOSVOperatorFunction 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop view EOSVCatalogFunction 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop view EOSVRoleDataPrivilege 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table EOSDataPrivilegeModel 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table EOSRoleDataPrivilege 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table EOSBizCatalog cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table EOSBizCatalogDef cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table EOSFunction cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table EOSFunctionUnit cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table EOSMenu cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table EOSOperator cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table EOSOperatorRole cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table EOSRole cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table EOSRoleCatalog cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table EOSRoleGroup cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table EOSRoleMenu cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is:drop table FBFILE_T_FILE 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is:drop table BNREPORT_T_REPORT 

Fail to run sql,due to ORA-01418: 指定的索引不存在 SQL is: drop index BNLOG_I_LOG_TIME 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table BNLOG_T_BusiLogic cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table BNLOG_T_Log cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table BNLOG_T_LogHistory cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table BNBASEDT_T_ParamClass cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table BNBASEDT_T_ParamName cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table BNBASEDT_T_ParamValue cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE WFActivityInst cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE WFAuditLog cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE WFProcessControl cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE WFProcessDefine cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE WFProcessInst cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE WFTimer cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE WFTransCtrl cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE WFTransition cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE WFWIParticipant cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE WFWorkItem cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE WF_H_ActivityInst cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE WF_H_ProcessInst cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE WF_H_TransCtrl cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE WF_H_Transition cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE WF_H_WIParticipant cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE WF_H_WorkItem cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE WFSystemInfo cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE WFProcessInstAttr cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: DROP TABLE WF_H_ProcessInstAttr cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: alter table WFAgentItem drop constraint FK_WFAGENTI_FK_WFAGEN_WFAGENT 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: alter table WFAgentScope drop constraint FK_WFAGENTS_REFERENCE_WFPERSON 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table WFAgent cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table WFAgentItem cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table WFAgentScope cascade constraints 

Fail to run sql,due to ORA-00942: 表或视图不存在 SQL is: drop table WFPersonInfo cascade constraints 

这时候我们连接到ORCL数据库的XUWEI账户下查看新建的数据库表，如下图所示：

一共有57张表，这些表都是普元自带的系统表。在使用普元平台开发系统的时候，我们还需要设计我们自己的数据，只需要往xuwei账户中添加表即可。