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 it. To
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 init.or
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
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 wha
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 editor
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 ...
My experience also on Win2K. 9.2.0.1.0 the file is editable. On 9.2.0.3.0
results are unpredictable if you edit the file. I guess that they really
don't want us editing it.
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
other
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 sola
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
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). Cou
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
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
I can definitely appreciate the benefits of dynamic parameters, and of being able to
persist the values of those parameters accross shutdown/startup cycles. But I would
have guessed that oracle could have gotten both of those features together without
going to a binary parameter file--couldn't
14 matches
Mail list logo