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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE

RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE

From: Molina, Gerardo <Gerardo.Molina_at_schwab.com>
Date: Fri, 18 Jul 2003 08:16:15 -0700
Message-Id: <25956.338467@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C34D3F.87EF3E6C
Content-Type: text/plain

one spfile for all instances.  

you use alter system but there is a sid= parameter that allows for instance granularity.  

For example,  

to affect all instances:  

alter system set db_cache_size = 500m scope=both sid=*;  

or to affect one:  

alter system set db_cache_size = 500m scope=both sid=<instance_1>;  

You can also specify a list of instances.  

If you don't specify any sid, then I believe it affects instance you're connected to only.  

Gerardo  

-----Original Message-----
From: Jamadagni, Rajendra [mailto:Rajendra.Jamadagni_at_espn.com] Sent: Friday, July 18, 2003 8:59 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE

Our spfile is shared by all instances in the RAC ...

Raj




Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
From: Gogala, Mladen [mailto:MGogala_at_oxhp.com <mailto:MGogala_at_oxhp.com> ] Sent: Friday, July 18, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE

SPFILE is instance specific, modified by "alter system", not by "alter database". That means that RAC doesn't affect it. You can try with raw device for the pfile, if you can do something like "vi /dev/rdsk/c0d1s2" (I hate ###@$!### Emacs). If you can, please let me know which system allows that.

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:mgogala_at_oxhp.com

------_=_NextPart_001_01C34D3F.87EF3E6C
Content-Type: text/html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>

<META content="MSHTML 6.00.2716.2200" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff size=2>one
spfile for all instances.</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff size=2>you
use alter system but there is a sid= parameter that allows for instance granularity.</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff size=2>For
example,</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff size=2>to
affect all instances:</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff size=2>alter
system set db_cache_size = 500m scope=both sid=*;</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff size=2>or to
affect one:</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff size=2>alter
system set db_cache_size = 500m scope=both sid=&lt;instance_1&gt;;</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff size=2>You
can also specify a list of instances.</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff size=2>If you
don't specify any sid, then I believe it affects instance you're connected to only.</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2>Gerardo</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN>&nbsp;</DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
  <DIV></DIV>
  <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT   face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Jamadagni,   Rajendra [mailto:Rajendra.Jamadagni_at_espn.com] <BR><B>Sent:</B> Friday, July   18, 2003 8:59 AM<BR><B>To:</B> Multiple recipients of list   ORACLE-L<BR><B>Subject:</B> RE: Why are SPFILEs binary anyway? (was RE: How to   make SPFILE<BR><BR></FONT></DIV>

  <P><FONT size=2>Our spfile is shared by all instances in the RAC ... 
  </FONT></P>
  <P><FONT size=2>Raj</FONT> <BR><FONT 
  size=2>--------------------------------------------------------------------------------</FONT> 
  <BR><FONT size=2>Rajendra dot Jamadagni at nospamespn dot com</FONT> <BR><FONT   size=2>All Views expressed in this email are strictly personal.</FONT>   <BR><FONT size=2>QOTD: Any clod can have facts, having an opinion is an art   !</FONT> </P><BR>
  <P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From:   Gogala, Mladen [<A
  href="mailto:MGogala_at_oxhp.com">mailto:MGogala_at_oxhp.com</A>]</FONT> <BR><FONT   size=2>Sent: Friday, July 18, 2003 11:49 AM</FONT> <BR><FONT size=2>To:   Multiple recipients of list ORACLE-L</FONT> <BR><FONT size=2>Subject: RE: Why   are SPFILEs binary anyway? (was RE: How to make SPFILE</FONT> </P><BR>   <P><FONT size=2>SPFILE is instance specific, modified by "alter system",   not</FONT> <BR><FONT size=2>by "alter database". That means that RAC doesn't   affect it. </FONT><BR><FONT size=2>You can try with raw device for the pfile,   if you can do something</FONT> <BR><FONT size=2>like "vi /dev/rdsk/c0d1s2" (I   hate ###@$!### Emacs). If you can, </FONT><BR><FONT size=2>please let me know   which system allows that.</FONT> </P>
  <P><FONT size=2>Mladen Gogala</FONT> <BR><FONT size=2>Oracle DBA</FONT>   <BR><FONT size=2>Phone:(203) 459-6855</FONT> <BR><FONT Received on Fri Jul 18 2003 - 10:16:15 CDT

Original text of this message

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