Help: java.sql.SQLException: ORA-06550: line 1, column 7: ,PLS-00201:
Who can give me hands for resolving below issue? I use the 11G db before couple of days. It works. But now it displayed below information, It block my application server to be up. Anyone can help take a look? And explain for me what's meaning with below issue?
Thanks
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SHARED_POOL.KEEP' must be declared
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
08/11/05 02:18:17 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
08/11/05 02:18:17 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
08/11/05 02:18:17 at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
08/11/05 02:18:17 at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:184)
08/11/05 02:18:17 at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:873)
08/11/05 02:18:17 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1161)
08/11/05 02:18:17 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
08/11/05 02:18:17 at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3093)
08/11/05 02:18:17 at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4286)
08/11/05 02:18:17 at com.agile.pc.cmserver.util.OracleIDGenerator.pinSequence(OracleIDGenerator.java:245)
08/11/05 02:18:17 at com.agile.pc.cmserver.util.OracleIDGenerator.<init>(OracleIDGenerator.java:62)
08/11/05 02:18:17 at com.agile.pc.cmserver.util.CMUtilReflection.getOracleIDGenerator(CMUtilReflection.java:79)
08/11/05 02:18:17 at com.agile.util.dao.IDGenerator.getNewInstance(IDGenerator.java:78)
08/11/05 02:18:17 at com.agile.util.dao.IDGenerator.getInstance(IDGenerator.java:66)
08/11/05 02:18:17 at com.agile.util.dao.IDGenerator.getNextID(IDGenerator.java:91)
08/11/05 02:18:17 at com.agile.util.AppServerId.<clinit>(AppServerId.java:14)
08/11/05 02:18:17 at com.agile.startup.PCMStartupImpl.start(PCMStartupImpl.java:115)
08/11/05 02:18:17 at com.agile.ui.pcm.InitServlet.init(InitServlet.java:63)
08/11/05 02:18:17 at com.evermind.server.http.HttpApplication.loadServlet(HttpApplication.java:2379)
08/11/05 02:18:17 at com.evermind.server.http.HttpApplication.findServlet(HttpApplication.java:4830)
08/11/05 02:18:17 at com.evermind.server.http.HttpApplication.findServlet(HttpApplication.java:4754)
08/11/05 02:18:17 at com.evermind.server.http.HttpApplication.initPreloadServlets(HttpApplication.java:4942)
08/11/05 02:18:17 at com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:1144)
08/11/05 02:18:17 at com.evermind.server.http.HttpApplication.<init>(HttpApplication.java:741)
08/11/05 02:18:17 at com.evermind.server.ApplicationStateRunning.getHttpApplication(ApplicationStateRunning.java:431)
08/11/05 02:18:17 at com.evermind.server.Application.getHttpApplication(Application.java:586)
08/11/05 02:18:17 at com.evermind.server.http.HttpSite$HttpApplicationRunTimeReference.createHttpApplicationFromReference(HttpSite.java:1987)
08/11/05 02:18:17 at com.evermind.server.http.HttpSite$HttpApplicationRunTimeReference.<init>(HttpSite.java:1906)
08/11/05 02:18:17 at com.evermind.server.http.HttpSite.initApplications(HttpSite.java:643)
08/11/05 02:18:17 at com.evermind.server.http.HttpSite.setConfig(HttpSite.java:290)
08/11/05 02:18:17 at com.evermind.server.http.HttpServer.setSites(HttpServer.java:270)
08/11/05 02:18:17 at com.evermind.server.http.HttpServer.setConfig(HttpServer.java:177)
08/11/05 02:18:17 at com.evermind.server.ApplicationServer.initializeHttp(ApplicationServer.java:2493)
08/11/05 02:18:17 at com.evermind.server.ApplicationServer.setConfig(ApplicationServer.java:1042)
08/11/05 02:18:17 at com.evermind.server.ApplicationServerLauncher.run(ApplicationServerLauncher.java:131)
Edited by: user774630 on Nov 4, 2008 6:57 PM