EAS控制台新增数据中心会有错误
EAS Cloud-环境部署与运维
金蝶云社区-云社区用户8W141234
云社区用户8W141234
0人赞赏了该文章 2,442次浏览 未经作者许可，禁止转载编辑于2015年11月02日 11:10:23

服务器都是linux系统, 数据库为oracle. 在EAS控制台使用sys用户在数据中心新建数据库的，sys有所有权限，一共有4个表空间：EAS_D_2015112_STANDARD、EAS_T_2015112_STANDARD、EAS_D_2015112_TEMP2、EAS_D_2015112_INDEX。 在oracle的sqlplus里面查询了其中有3个表空间都建立好了，有1个没建立好，没建立好的表空间是 EAS_T_2015112_STANDARD。 试了很多次都这样。报错信息如下：
[2015-11-02 11:02:13,186 INFO]Begin create database.....
[2015-11-02 11:02:13,187 INFO]Success create database
[2015-11-02 11:02:13,187 INFO]Begin init database....
[2015-11-02 11:02:13,195 INFO]Normal tablespace EAS_D_2015112_STANDARD is bigfile
[2015-11-02 11:02:13,195 INFO]Create Normal TableSpace(oracle normal):CREATE BIGFILE TABLESPACE "EAS_D_2015112_STANDARD" LOGGING DATAFILE '/EASDB/oradata1/EAS_D_2015112_STANDARD.ora' SIZE 2000M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
[2015-11-02 11:02:31,425 INFO]Create Normal TableSpace(oracle temp):CREATE TEMPORARY TABLESPACE "EAS_T_2015112_STANDARD" TEMPFILE '/EASDB/oradata1/EAS_T_2015112_STANDARD.dbf' SIZE 50M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M
[2015-11-02 11:02:31,775 INFO]Create Temp TableSpace(oracle normal):CREATE TABLESPACE "EAS_D_2015112_TEMP2" NOLOGGING DATAFILE '/EASDB/oradata1/EAS_D_2015112_TEMP2.dbf' SIZE 500M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
[2015-11-02 11:02:36,421 INFO]Create Index TableSpace(oracle normal):CREATE TABLESPACE "EAS_D_2015112_INDEX" LOGGING DATAFILE '/EASDB/oradata1/EAS_D_2015112_INDEX.ora' SIZE 500M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
[2015-11-02 11:02:48,645 INFO]Execute sql: CREATE USER 2015112 PROFILE "DEFAULT" IDENTIFIED BY "1111" DEFAULT TABLESPACE "EAS_D_2015112_STANDARD" TEMPORARY TABLESPACE "EAS_T_2015112_STANDARD" ACCOUNT UNLOCK
[2015-11-02 11:02:48,648 ERROR]Execute SQL[CREATE USER 2015112 PROFILE "DEFAULT" IDENTIFIED BY "1111" DEFAULT TABLESPACE "EAS_D_2015112_STANDARD" TEMPORARY TABLESPACE "EAS_T_2015112_STANDARD" ACCOUNT UNLOCK] failed, cause by ORA-01935: missing user or role name

java.sql.SQLException: ORA-01935: missing user or role name

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:206)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:956)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1695)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1661)
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.processSQL(AbstractDB.java:852)
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.executeSqlProvider(AbstractDB.java:743)
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.execute(AbstractDB.java:563)
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.executeSql(AbstractDB.java:488)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.initDatabase(DataCenterServiceImpl.java:1634)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.createNewDataCenter(DataCenterServiceImpl.java:1700)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)
at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.processRpcCallMessage(RpcWorker.java:237)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.run(RpcWorker.java:81)
[2015-11-02 11:02:48,659 ERROR]Execute provider[SingleSQLExecutor] failed!
Source SQL:[CREATE USER 2015112 PROFILE "DEFAULT" IDENTIFIED BY "1111" DEFAULT TABLESPACE "EAS_D_2015112_STANDARD" TEMPORARY TABLESPACE "EAS_T_2015112_STANDARD" ACCOUNT UNLOCK] failed!
Exception:sqlcode[1935] sqlstat[42000]!
java.sql.SQLException: ORA-01935: missing user or role name

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:206)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:956)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1695)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1661)
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.processSQL(AbstractDB.java:852)
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.executeSqlProvider(AbstractDB.java:743)
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.execute(AbstractDB.java:563)
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.executeSql(AbstractDB.java:488)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.initDatabase(DataCenterServiceImpl.java:1634)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.createNewDataCenter(DataCenterServiceImpl.java:1700)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)
at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.processRpcCallMessage(RpcWorker.java:237)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.run(RpcWorker.java:81)
[2015-11-02 11:02:48,667 ERROR]Execute provider[SingleSQLExecutor] failed!
Source SQL:[CREATE USER 2015112 PROFILE "DEFAULT" IDENTIFIED BY "1111" DEFAULT TABLESPACE "EAS_D_2015112_STANDARD" TEMPORARY TABLESPACE "EAS_T_2015112_STANDARD" ACCOUNT UNLOCK] failed!
Exception:sqlcode[1935] sqlstat[42000]!
java.sql.SQLException: ORA-01935: missing user or role name

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:206)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:956)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1695)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1661)
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.processSQL(AbstractDB.java:852)
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.executeSqlProvider(AbstractDB.java:743)
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.execute(AbstractDB.java:563)
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.executeSql(AbstractDB.java:488)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.initDatabase(DataCenterServiceImpl.java:1634)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.createNewDataCenter(DataCenterServiceImpl.java:1700)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)
at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.processRpcCallMessage(RpcWorker.java:237)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.run(RpcWorker.java:81)
[2015-11-02 11:02:48,674 INFO]1 : 2
[2015-11-02 11:02:48,674 INFO]1 : 2
[2015-11-02 11:02:48,674 ERROR]Invoke service[interface com.kingdee.eas.tools.admin.domain.DataCenterService] method [createNewDataCenter] failed
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)
at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.processRpcCallMessage(RpcWorker.java:237)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.run(RpcWorker.java:81)
Caused by:
com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[SingleSQLExecutor], sql[CREATE USER 2015112 PROFILE "DEFAULT" IDENTIFIED BY "huahong" DEFAULT TABLESPACE "EAS_D_2015112_STANDARD" TEMPORARY TABLESPACE "EAS_T_2015112_STANDARD" ACCOUNT UNLOCK] failed, sqlcode[1935] sqlstat[42000],Causedby[ORA-01935: missing user or role name
]
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.executeSqlProvider(AbstractDB.java:747)
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.execute(AbstractDB.java:563)
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.executeSql(AbstractDB.java:488)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.initDatabase(DataCenterServiceImpl.java:1634)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.createNewDataCenter(DataCenterServiceImpl.java:1700)
... 10 more
[2015-11-02 11:02:48,679 ERROR]566108606:com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[SingleSQLExecutor], sql[CREATE USER 2015112 PROFILE "DEFAULT" IDENTIFIED BY "1111" DEFAULT TABLESPACE "EAS_D_2015112_STANDARD" TEMPORARY TABLESPACE "EAS_T_2015112_STANDARD" ACCOUNT UNLOCK] failed, sqlcode[1935] sqlstat[42000],Causedby[ORA-01935: missing user or role name
]
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.executeSqlProvider(AbstractDB.java:747)
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.execute(AbstractDB.java:563)
at com.kingdee.eas.tools.admin.framework.database.impl.AbstractDB.executeSql(AbstractDB.java:488)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.initDatabase(DataCenterServiceImpl.java:1634)
at com.kingdee.eas.tools.admin.domain.impl.DataCenterServiceImpl.createNewDataCenter(DataCenterServiceImpl.java:1700)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)
at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.processRpcCallMessage(RpcWorker.java:237)
at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.run(RpcWorker.java:81)

Memory Usage = 67108864/14612128

推荐阅读

EAS管理控制台选中数据中心报异常错误

EAS7.5环境，使用集群模式，选中管理控制台数据中心中任意一个已有数据中心时报错，但是客户端还能正常使用，错误信息请见附件1. 新建数据中心在配置完数据存储设 …

    文章

    702

EAS协同新增数据中心后问题

EAS中新增了一个数据中心，用协同的内容管理，增加分类的时候报错，这是怎么回事，有人知道吗 [图片] 提单中请附上详细的日志信息，多谢了 ,已经上传日志文件了 …

    文章

    604

eas81新增的数据中心,怎么把旧数据中心的 …

[概述] 由于EAS81是注册用户制,用户均是在企业云平台上录入的,然后同步到EAS中的; 所以EAS81新增的数据中心,用administrator登录客户端 …

    知识

    187