Re: ISQL*PLUS SESSION PROBLEM
Date: Thu, 23 Oct 2003 10:37:23 +0100
Message-ID: <DdE89dBTF6l$EwtG_at_peterfinnigan.demon.co.uk>
>>>
>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.
>
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_at_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.Received on Thu Oct 23 2003 - 11:37:23 CEST