Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Resolved ORA-27302 error, but how to fix?

Re: Resolved ORA-27302 error, but how to fix?

From: Mary <mbahrami_at_seattletimes.com>
Date: 25 Feb 2005 07:55:50 -0800
Message-ID: <1109346949.990578.156400@f14g2000cwb.googlegroups.com>

ohaya wrote:
> Hi,
>
> I have Oracle 9i running on a Solaris 9 system. Yesterday, when
trying
> to startup one of the database instances using OEM, I was getting an
> ORA-27302 error (along with some others). There was also an
ORA-27301
> error among them.
>
> I tried to diagnose the problem, checking disk space, etc., but that
> looked ok. Since the instance wasn't even started, I couldn't even
look
> at the parameters, etc.
>
> Just on a hunch (and some desparation), I shutdown several of the
other
> test instances that I noticed were running, and tried to startup the
> instance I wanted, and I was surprised to find that it started up ok.
>
> I gather that the original problem actually was due to Oracle running
> out of some resource, but I'm wondering if anyone can tell me how do
I
> track down which one or ones need to be increased?
>
> I know that the system/kernel parameters were configured per the
Oracle
> installation guide.
>
> Do I just bump ALL of the parameters up, hoping that that fixes the
> situation?
>
> Thanks in advance,
> Jim
Received on Fri Feb 25 2005 - 09:55:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US