Re: Oracle 9.2 changes in INIT
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 7 Jun 2004 17:03:11 +0100
Welcome to the wonderful world of the SPFILE discussed here recently.
There is a nice explanation at http://www.dizwell.com but to answer
your question
ALTER SYSTEM has acquired some new functionality. You can now issue
ALTER SYSTEM SET <parameter> = <value> SCOPE=<SCOPE>;
where parameter is the parameter for example OPEN_CURSORS, value is
the new value you want for example 500 and scop takes one of MEMORY
which means make the change just to the currently running instance ,
SPFILE which means make the change to the SPFILE making it persistent
or BOTH which fairly obviously means do both of these.
It also takes COMMENT= and then a comment so that you can document
your changes, but obviously this option is almost never used :( .
I don't like them much but they do have a bunch of advantages
(principally as a mechanism for self tuning and for RAC) and get to be
mandated for various new features. To back them up - which is wise as
the error checking leaves something to be desired and can leave you
with a non startable instance and a non editable init.ora if you do
things stupidly (or you experiment with new things in a perverse
manner) - then either backup the file using an os utility or use the
new CREATE PFILE <FILENAME> FROM SPFILE <filename> syntax to create an
old fashioned plain text init.ora
cheers
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
On Mon, 7 Jun 2004 10:53:15 -0500, Smith, Ron L. <rlsmith@xxxxxxx> wrote:
>
>
> I am setting up my first new 9.2 database. When I looked at the
> init(sid).ora it looks like there is some binary code at the front and
> end of the file. How do you edit the file now?
>
> Thanks!
> Ron Smith
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
