RE: FTP process exceeds ulimit as oracle user

Hi Gene,

>However, when FTP'ing using the oracle user id, it aborts at
>1gb. I guessed the ftp daemon used some other user id for
>this. Wrong ( well maybe). I changed the default limits to
>unlimited for all users (i.e. default) and deleted the oracle
>user id from /etc/security/limits file. Same problem, ftp
>process dies at 1gb. Now, I am trying to get the file rather
>than putting it. Lets see if this works?

Your workaround is correct. The reason why this errored out before is this : Root on the remote server receives a signal via inetd and starts up an 'ftpd' daemon under it's own account to serve you when you 'put' a file. This is configured in the /etc/inetd.conf file (diff path in AIX) by the following line:

ftp tli tcp nowait root /usr/etc/ftpd ftpd

$ ps -ef | grep ftpd

     root 28825 923 0 07:07:08 ? 0:00 ftpd <--- this does the job on the remote server

   oracle 28917 686 0 07:07:44 ttyAF/AFFL 0:00 grep ftpd

When 'root' started out, the inetd process which triggers the start of the ftpd inherits the previous limit of 1gb and hence you had this problem. To solve this permanently, you will need to run the command 'refresh -s inetd' as 'root' on AIX which restarts the inetd daemon.

Hth, (Hope this helps!)

John Kanagaraj

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).