SAP Knowledge Base Article - Preview

2679785 - Oracle DB12cR2 での hac を使用した初期化時のエラー "ORA-01031: insufficient privileges"

Symptom

Oracle DB12c に接続されている DB で hac を使用して初期化を実行すると、エラー "ORA-01031: insufficient privileges" が表示されます。

エラーログの例:

CREATE INDEX qualifier_1097 ON comptypegrp2comptype (Qualifier); CREATE INDEX linktarget_1097 ON comptypegrp2comptype (TargetPK); CREATE INDEX linksource_1097 ON comptypegrp2comptype (SourcePK)]; SQL state [null]; error code [17081]; error occurred during batching: ORA-01031: insufficient privileges
; nested exception is java.sql.BatchUpdateException: error occurred during batching: ORA-01031: insufficient privileges

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) ~[spring-jdbc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:419) ~[spring-jdbc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:600) ~[spring-jdbc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at de.hybris.bootstrap.ddl.DefaultDbScriptsExecutor.executeBatch(DefaultDbScriptsExecutor.java:142) ~[ybootstrap.jar:?]
... 141 more
Caused by: java.sql.BatchUpdateException: error occurred during batching: ORA-01031: insufficient privileges

at oracle.jdbc.driver.OracleStatement.executeLargeBatch(OracleStatement.java:4516) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.OracleStatement.executeBatch(OracleStatement.java:4384) ~[ojdbc8.jar:12.2.0.1.0]
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:234) ~[ojdbc8.jar:12.2.0.1.0]
at de.hybris.platform.jdbcwrapper.StatementImpl.executeBatch(StatementImpl.java:481) ~[coreserver.jar:?]
at org.springframework.jdbc.core.JdbcTemplate$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate.java:561) ~[spring-jdbc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate.java:548) ~[spring-jdbc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408) ~[spring-jdbc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:600) ~[spring-jdbc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at de.hybris.bootstrap.ddl.DefaultDbScriptsExecutor.executeBatch(DefaultDbScriptsExecutor.java:142) ~[ybootstrap.jar:?]
... 141 more


Read more...

Environment

  • SAP Hybris Commerce 6.6 および 6.7
  • Oracle DB12cR2 

Product

SAP Hybris Commerce 6.6 ; SAP Hybris Commerce 6.7

Keywords

ORA-01031, 権限不足, 初期化エラー, 権限付与 , KBA , CEC-SCC-PLA-PL , Platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.