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@xxxxxxxxx> 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@fsh1166db01 sybase]$ whoami > sybase > [sybase@fsh1166db01 sybase]$ ulimit -n > 1024 > [sybase@fsh1166db01 sybase]$ ulimit -n 4090 > -bash: ulimit: open files: cannot modify limit: Operation not permitted > [sybase@fsh1166db01 sybase]$ su - sybase > Password: > [sybase@fsh1166db01 sybase]$ ulimit -n > 1024 > [sybase@fsh1166db01 sybase]$ ulimit -n 4090 > [sybase@fsh1166db01 sybase]$ ulimit -n > 4090 > [sybase@fsh1166db01 sybase]$ > > Regards, Marshall > > -----Original Message----- > From: Joe Hood [mailto:joe.hood@xxxxxxxxx] > 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@xxxxxxxxx> 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@fsh1166db02 sybase]$ ulimit -n > > 1024 > > [sybase@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@fsh1166db02 sybase]$ su - sybase > > Password: > > [sybase@fsh1166db02 sybase]$ ulimit -n 2048 > > [sybase@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@xxxxxxxxxx?subject=unsubscribe > > https://www.redhat.com/mailman/listinfo/redhat-list > > > > -- > redhat-list mailing list > unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe > https://www.redhat.com/mailman/listinfo/redhat-list > -- redhat-list mailing list unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list
