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

Last updated on JUNE 24, 2016

Applies to:

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

Symptoms

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

ERROR
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
privileges<br>
java.sql.SQLException: ORA-01031: insufficient privileges

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:676)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:602)
at oracle.jdbc.driver.T2CStatement.executeForDescribe(T2CStatement.java:778)
at oracle.jdbc.driver.T2CStatement.executeForRows(T2CStatement.java:971)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1726)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1696)
at intradoc.jdbc.JdbcConnection.prepareConnection(JdbcConnection.java:197)
at intradoc.jdbc.JdbcConnection.init(JdbcConnection.java:160)
at intradoc.provider.ProviderPoolManager.createConnection(ProviderPoolManager.java:403)
at intradoc.jdbc.JdbcManager.createConnection(JdbcManager.java:278)
at intradoc.provider.ProviderPoolManager.addConnectionToPool(ProviderPoolManager.java:382)
at intradoc.jdbc.JdbcWorkspace.initConnections(JdbcWorkspace.java:442)
at intradoc.server.IdcSystemLoader.loadDatabase(IdcSystemLoader.java:814)
at intradoc.server.IdcServerManager.init(IdcServerManager.java:77)
at IdcServer.init(IdcServer.java:64)
at IdcServer.main(IdcServer.java:37)


Cause

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