Re: bizarre Oracle problem

"Vsevolod Afanassiev" <vafanassiev_at_yahoo.com> wrote in message news:1128654415.834946.212520_at_z14g2000cwz.googlegroups.com...
> 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?
>

Do you have multiple identical enties in your init.ora file ? Or maybe you are looking at the wrong init.ora file ?

Matthias Received on Fri Oct 07 2005 - 08:21:29 CDT