Re: oracle error 12154 on SUN server

On Tue, 09 Jun 1998 18:27:27 GMT, vicengle_at_my-dejanews.com <vicengle_at_my-dejanews.com> wrote:
>If anyone is seeing this error on a Sun server running
>Solaris 2.x, check /etc/system file and verify that there
>are entries to set max open files soft limit to 256. By default
>it is 64. Ulimit -a will display what the system is currently
>set for. The lines
>
>set rlim_fd_max = 1024
>set rlim_fd_cur = 256

I'm on 2.6, 7.3.4. I note that these are not in my /etc/system, and a ulimit -n appears to say it is 64:

        nofiles(descriptors) 64

However, monitoring oracle with proctool, I noticed that:

        dbwr has 37 files open.

        the process thinks it's limit is 4G on file descriptors.

This says to me that oracle or solaris figured this out. I'm not sure where, and assume that proctool on the running process is more relevent than ulimit on the oracle environment. Thanks for the heads-up, anyways. YMMV.

>
>should appear near the end of the file and the system has
>to reboot after adding these lines. The 12154 error means that
>a service name could not be resolved. We were experiencing
>this error when our server attempted to open more than the default
>limit of 64 files, possibly because it could no longer open
>the tnsnames.ora file. When the open file limit was increased
>as described above all was well.
>
>Vic Engle
>victor.engle_at_delta-air.com
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading

--
These opinions are my own and not necessarily those of Information Quest

or Pebble In The Sky                     http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry jgarry@nospameiq.com
"See your DBA?"  I AM the @#%*& DBA!     Remove nospam to reply.  Sorry.