Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
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