I tried what is written but I could not open the login screen again after editing that file web.xml
Setting the Session Time Out ------------------------------- Timing out iSQL*Plus sessions helps to reduce machine load and to maximize resources. The time out interval is set by the session- timeout element. It defines the time a session can be idle before it is expired. You need to stop the iSQL*Plus Application Server to make changes to the session-timeout element. You can edit the web.xml configuration file to change the timeout interval. The web.xml file is located in the directory: $ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/isqlplus/ isqlplus/WEB-INF In the web.xml file, search for the <session-timeout> element inside <session-config>. The syntax of the line to change in the configuration file is: <session-config> <session-timeout>15</session-timeout> </session-config> Where the value is the number of whole minutes of idle time before the session times out. It has a default value of 15 minutes. It can be set to any value from 1 to 1440 minutes. It can also be set to never expire by entering a negative value such as -1. It should not be set so small that users do not get a chance to enter their scripts. When a user tries to use a timed out iSQL*Plus session, the Login screen is displayed and the user is prompted to log in again. The following error is displayed: SP2-0864: Session has expired. Please log in again. On Mar 3, 6:50 pm, Rob Wolfe <[email protected]> wrote: > On Mar 3, 10:35 am, happytoday <[email protected]> wrote: > > > When I leave the Workspace of Enter SQL, PL/SQL and SQL*Plus > > statements > > a certain amount of time I should relogin again with scott and tiger. > > How can I fix this ? > > Restating the question with a different title is not in general going > to get you a different answer. > > I am assuming (yes, dangerous I know) that you are using iSQL (or > something closely related embedded in OEM) when you are saying > "Workspace of Enter SQL, PL/SQL and SQL*Plus". It does indeed timeout > after a set period of time that your DBA can set for you in one of the > configuration files. I forget what the parameter is or which of the 50 > xml config files it is in but it would be in the documentation under > something like session-timeout (not the name of the entry, just that > is is something LIKE that). > > I am actually more concerned that you speak of logging in using scott/ > tiger. That login really shouldn't be used to do anything too > strenuous. You should get a proper account set up, even if you are > just doing elementary things. > > Rob -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
