Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Session auto killed after a period Inactive

Session auto killed after a period Inactive

From: Kjell Ove Skarsbø <kjellove_at_nivi.no>
Date: 19 Aug 2003 01:01:07 -0700
Message-ID: <8ca30c79.0308190001.22fb3bfd@posting.google.com>


A batch job is scheduled to run at 02:00 AM every night taking a hot backup off database. It puts one and one tablespace into backup mode and copies their datafiles to backup area. This is done on NT 4.0 so the sceduler used is AT.
The job fails after putting the larges tablespace into backup, and while copying this tablespace datafiles (8 x 2GB) somehow the database session is killed. So after finishing the copying, an "ORA-00028, Your session has been killed" is recieved when tablespace is attempted to be changed from backup mode to normal mode. Obviousely, the datafiles that are copied after this are useless because datafiles are open when tablespace failes to be taken into backup mode with error "user not logged on" and datafiles are anyway copied to backuparea independent of session status. When batch job is run via terminal server during daytime it succeeds without any problems. Is there a parameter for how long session should be inactive before killed?

Rgds

Kjell Ove Received on Tue Aug 19 2003 - 03:01:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US