Subject: ORA-02396 when idle_time = unlimited

Subject: ORA-02396 when idle_time = unlimited

RDBMS Version: 8.0.6.2.0
Operating System and Version: Solaris 2.6
Error Number (if applicable): ORA-02396
Product (i.e. SQL*Loader, Import, etc.): RDBMS
Product Version:

ORA-02396 when idle_time = unlimited

Hi,

My application has permanent connection to the database
thru dedicated server and issue SQL statement each 10 min.
The user account for this application has DEFAULT profile
and idle_time=unlimited.
The application has log file:

30-11-2000 23:30:15 execute SQL3 is OK
30-11-2000 23:40:15 execute SQL3 is OK
30-11-2000 23:50:16 execute SQL3 is OK
01-12-2000 00:00:16 Error while execute SQL3: ORA-02396: exceeded maximum idle time, please connect again (DBD/
ERROR: OCIStmtExecute)
Send email to pager 51102.
01-12-2000 00:00:18 Disconnect from dbi:Oracle:prod is okay
01-12-2000 00:00:19 Connected to dbi:Oracle:prod successfuly
01-12-2000 00:00:20 execute SQL3 is OK

Could you please explain why ORA-02396 received ?

We have resource_limit=true in the init.ora and profile
with idle_time=180 for other application users but this
user has no limitation.




Any comments would be appreciated.

Thank you in advance,
Boris Pishchick

---

From: Oracle, Reem Munakash 06-Dec-00 16:45
Subject: Re : ORA-02396 when idle_time = unlimited

The only report of ORA-02396 occurring with UNLIMITED idle_time is related to connecting through MTS. Double check your DEFAULT profile to make sure it is indeed set to UNLIMITED. If it is, we would need a reproducible test case.

Reem Munakash
Electronic Support

---

From: Daphne Clanton 19-Dec-00 20:59
Subject: Re : ORA-02396 when idle_time = unlimited

Reem,

We are having the same problem and we are running MTS. How can I stop this from happening?

Daphne Clanton

---

From: Oracle, Helen Schoone 22-Dec-00 14:35
Subject: Re : Re : ORA-02396 when idle_time = unlimited

Hi. Reem is out of the office. You do not mention your RDBMS version or platform. The confirmed report of this error related to MTS effected Oracle7 and was fixed in 7.3.3. Another report in Oracle8 was not reproducable by the customer.

As recommended by Reem, double check the profile limits and ensure that idle_time is set to unlimited. If it is, we would need a reproducable testcase.

Regards,
Helen
Oracle Support Services

---

From: John Donaldson 09-Jan-01 23:54
Subject: Re : ORA-02396 when idle_time = unlimited

Hi,
We're receiving the same problem. RESOURCE_LIMIT = TRUE,
and the IDLE_TIME = 66 in the default profile. Yet whenever a user connects they get disconnected after less than 1 minute. The only way to stop getting ORA-02396 is to set IDLE_TIME = UNLIMITED . This is not an acceptable solution for us.

---

From: Oracle, Helen Schoone 10-Jan-01 12:18
Subject: Re : Re : ORA-02396 when idle_time = unlimited

Hi. Per information in the iTAR referenced in your e-mail, a bug (1378168) has been identified. This bug is port-specific to Linux and is fixed in the 8.1.6.3 patchset release. There is also an individual patch which can be applied to 8.1.6.1.

It is best to use only one form of Support. That way we are not duplicating efforts and asking for the same information. As you have an iTAR open with support on this issue, I recommend you continue work with them.

Regards,
Helen
Oracle Support Services