Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Ora-01031 Error
Ora-01031 Error [message #125138] Thu, 23 June 2005 09:08
b_lakshmanan_1981
Messages: 1
Registered: June 2005
Location: chennai
Junior Member
Dear all,

I am facing the problem (ora-01031) while calling any oracle procedures from java. Its not occuring frequently. Sometime it occuring. After restarting the application server 2 or 3 times then the problem solved. I don't know where the problem resides. I checked in the Database side, every gran permission and all the object are in the valid state. while the problem occurs it not occurs for every screen or module. It occurs for some specific page. In each and every page we will call an backend procedure.

An sample error is pasted below:

java.sql.SQLException: ORA-01031: insufficient privileges
at weblogic.db.oci.OciCursor.getCDAException(OciCursor.java:259)
at weblogic.jdbc.oci.Statement.executeUpdate(Statement.java:980)
at weblogic.jdbc.oci.Statement.execute(Statement.java:1442)
at weblogic.jdbc.pool.Statement.execute(Statement.java:297)
at RETFLLoanProcess.validateID(RETFLLoanProcess.java:77)
at RETFLLoan.doGet(RETFLLoan.java:157)
at RETFLLoan.doPost(RETFLLoan.java:56)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1094)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:437)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:319)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:5626)
at weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManager.java:685)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3213)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2555)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:251)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:219)
java.sql.SQLException: ORA-01031: insufficient privileges

thanks in advance...

Regards
Lak
Previous Topic: Coexistance of 9iAS(90220) and 10gAS(9.0.4.1) versions on the same machine (Windows)
Next Topic: Fatal NI connect error 12631
Goto Forum:
  


Current Time: Thu Mar 28 09:42:43 CDT 2024