Path: utzoo!utgpu!jarvis.csri.toronto.edu!rutgers!usc!gem.mps.ohio-state.edu!tut.cis.ohio-state.edu!bloom-beacon!eru!luth!sunic!mcsun!ndosl!fdmetd!steinar
From: steinar@fdmetd.uucp (Steinar Overbeck Cook)
Newsgroups: comp.databases
Subject: Re: SIGTERM, SIGINT from ORACLE's shadow process.
Keywords: SIGTERM SIGINT ORACLE daemons
Message-ID: <744@fdmetd.uucp>
Date: 27 Oct 89 13:15:37 GMT
References: <88461@pyramid.pyramid.com>
Reply-To: steinar@fdmetd.UUCP (Steinar Overbeck Cook, Fellesdata a.s)
Organization: Fellesdata a.s, Oslo, NORWAY
Lines: 52

In article <88461@pyramid.pyramid.com> cgd@pyrps5.pyramid.com (Greg Doherty) writes:
  [.... text deleted. ....]

>
>It seems to me that your problem may be in closing all open file descriptors
>in your server.  
>
No, I close all files, *before* I connect to the Oracle database :-).

The following piece of pseudo code shows in brief what happens:
	
	main(....)
		.
		.
	pid = fork();		/* Don't want to be group leader */
	if (pid != 0)
		exit(0);        /* Parent terminates    */
	setpgrp();  /* Loose controlling terminal & change process group */
	pid = fork();
	if (pid != 0)   /* Become non-pgrp-leader                    */
		exit(0);    /* First child                               */
	for (fd=0; fd < _NFILE; fd++) 	/* Close all open files */
		close(fd);
    chdir("/"); /* Move current directory of mounted filesystem      */
    umask(0);   /* clear any inherited file mode creation mask       */
	
	CONNECT TO ORACLE;
	for(;;){
		get_request_from_client();
		when a certain request comes along{
			fork(); 
			exec("delta .......");  
			       ......      <======HERE COMES SIGTERM !!!
		}
	}


Does anybody have a good suggestion on why I get SIGTERM in cases like
this ?

>In order to get SIGTERM flying around between Oracle clients and servers
>you would have to explicitly set the environment variable "TWO_TASK" to
>"P:,O", so you can probably eliminate SIGTERM to your server as a cause
>for termination, unless you're using O-O-B BREAK..
                                       ^
What does this mean ? ------------------

-- 
Steinar Overbeck Cook, Fellesdata a.s, P.O. Box 248, 0212 OSLO 2, NORWAY
Phone : +47 2 52 80 80                            Fax   : +47 2 52 85 10
E-mail : ...!mcvax!ndosl!fdmetd!steinar  or       steinar@fdmetd.uucp
<The opinions expressed, if any, do not represent Fellesdata a.s>