cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Forms 6i

PRDEEP
Occasional Contributor

Oracle Forms 6i

Dear All,

I have an application in Oracle forms and reports 6i and database 10g release2.
If the clients login the applicatin leave it idle for 30 minutes ( for taking coffee or over telephone)the application is stuck and it need to close and relogin again.
to avoid the re-login, could you please find solution.
5 REPLIES
Aneesh Mohan
Honored Contributor

Re: Oracle Forms 6i

Hi Prdeep,

It seems you have to increase session timeout in sqlnet.ora

example :-
NAMES.CONNECT_TIMEOUT = 600

*** Time mentioned is in second****

Thanks,
Aneesh
Steven E. Protter
Exalted Contributor

Re: Oracle Forms 6i

Shalom,

The configuration of forms 6i (pretty old, I worked with it back in 2002) to increase the time out.

Though 30 minutes is adequate for most applications.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Steven E. Protter
Exalted Contributor

Re: Oracle Forms 6i

Shalom,

Sorry, I slammed enter too early.

This could be a problem with database idle time as well. It should be adjusted.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
T G Manikandan
Honored Contributor

Re: Oracle Forms 6i

YOu need to closely see whether they are just connecting to Forms or they are connecting to database.

If they are connecting to database

The FORMS_TIMEOUT parameter set in the defaults.env environmental variable for to fix timeout issues.

If it is a FRM-XXX error its forms and if its ORA- error its oracle database. Please check.
PRDEEP
Occasional Contributor

Re: Oracle Forms 6i

Thanks,

Now I want to know how to set the FORMS_TIMEOUT in Oracle forms 6i