Re: ISQL*PLUS SESSION PROBLEM

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_at_x.washington.edu> wrote in message news:<1066861005.155417_at_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 again
> >
> >PS1: we're using oracle 9.0.1 release...
> >PS2: hope this is more helpful :)
> >
> >Best Regards,
> >
> >Rui
> >
> >Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1066831473.438552_at_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 interpretation
> >>of an error
> >>message 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.
Received on Thu Oct 23 2003 - 11:37:26 CEST