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@xxxxxxxxxxxx www.proquest.com www.csa.com ProQuest...Start here. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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? > -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l