On Mar 5, 3:50 am, happytoday <[email protected]> wrote: > 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- Hide quoted text - > > - Show quoted text -
2 points 1) You dont show what you actually did to the config file. You told us what the documentation says you CAN do. 2) Did you remember to either restart oc4j or reboot your machine? I am guessing that you did but that you have somehow borked the config file. One of the primary ways to do this is open it in something like MS Word by accident. What you posted gave us no information on how to troubleshoot your problem. -- 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
