Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ORA-01012 : Solution for this typical problem?

17 views
Skip to first unread message

Christophe Busquet (STI)

unread,
May 23, 2001, 4:54:39 AM5/23/01
to
Hi all,

We've got every morning an ORA-01012 error in our production platform.

I know this is a typical problem and I've already heard about different
explanations (OCI problem, Shared vs Dedicated Mode, TestConnsOnReserve,
Refresh lost connexions, ...). But I need not explanations but a solution
(because we've got this in our production platform and not really in
development platform).

Note : this morning, BEA server had only 12 connexions to Oracle insta=ead
of 2x20 ! I thought the connexions were refreshed automatically, but it is
not the case !

Can someone tell me the solution ?

Thanks,
Christophe

Description :

Extract of WebLogic.properties :

weblogic.jdbc.connectionPool.commercePool=\
url=jdbc:weblogic:oracle,\
driver=weblogic.jdbc.oci.Driver,\
loginDelaySecs=0,\
initialCapacity=20,\
maxCapacity=30,\
capacityIncrement=1,\
allowShrinking=true,\
shrinkPeriodMins=15,\
testConnsOnReserve=true,\
testTable=dual,\
refreshMinutes=5,\
props=user=TABASCO;password=XXX;server=tabasco,\
weblogic.t3.waitForConnection=true;\
weblogic.t3.waitSecondsForConnection=999999999999,\
weblogic.jts.waitSecondsForConnectionSecs=999999999999,\
verbose=false


weblogic.jdbc.connectionPool.docPool=\

url=jdbc:beasys:docmgmt:com.beasys.commerce.axiom.document.ref.RefDocumentPr
ovider,\
driver=com.beasys.commerce.axiom.document.jdbc.Driver,\
loginDelaySecs=0,\
initialCapacity=20,\
maxCapacity=30,\
capacityIncrement=1,\
allowShrinking=true,\
shrinkPeriodMins=15,\
refreshMinutes=5,\
props=jdbc.url=jdbc:weblogic:pool:commercePool;\
jdbc.isPooled=true;\
weblogic.t3.waitForConnection=true;\
weblogic.t3.waitSecondsForConnection=999999999999;\
weblogic.jts.waitSecondsForConnectionSecs=999999999999;\
docBase=d:/vediorbis/tabasco/dmsBase;\
schemaXML=d:/vediorbis/tabasco/dmsBase/doc-schema.xml

Extract of the log :

Wed May 23 07:10:45 CEST 2001:<I> <EJB JAR deployment
d:/vediorbis/tabasco/tabascolib/axiom.jar> Transaction:
'990117231328_121347' rolled back due to EJB exception:
java.sql.SQLException: ORA-01012: not logged on - (TABASCO/********@tabasco)
at weblogic.db.oci.OciConnection.getLDAException(OciConnection.java:143)
at weblogic.jdbcbase.oci.Driver.connect(Driver.java:157)
at java.sql.DriverManager.getConnection(DriverManager.java:457)
at java.sql.DriverManager.getConnection(DriverManager.java:106)
at
com.beasys.commerce.axiom.contact.security.RDBMSDelegate.init(RDBMSDelegate.
java:192)
at
com.beasys.commerce.axiom.contact.security.RDBMSDelegate.<init>(RDBMSDelegat
e.java:137)
at
com.beasys.commerce.axiom.contact.security.RDBMSDelegate$DFactory.newInstanc
e(RDBMSDelegate.java:975)
at weblogic.utils.reuse.Pool.getInstance(Pool.java:57)
at
com.beasys.commerce.axiom.contact.security.RDBMSRealm.getDelegate(RDBMSRealm
.java:147)
at
com.beasys.commerce.axiom.contact.security.RDBMSRealm.getUser(RDBMSRealm.jav
a:221)
at weblogic.security.acl.CachingRealm.getUserEntry(CachingRealm.java:1121)
at weblogic.security.acl.CachingRealm.getUser(CachingRealm.java:985)
at
com.beasys.commerce.axiom.contact.security.RealmLink.userExists(RealmLink.ja
va:64)
at
com.beasys.commerce.axiom.contact.UserManagerBean.doCreateUser(UserManagerBe
an.java:278)
at
com.beasys.commerce.axiom.contact.UserManagerBean.createUser(UserManagerBean
.java:218)
at
com.beasys.commerce.axiom.contact.UserManagerBeanEOImpl.createUser(UserManag
erBeanEOImpl.java:1187)
at
com.beasys.commerce.axiom.contact.UserManagerBeanEOImpl_ServiceStub.createUs
er(UserManagerBeanEOImpl_ServiceStub.java:811)
at
com.beasys.commerce.user.jsp.tags.CreateUserTag.doStartTag(CreateUserTag.jav
a:156)
at jsp_servlet._portal._userlogin._jspService(_userlogin.java:368)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:123)
at
weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImp
l.java:154)
at
com.beasys.commerce.foundation.flow.ServletDestinationHandler.handleDestinat
ion(ServletDestinationHandler.java:51)
at
com.beasys.commerce.foundation.flow.FlowManager.service(FlowManager.java:378
)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:123)
at
weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImp
l.java:761)
at
weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImp
l.java:708)
at
weblogic.servlet.internal.ServletContextManager.invokeServlet(ServletContext
Manager.java:252)
at
weblogic.socket.MuxableSocketHTTP.invokeServlet(MuxableSocketHTTP.java:346)
at weblogic.socket.MuxableSocketHTTP.execute(MuxableSocketHTTP.java:246)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:135)
--------------- nested within: ------------------
com.beasys.commerce.axiom.contact.security.RDBMSException: realm
initialization failed, action 'DriverManager.getConnection', - with nested
exception:
[java.sql.SQLException: ORA-01012: not logged on -
(TABASCO/********@tabasco)]
at
com.beasys.commerce.axiom.contact.security.RDBMSDelegate.init(RDBMSDelegate.
java:198)
at
com.beasys.commerce.axiom.contact.security.RDBMSDelegate.<init>(RDBMSDelegat
e.java:137)
at
com.beasys.commerce.axiom.contact.security.RDBMSDelegate$DFactory.newInstanc
e(RDBMSDelegate.java:975)
at weblogic.utils.reuse.Pool.getInstance(Pool.java:57)
at
com.beasys.commerce.axiom.contact.security.RDBMSRealm.getDelegate(RDBMSRealm
.java:147)
at
com.beasys.commerce.axiom.contact.security.RDBMSRealm.getUser(RDBMSRealm.jav
a:221)
at weblogic.security.acl.CachingRealm.getUserEntry(CachingRealm.java:1121)
at weblogic.security.acl.CachingRealm.getUser(CachingRealm.java:985)
at
com.beasys.commerce.axiom.contact.security.RealmLink.userExists(RealmLink.ja
va:64)
at
com.beasys.commerce.axiom.contact.UserManagerBean.doCreateUser(UserManagerBe
an.java:278)
at
com.beasys.commerce.axiom.contact.UserManagerBean.createUser(UserManagerBean
.java:218)
at
com.beasys.commerce.axiom.contact.UserManagerBeanEOImpl.createUser(UserManag
erBeanEOImpl.java:1187)
at
com.beasys.commerce.axiom.contact.UserManagerBeanEOImpl_ServiceStub.createUs
er(UserManagerBeanEOImpl_ServiceStub.java:811)
at
com.beasys.commerce.user.jsp.tags.CreateUserTag.doStartTag(CreateUserTag.jav
a:156)
at jsp_servlet._portal._userlogin._jspService(_userlogin.java:368)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:123)
at
weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImp
l.java:154)
at
com.beasys.commerce.foundation.flow.ServletDestinationHandler.handleDestinat
ion(ServletDestinationHandler.java:51)
at
com.beasys.commerce.foundation.flow.FlowManager.service(FlowManager.java:378
)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:123)
at
weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImp
l.java:761)
at
weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImp
l.java:708)
at
weblogic.servlet.internal.ServletContextManager.invokeServlet(ServletContext
Manager.java:252)
at
weblogic.socket.MuxableSocketHTTP.invokeServlet(MuxableSocketHTTP.java:346)
at weblogic.socket.MuxableSocketHTTP.execute(MuxableSocketHTTP.java:246)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:135)

Wed May 23 07:42:44 CEST 2001:<E> <WebAppServletContext-interim> Servlet
failed with Exception
java.lang.StringIndexOutOfBoundsException: String index out of range: 7
at java.lang.StringBuffer.charAt(StringBuffer.java:276)
at tabasco.utils.Formulaire.verifierListeDepartement(Formulaire.java:577)
at
tabasco.ProfilRecherche.Recherche.verifRechercheRapide(Recherche.java:743)
at
jsp_servlet._portal._interim._appl_recherche_rooter._jspService(_appl_recher
che_rooter.java:178)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:123)
at
weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImp
l.java:154)
at
com.beasys.commerce.foundation.flow.ServletDestinationHandler.handleDestinat
ion(ServletDestinationHandler.java:51)
at
com.beasys.commerce.foundation.flow.FlowManager.service(FlowManager.java:378
)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:123)
at
weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImp
l.java:761)
at
weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImp
l.java:708)
at
weblogic.servlet.internal.ServletContextManager.invokeServlet(ServletContext
Manager.java:252)
at
weblogic.socket.MuxableSocketHTTP.invokeServlet(MuxableSocketHTTP.java:346)
at weblogic.socket.MuxableSocketHTTP.execute(MuxableSocketHTTP.java:246)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:135)

bye


0 new messages