EAS控制台新增数据中心会有错误

栏目：eas cloud知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

EAS控制台新增数据中心会有错误

服务器都是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,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)