Re: Asterisks in init.ora parameters

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: paul.baumgartel@xxxxxxxxx
  • Date: Tue, 27 Sep 2005 19:45:10 +0100

You are absolutely correct. * means all instances
instance_name.parameter means just the named instance.

On 9/27/05, Paul Baumgartel <paul.baumgartel@xxxxxxxxx> wrote:
>
> CREATE PFILE FROM SPFILE produces this format. I think the * is meaningful
> in RAC systems where instances might share a pfile, and the * means the
> value is valid for all instances. Correct me if I'm wrong, anyone!
>
> On 9/27/05, Adams, Matthew (GE Consumer & Industrial) <MATT.ADAMS@xxxxxx>
> wrote:
> >
> >
> > Anybody ever seen a init.ora file in an init.ora file that looks like
> >
> > *.db_block_size=8192
> > *.db_cache_size=256M
> >
> > etc?
> >
> > I've never seen an asterisk and period at the beginning of a init.oraline 
> > before.
> >
> > I know this is not a spfile, because 'alter system .... scope=spfile'
> > command get ORA-32001 errors.
> >
> > What is the significance of the asterisk and period?
> >
> >
> > --
> > //www.freelists.org/webpage/oracle-l
> >
>
>
>
> --
> Paul Baumgartel
> paul.baumgartel@xxxxxxxxxxxx
>
>


--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

Other related posts: