Ulimit command only works after su

[Joe Hood]

Try putting user sysbase into a particular group (the "@dba" refers to
the "dba" group):

@dba  hard    nofile  65535
@dba    hard    nproc   16384

I just did this to a fresh Oracle install and it works (AS 3.0).

In .bash_profile for the user I have:

# file handles and file desc max
ulimit -n 63536
ulimit -u 16384


On 5/13/05, McDougall, Marshall (FSH) <MarMcDouga at gov.mb.ca> wrote:
> OK I finally got back to this and no matter what I put in the limits.conf, I
> still must su to the same user that I log in as in order to change the
> ulimit parms.  It's really not making any sense.
> 
> [sybase at fsh1166db01 sybase]$ whoami
> sybase
> [sybase at fsh1166db01 sybase]$ ulimit -n
> 1024
> [sybase at fsh1166db01 sybase]$ ulimit -n 4090
> -bash: ulimit: open files: cannot modify limit: Operation not permitted
> [sybase at fsh1166db01 sybase]$ su - sybase
> Password:
> [sybase at fsh1166db01 sybase]$ ulimit -n
> 1024
> [sybase at fsh1166db01 sybase]$ ulimit -n 4090
> [sybase at fsh1166db01 sybase]$ ulimit -n
> 4090
> [sybase at fsh1166db01 sybase]$
> 
> Regards, Marshall
> 
> -----Original Message-----
> From: Joe Hood [mailto:joe.hood at gmail.com]
> Sent: Monday, May 09, 2005 12:15 PM
> To: General Red Hat Linux discussion list
> Subject: Re: Ulimit command only works after su
> 
> @dba hard nofile 65535
> @dba hard nproc 16384
> @oaa hard nofile 65535
> @oaa hard nproc 16384
> 
> is how Oracle recommends (with groups instead of users), I'm sure
> Sybase is similar.
> 
> Also, you have "Sybase" as a user with a capital first letter.
> 
> On 5/9/05, McDougall, Marshall (FSH) <MarMcDouga at gov.mb.ca> wrote:
> > RH ES2.1,  2.4.21-15.ELsmp
> >
> > I am trying to give our DBA the ability to test his Sybase installation
> with
> > various parm changes, one of which is "ulimit -n".  I have added:
> >
> > Sybase       soft    nofile  3072
> > Sybase       hard    nofile  4096
> >
> > to the /etc/security/limits.conf file and that sort of works.  I say sort
> of
> > because if I log in as Sybase and execute ulimit -n 2048 I get:
> >
> > [sybase at fsh1166db02 sybase]$ ulimit -n
> > 1024
> > [sybase at fsh1166db02 sybase]$ ulimit -n 2048
> > -bash: ulimit: open files: cannot modify limit: Operation not permitted
> >
> > Then if I "su - sybase" and do it again, it works:
> >
> > [sybase at fsh1166db02 sybase]$ su - sybase
> > Password:
> > [sybase at fsh1166db02 sybase]$ ulimit -n 2048
> > [sybase at fsh1166db02 sybase]$ ulimit -n
> > 2048
> >
> > It's not making a lot of sense to me.  Any enlightenment appreciated.
> >
> > Regards, Marshall
> >
> > --
> > redhat-list mailing list
> > unsubscribe mailto:redhat-list-request at redhat.com?subject=unsubscribe
> > https://www.redhat.com/mailman/listinfo/redhat-list
> >
> 
> --
> redhat-list mailing list
> unsubscribe mailto:redhat-list-request at redhat.com?subject=unsubscribe
> https://www.redhat.com/mailman/listinfo/redhat-list
>