Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: "*." prefixes init.ora parms???

Re: "*." prefixes init.ora parms???

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Sun, 03 Sep 2006 00:47:37 GMT
Message-Id: <pan.2006.09.03.00.45.48.575979@gmail.com>


On Sat, 02 Sep 2006 11:06:47 -0400, Charles Davis wrote:

> Hello, all.
>
> I've been through Oracle docs on tahiti.oracle.com and I could not find the
> answer to this question.
>
> A vendor-supplied software package came with its own init.ora file in which
> every parm is prefixed with star-dot in column 1, such as '*.db_files =
> 200', without the quotes, of course.
>

The *.{parameter=[value]} notation was created to allow single init.ora in a RAC environment. In a RAC environment, the star implies all instances. In a non-RAC environment, the star simply translates to 'the instance'. Thus Oracle can achieve the same code regardless of installation.

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.
Received on Sat Sep 02 2006 - 19:47:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US