RE: Errors when running dbms_stats.gather_fixed_object_stats

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Tue, 25 Mar 2008 15:52:58 -0400
Message-ID: <667C10D184B2674A82068E06A78382B51DB88804@AAPQMAILBX01V.proque.st>


Ah...ok....then I think I'm (at least) as confused as you are.

CSS is required for RAC, and for single-instance, if you're using ASM. 10.2.0.3 single-instance w/o ASM should not require CSS.

Painful as it can be, I think it's time to open a tar....

-Mark

--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x 4059
mark.bobak_at_proquest.com
www.proquest.com
www.csa.com

ProQuest...Start here.


-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Maureen English
Sent: Tuesday, March 25, 2008 3:21 PM
To: Bobak, Mark
Cc: Oracle-L Freelists
Subject: Re: Errors when running dbms_stats.gather_fixed_object_stats

Mark,

I seem to have left out that I found the same information you
refer to.  My problem is that we are not using ASM.  So, no,
we're not running css, but I see no reason to be running it.

Did I miss something critical here?  We installed 10.2.0.2.0 in
a new ORACLE_HOME, patched to 10.2.0.3.0, and definitely ran all
of the root scripts after the installation.  We've applied the
cpuoct2007 and cpujan2008 patches, as well as 2 other recommended
Oracle patches to fix problems we've encountered.

The gather_fixed_objects_stats procedure completes successfully:

> SQL> exec dbms_stats.gather_fixed_objects_stats;
>
> PL/SQL procedure successfully completed.
>
> SQL>
- Maureen Bobak, Mark wrote:
> "Rediscovery:
>
> When CSS/HAS is not installed and executed and v$asm_diskgroup
> or similar ASM queries are issued with excessive logs in trace
> files complaining about OCR not ready and/or CSS not running,
> customers then have the issue.
>
> Workaround:
>
> Run CSS"
>
> So, are you running CSS?
>
> Do:
> ps -ef|grep css
>
> Do you see css running? If not, why not? CSS is required, even for single-instance ASM. Did you run all the root.sh scripts at the appropriate times (and as root) during the installation?
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 25 2008 - 14:52:58 CDT

Original text of this message