SAP Knowledge Base Article - Preview

2679785 - Error "ORA-01031: insufficient privileges" during initializing via hac with Oracle DB12cR2

Symptom

When performing initialization via hac with DB connecting to Oracle DB12c: Error "ORA-01031: insufficient privileges" throws.

Error log example:

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, insufficient privileges, initialize error, grant privileges , KBA , CEC-COM-CPS , SAP Commerce , 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.