From: hume.spamfilter on
In comp.unix.solaris underh20 <underh20.scubadiving(a)gmail.com> wrote:
> Our server is running Solaris 10. We are in the processing of
> upgrading to Oracle 11G. An issue has come up regarding the hard
> limit (see below). The server has hard limit set to 65535
> and Oracle needs 65536. Is there any way, i.e., without reboot of
> server, to increase this
> value for the Oracle user during installation ?

First, check to see whether any of your login scripts are setting a limit.
A simple "unlimit descriptors" at the shell prompt on my machine (I use
tcsh) raises my descriptor limit to 65536.

Otherwise, try using /etc/project to raise the ou'll want to employ /etc/project and raise the value for your oracle
user. It's just like raising the max-shm-memory limit:

% grep oracle /etc/project
user.oracle:100:Oracle 11g:::process.max-file-descriptor=(privileged,128000,deny)

You'll have to log out and back in to get the new limit.

--
Brandon Hume - hume -> BOFH.Ca, http://WWW.BOFH.Ca/
From: underh20 on
Currently, no "ulimit descriptors" value is set at the user login
script. We are not using /etc/project
in general. However, we do notice that the following value exist in /
etc/system :

set rlim_fd_max = 65535

Could this be change to 65536 without reboot? We tried to issue the
following command at the oracle
user's shell prompt but to no avail.

$ ulimit -n 65536
/bin/ksh:ulimit: exceeds allowable limit

Any idea,

Thanks,

Bill
On Feb 3, 10:38 am, hume.spamfil...(a)bofh.ca wrote:
> In comp.unix.solaris underh20 <underh20.scubadiv...(a)gmail.com> wrote:
>
> >     Our server is running Solaris 10.  We are in the processing of
> > upgrading to Oracle 11G.  An issue has come up regarding the hard
> > limit (see below). The server has hard limit set to 65535
> > and Oracle needs 65536.  Is there any way, i.e., without reboot of
> > server,  to increase this
> > value for the Oracle user during installation ?
>
> First, check to see whether any of your login scripts are setting a limit..
> A simple "unlimit descriptors" at the shell prompt on my machine (I use
> tcsh) raises my descriptor limit to 65536.
>
> Otherwise, try using /etc/project to raise the ou'll want to employ /etc/project and raise the value for your oracle
> user.  It's just like raising the max-shm-memory limit:
>
> % grep oracle /etc/project
> user.oracle:100:Oracle 11g:::process.max-file-descriptor=(privileged,128000,deny)
>
> You'll have to log out and back in to get the new limit.
>
> --
> Brandon Hume    - hume -> BOFH.Ca,http://WWW.BOFH.Ca/

From: Stefan Krueger on
On 2010-02-03, underh20 <underh20.scubadiving(a)gmail.com> wrote:
> Currently, no "ulimit descriptors" value is set at the user login
> script. We are not using /etc/project
> in general. However, we do notice that the following value exist in /
> etc/system :
>
> set rlim_fd_max = 65535
>
> Could this be change to 65536 without reboot? We tried to issue the
> following command at the oracle
> user's shell prompt but to no avail.
>
> $ ulimit -n 65536
> /bin/ksh:ulimit: exceeds allowable limit
>
> Any idea,
>
> Thanks,
>
> Bill

you could try setting this value with mdb, i.e.

mdb -kw

and then

rlim_fd_max/W 0t65536

check with

rlim_fd_max/D

hope this helps
From: Casper H.S. Dik on
Stefan Krueger <stadtkind2(a)gmx.de> writes:

>you could try setting this value with mdb, i.e.

>mdb -kw

>and then

>rlim_fd_max/W 0t65536

>check with

>rlim_fd_max/D

>hope this helps

And use "plimit" on running processes.

Casper
--
Expressed in this posting are my opinions. They are in no way related
to opinions held by my employer, Sun Microsystems.
Statements on Sun products included here are not gospel and may
be fiction rather than truth.