Oracle Forms 6i

[PRDEEP]

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.

[Aneesh Mohan]

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]

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]

Shalom,

Sorry, I slammed enter too early.

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

SEP

[T G Manikandan]

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]

Thanks,

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