ISQL*PLUS SESSION PROBLEM

[Rui Cunha]

Hi,

i'm having some problems at work with isql*plus in what concerns with
session timeouts...

here is the scenario:
a class with 30/40 students working on PL/SQL and requesting the
database server for info.no client installation was made...they only
use the isqlplus tool via browser...

now for the problems:

problem1: after a couple of minutes, they start receiving "session
expired" messages...when they loggin again they face the 2nd problem:

problem2: some of them loose all data commited before the session
expire....

i tried to resolve problem1 editing isqlplus.conf file at the server
and setting session timeout parameter to OFF...no lucky....

i wonder if problem2 is related with problem1...

if any1 could help me out i'd be ver thankfull.

Thanks for all of your attention.

Best Regards,

Rui

[Daniel Morgan]

Rui Cunha wrote:
Hi,i'm having some problems at work with isql*plus in what concerns withsession timeouts...here is the scenario:a class with 30/40 students working on PL/SQL and requesting thedatabase server for info.no client installation was made...they onlyuse the isqlplus tool via browser...now for the problems:problem1: after a couple of minutes, they start receiving "sessionexpired" messages...when they loggin again they face the 2nd problem:problem2: some of them loose all data commited before the sessionexpire....i tried to resolve problem1 editing isqlplus.conf file at the serverand setting session timeout parameter to OFF...no lucky....i wonder if problem2 is related with problem1...if any1 could help me out i'd be ver thankfull.Thanks for all of your attention.Best Regards,Rui
It is not possible to help you with what you posted. Your interpretation
of an error
message is not helpful. Please post the actual error messages.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Rui Cunha]

Hi daniel,
thanks for your post...this is the error msg that we receive:

SP2-0864 Session has expired. Please log in again

PS1: we're using oracle 9.0.1 release...
PS2: hope this is more helpful :)

Best Regards,

Rui

Daniel Morgan <damorgan@x.washington.edu> wrote in message news:<1066831473.438552@yasure>... Rui Cunha wrote:Hi,i'm having some problems at work with isql*plus in what concerns withsession timeouts...here is the scenario:a class with 30/40 students working on PL/SQL and requesting thedatabase server for info.no client installation was made...they onlyuse the isqlplus tool via browser...now for the problems:problem1: after a couple of minutes, they start receiving "sessionexpired" messages...when they loggin again they face the 2nd problem:problem2: some of them loose all data commited before the sessionexpire....i tried to resolve problem1 editing isqlplus.conf file at the serverand setting session timeout parameter to OFF...no lucky....i wonder if problem2 is related with problem1...if any1 could help me out i'd be ver thankfull.Thanks for all of your attention.Best Regards,Rui It is not possible to help you with what you posted. Your interpretation of an error message is not helpful. Please post the actual error messages.

[Daniel Morgan]

Rui Cunha wrote:
Hi daniel,thanks for your post...this is the error msg that we receive:SP2-0864 Session has expired. Please log in againPS1: we're using oracle 9.0.1 release...PS2: hope this is more helpful :)Best Regards,RuiDaniel Morgan <damorgan@x.washington.edu> wrote in message news:<1066831473.438552@yasure>...Rui Cunha wrote:Hi,i'm having some problems at work with isql*plus in what concerns withsession timeouts...here is the scenario:a class with 30/40 students working on PL/SQL and requesting thedatabase server for info.no client installation was made...they onlyuse the isqlplus tool via browser...now for the problems:problem1: after a couple of minutes, they start receiving "sessionexpired" messages...when they loggin again they face the 2nd problem:problem2: some of them loose all data commited before the sessionexpire....i tried to resolve problem1 editing isqlplus.conf file at the serverand setting session timeout parameter to OFF...no lucky....i wonder if problem2 is related with problem1...if any1 could help me out i'd be ver thankfull.Thanks for all of your attention.Best Regards,RuiIt is not possible to help you with what you posted. Your interpretationof an errormessage is not helpful. Please post the actual error messages.
I don't recognize the message as an Oracle error and can find no
reference to it on metalink.

I'd suggest looking elsewhere for whatever is generating the message.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Pete Finnigan]

>>>I don't recognize the message as an Oracle error and can find noreference to it on metalink.I'd suggest looking elsewhere for whatever is generating the message.

HI Daniel and Rui,

The message is a SQL*Plus error message related to the iSQL*Plus timeout
Parameter. You need to set the iSQL*Plus timeout parameter. The time out
interval is set by the iSQLPlusTimeOutInterval initialization parameter
and defines the time a session can be idle before it is expired. You
need to edit the iSQL*Plus config file isqlplus.conf and change the
timeout value. The syntax of the line to change is:

FastCgiServer ... -initial-env iSQLPlusTimeOutInterval=n

where n is the number of minutes before the session times out.
iSQLPlusTimeOutInterval has a default of 30 minutes. It can be set to
any value from 1 to 1440 minutes.

hope this helps

Kind regards

Pete
--
Pete Finnigan
email:pete@petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

[Rui Cunha]

Mr Daniel Morgan,

you can search for this error at http://www.orafaq.com/supsearc.htm.
This is an isql*Plus error message...you can also take a look at
isql*Plus user's guide and reference....

Action: Reconnect to iSQL*Plus. The system administrator can configure
the timeout period.Ok, i configured the timeout period and the problem
persists...that's why i posted this msg...


anyway,thanks 4 ur attention,

Rui Cunha

Daniel Morgan <damorgan@x.washington.edu> wrote in message news:<1066861005.155417@yasure>... Rui Cunha wrote:Hi daniel,thanks for your post...this is the error msg that we receive:SP2-0864 Session has expired. Please log in againPS1: we're using oracle 9.0.1 release...PS2: hope this is more helpful :)Best Regards,RuiDaniel Morgan <damorgan@x.washington.edu> wrote in message news:<1066831473.438552@yasure>...Rui Cunha wrote:>Hi,>>i'm having some problems at work with isql*plus in what concerns with>session timeouts...>>here is the scenario:>a class with 30/40 students working on PL/SQL and requesting the>database server for info.no client installation was made...they only>use the isqlplus tool via browser...>>now for the problems:>>problem1: after a couple of minutes, they start receiving "session>expired" messages...when they loggin again they face the 2nd problem:>>problem2: some of them loose all data commited before the session>expire....>>i tried to resolve problem1 editing isqlplus.conf file at the server>and setting session timeout parameter to OFF...no lucky....>>i wonder if problem2 is related with problem1...>>if any1 could help me out i'd be ver thankfull.>>Thanks for all of your attention.>>Best Regards,>>Rui>>>>It is not possible to help you with what you posted. Your interpretationof an errormessage is not helpful. Please post the actual error messages. I don't recognize the message as an Oracle error and can find no reference to it on metalink. I'd suggest looking elsewhere for whatever is generating the message.

[Daniel Morgan]

Pete Finnigan wrote:
I don't recognize the message as an Oracle error and can find noreference to it on metalink.I'd suggest looking elsewhere for whatever is generating the message.HI Daniel and Rui,The message is a SQL*Plus error message related to the iSQL*Plus timeoutParameter. You need to set the iSQL*Plus timeout parameter. The time outinterval is set by the iSQLPlusTimeOutInterval initialization parameterand defines the time a session can be idle before it is expired. Youneed to edit the iSQL*Plus config file isqlplus.conf and change thetimeout value. The syntax of the line to change is:FastCgiServer ... -initial-env iSQLPlusTimeOutInterval=nwhere n is the number of minutes before the session times out.iSQLPlusTimeOutInterval has a default of 30 minutes. It can be set toany value from 1 to 1440 minutes.hope this helpsKind regardsPete
I'm surprised they don't have this on metalink. Thanks.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Pete Finnigan]

Hi Rui,

The isqlplus.conf file should be included in the oracle_apache.conf file
which in turn is included in httpd.conf si i guess any changes needs a
restart of apache to re-read the config files. Use $ $ORACLE_HOME/Apache
/Apache/bin/apachectl restart

kind regards

Pete
--
Pete Finnigan
email:pete@petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

[Pete Finnigan]

Hi Daniel,

yes it is strange, i just looked at the isqlplus docs.

kind regards

Pete

--
Pete Finnigan
email:pete@petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.