Message-Id: <25956.338462@fatcity.com> From: "Jamadagni, Rajendra" Date: Fri, 18 Jul 2003 10:59:54 -0400 Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE 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. ------=_NextPartTM-000-c17bb36f-34af-4356-a77f-5ca056d1b9c4 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C34D3D.3F2A07AE" ------_=_NextPart_001_01C34D3D.3F2A07AE Content-Type: text/plain; charset="iso-8859-1" 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@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@oxhp.com ------_=_NextPart_001_01C34D3D.3F2A07AE Content-Type: text/html; charset="iso-8859-1" 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@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@oxhp.com

------_=_NextPart_001_01C34D3D.3F2A07AE-- ------=_NextPartTM-000-c17bb36f-34af-4356-a77f-5ca056d1b9c4 Content-Type: text/plain; name="ESPN_Disclaimer.txt" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="ESPN_Disclaimer.txt" ********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2