Errors Reported in the 10g WebCenter Content (WCC) Server Logs: "java.sql.SQLException: ORA-01031: Insufficient Privileges"

(Doc ID 782197.1)

Last updated on SEPTEMBER 25, 2017

Applies to:

Oracle WebCenter Content - Version and later
Information in this document applies to any platform.


-- Problem Statement:
After a new installation of Content Server, the following error is seen in the logs:

ClusterNode2: Unable to execute session initialization query 'alter session set events '30579
trace name context forever, level 2''. java.sql.SQLException: ORA-01031: insufficient privileges [
Details ]
An error has occurred. The stack trace below shows more information.

!$ClusterNode2: !csJdbcConnectionUnableExecuteInitQuery,alter session set events '30579 trace name
context forever\, level 2'!syExceptionType2,java.sql.SQLException,ORA-01031: insufficient
java.sql.SQLException: ORA-01031: insufficient privileges

at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.T2CConnection.checkError(
at oracle.jdbc.driver.T2CConnection.checkError(
at oracle.jdbc.driver.T2CStatement.executeForDescribe(
at oracle.jdbc.driver.T2CStatement.executeForRows(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OracleStatement.executeInternal(
at oracle.jdbc.driver.OracleStatement.execute(
at intradoc.jdbc.JdbcConnection.prepareConnection(
at intradoc.jdbc.JdbcConnection.init(
at intradoc.provider.ProviderPoolManager.createConnection(
at intradoc.jdbc.JdbcManager.createConnection(
at intradoc.provider.ProviderPoolManager.addConnectionToPool(
at intradoc.jdbc.JdbcWorkspace.initConnections(
at intradoc.server.IdcSystemLoader.loadDatabase(
at intradoc.server.IdcServerManager.init(
at IdcServer.init(
at IdcServer.main(


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms