Re: what is the main problem with ORA-27050

On Thu, 17 Jan 2008 23:31:41 -0800, choubou wrote:

> Errors in file /oracle/admin/yoydb/bdump/yoydb1_diag_2449.trc:
> ORA-27050: function called with invalid FIB/IOV structure Additional
> information: 2
> ORA-27077: too many files open
> Thu Jan 17 19:40:43 2008
> Errors in file /oracle/admin/yoydb/bdump/yoydb1_diag_2449.trc:
> ORA-27050: function called with invalid FIB/IOV structure Additional
> information: 2
> ORA-27077: too many files open

I surmise that you might be having too many files open. You didn't specify the OS so I can't help you much. It doesn't look like the PEFAOS (Poor Excuse For An Operating System) like the one usually produced in the land of Redmond, WA, where the shadows lie. If it's Linux, you should take a look into /etc/security/limits.conf and make sure it contains something like this:

oracle           hard    nfile           65535
oracle           soft    nfile           65535

If it's another OS, consult the documentation or contact the vendor for help. If the helpdesk is outsourced, you're in for an experience.

--
Mladen Gogala
http://mgogala.freehostia.com