My Oracle Support Banner

Java.sql.SQLException: ORA-01012: Not Logged On ORA-02063 From Stored Procedure Calls (Doc ID 2743190.1)

Last updated on JANUARY 11, 2021

Applies to:

JDBC - Version 12.1.0.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.0.4 version, JAVA Virtual Machine Component

Intermitently, stored procedure call fails due to java.sql.SQLException: ORA-01012: not logged on ORA-02063: preceding line from ...
The next errors were found in the log file.

ERROR
-----------------------

<Test "SELECT 1 FROM DUAL" set up for pool "<POOL NAME>" failed with exception: "java.sql.SQLException: ORA-02399: exceeded maximum connect time, you are being logged off".>
<Test "SELECT 1 FROM DUAL" set up for pool "<POOL NAME>" failed with exception: "java.sql.SQLException: ORA-02399: exceeded maximum connect time, you are being logged off".>
...
<Test "SELECT 1 FROM DUAL" set up for pool "<POOL NAME>" failed with exception: "java.sql.SQLException: ORA-02399: exceeded maximum connect time, you are being logged off".>
<Test "SELECT 1 FROM DUAL" set up for pool "<POOL NAME>" failed with exception: "java.sql.SQLException: ORA-02399: exceeded maximum connect time, you are being logged off".>
...
<JCA_FRAMEWORK_AND_ADAPTER> < Fast classification of SQLState: 72000 errorCode: 1012 message: ORA-01012: not logged on
ORA-02063: preceding line from ...
 is unknown
>
<JCA_FRAMEWORK_AND_ADAPTER> < connection.isValid classification of SQLState: 72000 errorCode: 1012 message: ORA-01012: not logged on
ORA-02063: preceding line from ...
 is retriable
>
...

at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1494)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: java.sql.SQLException: ORA-01012: not logged on
ORA-02063: preceding line from

 




Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.