bizarre Oracle problem

From: Vsevolod Afanassiev <vafanassiev_at_yahoo.com>
Date: 6 Oct 2005 20:06:55 -0700
Message-ID: <1128654415.834946.212520@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? Received on Thu Oct 06 2005 - 22:06:55 CDT