My guess is that a binary SPFILE is expected to look the same whether it is a
Raw Device [non-CFS RAC] or on a File System [CFS RAC or Single Instance
database].
You should be able to do a dd of the SPFILE to move it between Raw and
FileSystems.
Thus you can take the SPFILE of a non-CFS RAC and
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 [EMAIL PROTECTED] Emacs). If you can,
please let me know which system allows
Title: 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
:59 AMTo: Multiple recipients of list
ORACLE-LSubject: 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
can have facts, having an opinion is an art !
-Original Message-From: Molina, Gerardo
[mailto:[EMAIL PROTECTED]Sent: Friday, July 18, 2003 12:15
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Why are SPFILEs binary anyway? (was RE: How to make
SPFILE
one
spfile
Roy,
I imagine its so that it can only be changed by someone who is validated against the
database with the correct permissions.
Kind Regards,
Adrian
-Original Message-
Sent: 16 July 2003 23:40
To: Multiple recipients of list ORACLE-L
sync with INIT.ORA ?)
I can definitely appreciate
it's a fake sort of binary -- try editing it with vi and then try
opening your database with the spfile... but first make an init.ora
copy of it.
There is some sort of checksum going on, even though it looks like
ASCII
--- Jamadagni, Rajendra [EMAIL PROTECTED] wrote:
it isn't binary on solaris
I wonder if it is something built into the file or something that vi (or
whatever editor you are using) does to the file when you save it. I say
that because, if you edit the text part of an export file with vi, you get
an unusable file. But the text part of an export file can be edited by
]
kirtikumar_desh cc:
pandeSubject: RE: Why are SPFILEs binary
anyway? (was RE: How to make SPFILE in
@yahoo.com
Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
Hey,
don't blame oracle for that ... did you complain to Microsoft when they created that Registry hive cr*p ?? Oracle is stepping on the same line ...
Lemmings ...
g
Raj
That's a good point. Someone should try a binary editor instead,
like bvi and see what happens.
-Original Message-
Sent: Thursday, July 17, 2003 10:45 AM
To: Multiple recipients of list ORACLE-L
in
I wonder if it is something built into the file or something that vi (or
whatever
Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
Questin is why do you want to mess with it? That's not exactly my idea of fun ...
I'd still use alter system, alter database commands to change whatever.
Raj
Why would you want to do that? You can always re-create the file
from your PFILE. Oracle should have encrypted it.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, July 17, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L
in
Editing spfile is not supported by Oracle. And I think it is documented as such.
You can just view it, copy it and play with the copied version what whatever...
One thing to remeber is to always hold on to the init.ora version. No matter what. Or
at least
until Oracle completely removes
Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
Of
course you are right that no one should use it as the right way to change
parameters.
I will
admit playing with binary file some times is my idea of fun. Hey, you
never know,
you
might learn something from
Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in sync with INIT.ORA ?)
it isn't binary on solaris ... pure text ...
Raj
-Original Message-
From: Pardee, Roy E [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 16, 2003 6:40 PM
To: Multiple recipients of list
Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in sync with INIT.ORA ?)
Not true; it's binary, on both Solaris 8 and 9. By
the most of the file (regardless of the OS) is still text; the non-ascii chars
are present at the beginning of the file.
Arup Nanda
Keeping them binary gives them power I guses...
On most platforms there is just a hashed value on the first line.
In 9i R1 (9.0.1), I was able to replace some param value without changing number of
chars on the
line, and the changes were taken without any problem (HP-UX 11, it was I think).
18 matches
Mail list logo
