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 , Commerce Platform & Suite (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 ONE Support launchpad (Login required).

Search for additional results

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