Re: bizarre Oracle problem

Vsevolod Afanassiev wrote:
> We have observed bizzare Oracle problem: when reading init.ora on
> startup Oracle would ignore all but first value for multi-valued
> parameters like CONTROL_FILES and ROLLBACK_SEGMENTS. This is reflected
> in alert.log.
>
> For example, init.ora says:
> rollback_segments = (rb01, rb02, rb03)
> but alert.log shows
>
> rollback_segments = rb01
>
> so this segment is brought online while RB02 and RB03 remain offline.
> There is nothing wrong with RB02 and RB03 and they could
> be brought online manually.
>
> Similar thing happened with control files: init.ora says
>
> control_files = (/u01/oracle/PROD/control01.ctl,
> /u02/oracle/PROD/control02.ctl,
> /u03/oracle/PROD/control03.ctl)
>
> But alert.log shows
>
> control_files = /u01/oracle/PROD/control01.ctl
>
> So the database starts but runs with only one control file.
> There are no errors in alert.log on startup.
>
> This is 8.1.7.4.0 on HP-UX 11.0
>
> Have anyone seen something similar?

Have you verified that the init.ora you are looking at is the same one Oracle is reading? I'd suggest making a totally bizarre change such as commenting out the 'rollback_segments =' you have and adding rollback_segments=rb999.

If it starts up you are definitely looking in the wrong place.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)